Amazon
Anthropic
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Palo Alto Networks
Salesforce
SAP
VMware
All Vendors

Snowflake SnowPro Core SnowPro Core Dumps in PDF

Free Snowflake SnowPro Core Real Questions (page: 21)

SnowPro Core PDF — 1300 Questions

Which semi-structured file formats are supported when unloading data from a table? (Choose two.)

  1. ORC
  2. XML
  3. Avro
  4. Parquet
  5. JSON

Answer(s): D,E


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html



A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  1. 1 second
  2. 60 seconds
  3. 5 minutes
  4. 60 minutes

Answer(s): B



What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  1. Authentication
  2. Resource management
  3. Virtual warehouse caching
  4. Query parsing and optimization
  5. Query execution
  6. Physical storage of micro-partitions

Answer(s): A,B,D



How long is the Fail-safe period for temporary and transient tables?

  1. There is no Fail-safe period for these tables.
  2. 1 day
  3. 7 days
  4. 31 days
  5. 90 days

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html



Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  1. PUT
  2. GET
  3. COPY
  4. SELECT

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/sql/get.html



How does Snowflake Fail-safe protect data in a permanent table?

  1. Fail-safe makes data available up to 1 day, recoverable by user operations.
  2. Fail-safe makes data available for 7 days, recoverable by user operations.
  3. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  4. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Answer(s): C



A virtual warehouse is created using the following command:

Create warehouse my_WH with -
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.


What action should be taken to address this situation?

  1. Increase the warehouse size from Medium to 2XL.
  2. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  3. Configure the warehouse to a multi-cluster warehouse.
  4. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer(s): C



Which minimum Snowflake edition allows for a dedicated metadata store?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html



PDF
Viewing page 21 of 139

Share your comments for Snowflake SnowPro Core exam with other users:

A
AI Tutor Explanation
9/24/2026 11:16:10 AM

Question 5:
Correct answer: A — True
Snowflake supports bulk unloading with COPY INTO <location> using a SELECT statement as the source. This allows you to export either:

  • All or selected columns from a table
  • Filtered rows using WHERE
  • Transformed or joined data

Example: 
sql 
COPY INTO @my_stage/export/ 
FROM ( 
  SELECT customer_id, order_date 
  FROM orders 
  WHERE order_date >= '2025-01-01' 
);
Snowflake writes the query results to files in the specified internal or external stage. The key distinction is that COPY INTO is used for bulk movement of data, while a regular SELECT only returns query results and does not unload them to staged files.

Pune, India
A
AI Tutor Explanation
9/3/2026 5:25:59 AM

Question 1:
Correct answer: B — Clustering keys
Snowflake automatically organizes table data into micro-partitions and uses natural clustering based on how data is loaded. However, for large tables where query performance depends on particular columns, you can define a clustering key.
A clustering key:

  • Specifies one or more columns or expressions Snowflake should use when organizing table data.
  • Helps Snowflake’s automatic reclustering keep related rows grouped together.
  • Can improve pruning for queries that frequently filter or join on those columns.

Why the others are incorrect:
  • Micro-partitions: Snowflake’s storage units; users do not directly define them as an override mechanism.
  • Key partitions: Not a Snowflake feature.
  • Clustered partitions: Not the name of the customer-defined mechanism.

The answer key’s B is correct.

Johannesburg, South Africa
A
AI Tutor Explanation
8/28/2026 11:39:56 AM

Question 17:
Correct answer: D — To accommodate a more complex workload.
Increasing a Virtual Warehouse from X-Small to Medium is vertical scaling. The larger warehouse provides more compute resources, which can improve performance for:

  • Complex queries
  • Large scans or joins
  • Resource-intensive transformations
  • Queries involving substantial processing

Why the others are less appropriate:
  • More users / more queries: This usually calls for multi-cluster warehouses, which add clusters to handle concurrency.
  • Fluctuations in workload: This is typically addressed with auto-suspend/auto-resume or multi-cluster scaling, rather than simply choosing a larger warehouse.

Thus, warehouse size primarily affects the compute power available to individual workloads.

Chennai, India
AI Tutor 👋 I’m here to help!