- (Topic 4)
How can a Snowflake user validate data that is unloaded using the COPY INTO command?

1. A. Load the data into a CSV file.
2. B. Load the data into a relational table.
3. C. Use the VALlDATlON_MODE - SQL statement.
4. D. Use the validation mode = return rows statement.

Correct Answer: C
To validate data unloaded using the COPY INTO <location> command, a Snowflake user can use the VALIDATION_MODE parameter within the SQL statement to test the files for errors without loading them3.

- (Topic 6)
While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?
A)
MISSING
B)

C)

D)

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: A
In Snowflake, auto-scaling allows virtual warehouses to automatically start additional clusters to handle increasing query loads. The setting that triggers the immediate startof additional clusters when a warehouse is running in auto-scale mode is:A. MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters: When the maximum number of clusters (MAX_CLUSTER_COUNT) is increased and the new maximum is higher than the number of clusters currently running (running_clusters), additional clusters will start immediately if required by the workload. This configuration ensures that performance scales with demand by allowing more compute resources to be provisioned as needed.
This behavior is designed to maintain performance by dynamically adjusting the compute resources without manual intervention, ensuring that queries are executed with minimal delay, even under varying workloads. It aligns with the principles of elasticity and scalability in cloud computing, particularly within Snowflake's architecture.

- (Topic 6)
The following settings are configured:
For how many days will the data be retained at the object level?

1. A. 2
2. B. 3
3. C. 5
4. D. 7

Correct Answer: A
The settings shown in the image indicate that the data retention time in days is configured at two different levels: the account level and the object level. At the account level, theMIN_DATA_RETENTION_TIME_IN_DAYSis set to 5 days, and at the object level, theDATA_RETENTION_TIME_IN_DAYSis set to 2 days. Since the object level setting has a lower value, it takes precedence over the account level setting for the specific object. Therefore, the data will be retained for 2 days at the object level.References:Snowflake Documentation on Data Retention Policies

- (Topic 1)
What feature can be used to reorganize a very large table on one or more columns?

1. A. Micro-partitions
2. B. Clustering keys
3. C. Key partitions
4. D. Clustered partitions

Correct Answer: B
Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the arrangement of data within micro- partitions to improve query performance, especially for large tables where efficient data retrieval is crucial. References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

- (Topic 3)
Which statement describes pruning?

1. A. The filtering or disregarding of micro-partitions that are not needed to return a query.
2. B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
3. C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
4. D. The ability to allow the result of a query to be accessed as if it were a table.

Correct Answer: A
Pruning in Snowflake refers to the process of filtering or disregarding micro- partitions that are not needed to satisfy the conditions of a query. This optimization technique helps reduce the amount of data scanned, thereby improving query performance