Snowflake COF-R02 Exam Questions

Question 6 of 52

What does a Notify & Suspend action for a resource monitor do?

Send an alert notification to all account users who have notifications enabled.

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

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.

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

A Notify & Suspend action for a resource monitor sends a notification to all account administrators who have notifications enabled and suspends all assigned warehouses after all statements being executed by the warehouses have completed. This ensures that current operations are not disrupted abruptly, maintaining the integrity of ongoing processes.

Question 7 of 52

Which statements describe benefits of Snowflake's separation of compute and storage? (Choose two.)

The separation allows independent scaling of computing resources.

The separation ensures consistent data encryption across all virtual data warehouses.

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

Storage volume growth and compute usage growth can be tightly coupled.

Compute can be scaled up or down without the requirement to add more storage.

Correct Answer: A, E

Question 8 of 52

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

DATA_RETENTION_TIME_IN_DAYS

MAX_DATA_EXTENSION_TIME_IN_DAYS

MIN_DATA_RETENTION_TIME_IN_DAYS

MAX_CONCURRENCY_LEVEL

Correct Answer: C

Question 9 of 52

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Account

Database

Schema

Table

Correct Answer: A

Question 10 of 52

What type of function returns one value for each invocation?

Aggregate

Scalar

Table

Window

Correct Answer: B