- (Topic 4)
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

1. A. Access history
2. B. Data classification
3. C. Dynamic Data Masking
4. D. Object tagging

Correct Answer: A
The Access History feature in Snowflake allows administrators to track data access patterns and identify unused data. This information can be used to make decisions about archiving or deleting data to optimize storage and reduce costs.

- (Topic 5)
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

1. A. 60 minutes
2. B. 24 hours
3. C. 14 days
4. D. 30 days

Correct Answer: C
In the Snowflake Web Interface (UI), the Query History page displays the history of queries executed in Snowflake for up to 14 days. This allows users to review and analyze their query performance, troubleshoot issues, and understand their query patterns over a two-week period. The Query History page is a critical tool for monitoring and optimizing the use of Snowflake.
References:
✑ Snowflake Documentation: Using the Web Interface

- (Topic 1)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

1. A. True
2. B. False

Correct Answer: B
Reader accounts in Snowflake are designed to allow users to read data shared with them but do not have the capability to extract data for use outside of Snowflake. They are intended for consuming shared data within the Snowflake environment only.

- (Topic 4)
What step can reduce data spilling in Snowflake?

1. A. Using a larger virtual warehouse
2. B. Increasing the virtual warehouse maximum timeout limit
3. C. Increasing the amount of remote storage for the virtual warehouse
4. D. Using a common table expression (CTE) instead of a temporary table

Correct Answer: A
To reduce data spilling in Snowflake, using a larger virtual warehouse is effective because it provides more memory and local disk space, which can accommodate larger data operations and minimize the need to spill data to disk or remote storage1. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 2)
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

1. A. INSERT
2. B. PUT
3. C. GET
4. D. COPY

Correct Answer: D
The COPY command is used in Snowflake to load data from files located in an external stage into a table. This command allows for efficient and parallelized data loading from various file formats1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation