COF-C02 Free Practice Test

- (Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

1. A. The warehouse size does not change until all queries currently running in the warehouse have completed.
2. B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
3. C. The warehouse size does not change until the warehouse is suspended and restarted.
4. D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer: D
The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse size has been changed. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 5)
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

1. A. GROUP BY
2. B. LIMIT
3. C. ORDER BY
4. D. PARTITION BY
5. E. UNION ALL

Correct Answer: CD
Valid sub-clauses to theOVERclause for a window function in SQL are:
✑ C. ORDER BY: This clause specifies the order in which the rows in a partition are processed by the window function. It is essential for functions that depend on the row order, such as ranking functions.
✑ D. PARTITION BY: This clause divides the result set into partitions to which the window function is applied. Each partition is processed independently of other partitions, making it crucial for functions that compute values across sets of rows that share common characteristics.
These clauses are fundamental to defining the scope and order of data over which the window function operates, enabling complex analytical computations within SQL queries. References:
✑ Snowflake Documentation: Window Functions

- (Topic 2)
How long is the Fail-safe period for temporary and transient tables?

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

Correct Answer: A
Temporary and transient tables in Snowflake do not have a Fail-safe period. Once the session ends or the tables are dropped, the data is purged and not recoverable1.
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

- (Topic 2)
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

1. A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
2. B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
3. C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
4. D. A user cannot specify a default warehouse when using the ODBC driver.
5. E. The default virtual warehouse size can be changed at any time.

Correct Answer: CE
Snowflake virtual warehouses support a configuration file and command line options in SnowSQL to specify a default warehouse, which is characteristic C. Additionally, the size of a virtual warehouse can be changed at any time, which is characteristic E. These features provide flexibility and ease of use in managing compute resources2. References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (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.