COF-C02 Free Practice Test

- (Topic 4)
What does a Notify & Suspend action for a resource monitor do?

1. A. Send an alert notification to all account users who have notifications enabled.
2. B. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
3. C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
4. D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

Correct Answer: C
The Notify & Suspend action for a resource monitor in Snowflake sends a notification to all account administrators who have notifications enabled and suspends all assigned warehouses. However, the suspension only occurs after all currently running statements in the warehouses have been completed1. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
From what stage can a Snowflake user omit the FROM clause while loading data into a table?

1. A. The user stage
2. B. The table stage
3. C. The internal named stage
4. D. The external named stage

Correct Answer: B
In Snowflake, when loading data into a table using the COPY INTO command, the FROM clause can be omitted if loading from the table's stage, also known as the table stage. The table stage is a default location associated with each table where files can be temporarily stored for loading operations. This simplifies the data loading process by allowing direct loading from files that have been uploaded to the table's stage without specifying the stage explicitly in the COPY INTO command.
References:
✑ Snowflake Documentation: Loading Data into Tables

- (Topic 4)
A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1 ;?

1. A. The temporary table will take precedence over the permanent table.
2. B. The permanent table will take precedence over the temporary table.
3. C. An error will say there cannot be two tables with the same name in a schema.
4. D. The table that was created most recently will take precedence over the older table.

Correct Answer: A
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.

- (Topic 3)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro- partitions?

1. A. Enterprise
2. B. Business Critical
3. C. Standard
4. D. Virtual Private Snowflake

Correct Answer: A
Periodic rekeying of micro-partitions is a feature that requires the Enterprise Edition of Snowflake or higher. This feature is part of Snowflake??s comprehensive approach to encryption key management, ensuring data security through regular rekeying1. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 4)
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?

1. A. File URL
2. B. Staged URL
3. C. Scoped URL
4. D. Pre-signed URL

Correct Answer: D
A Pre-signed URL should be used to access files stored in a Snowflake stage without requiring authentication into Snowflake. Pre-signed URLs are simple HTTPS URLs that provide temporary access to a file via a web browser, using a pre-signed access token. The expiration time for the access token is configurable, and this type of URL allows users or applications to directly access or download the files without needing to authenticate into Snowflake5.
References: [COF-C02] SnowPro Core Certification Exam Study Guide