- (Topic 1)
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

Correct Answer:A
The list command in Snowflake is used to validate and display the list of files in a specified stage. When a user has unloaded data to a stage, running the list @file stage command will show all the files that have been uploaded to that stage, allowing the user to verify the data that was unloaded.
References:
✑ Snowflake Documentation on Stages
✑ SnowPro® Core Certification Study Guide

- (Topic 1)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Correct Answer:AC
In the query profiler view, the components that represent areas that can be used to help optimize query performance include ??Bytes scanned?? and ??Number of partitions scanned??. ??Bytes scanned?? indicates the total amount of data the query had to read and is a direct indicator of the query??s efficiency. Reducing the bytes scanned can lead to lower data transfer costs and faster query execution. ??Number of partitions scanned?? reflects how well the data is clustered; fewer partitions scanned typically means better performance because the system can skip irrelevant data more effectively.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Query Profiling1

- (Topic 3)
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Correct Answer:C
The Snowflake object that helps evaluate virtual warehouse performance impacted by query queuing is the Information_schema.warehouse_load_history. This view provides historical data about the load on a warehouse, including the average number of queries that were running or queued within a specific interval, which can be used to assess performance and identify potential issues with query queuing3.

- (Topic 1)
What data is stored in the Snowflake storage layer? (Select TWO).

Correct Answer:BD
The Snowflake storage layer is responsible for storing data in an optimized, compressed, columnar format. This includes micro-partitions, which are the fundamental storage units that contain the actual data stored in Snowflake. Additionally, persisted query results, which are the results of queries that have been materialized and stored for future use, are also kept within this layer. This design allows for efficient data retrieval and management within the Snowflake architecture1.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Key Concepts & Architecture | Snowflake Documentation2

- (Topic 2)
The is the minimum Fail-safe retention time period for transient tables?

Correct Answer:D
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days. This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables

- (Topic 1)
Which copy INTO command outputs the data into one file?

Correct Answer:B
The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of files generated by the command, ensuring that only one file is created
regardless of the amount of data being exported.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Data Unloading