Snowflake Updated COF-C02 Exam Questions and Answers by oona

To prevent backlogs of queued SQL statements:

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS (A): Sets a timeout for how long a query can wait in the queue. Queries that exceed this time are terminated, preventing long queues.

MAX_CONCURRENCY_LEVEL (D): Controls the maximum number of concurrent queries the virtual warehouse can execute. Increasing this value reduces queuing.

Why Other Options Are Incorrect:

B. STATEMENT_TIMEOUT_IN_SECONDS: Defines the total execution time for queries, not queuing behavior.

C. DATA_RETENTION_TIME_IN_DAYS: Related to table retention policies, not query concurrency.

E. MAX_DATA_EXTENSION_TIME_IN_DAYS: Related to time travel, not query queuing.

References:

Managing Query Concurrency

Resource monitors in Snowflake are tools used to track and control the consumption of compute resources, ensuring that usage stays within defined limits. These monitors can be created at the account level, allowing administrators to set overall resource consumption limits for the entire Snowflake account. Additionally, resource monitors can be set at the virtual warehouse level, enabling more granular control over the resources consumed by individual warehouses. This dual-level capability allows organizations to manage their Snowflake usage efficiently, preventing unexpected costs and optimizing performance.References: Snowflake Documentation on Resource Monitors

Top of Form

Data Encryption in Snowflake:

A. After micro-partitioning: Data stored in Snowflake is encrypted at rest after it is organized into micro-partitions.

C. After loading into an internal stage: Snowflake encrypts all data stored in internal stages automatically.

Why Other Options Are Incorrect:

B. After loading into a table: Encryption occurs during the micro-partitioning stage, which precedes this step.

D. External stage: Data encryption in external stages depends on the external storage provider, not Snowflake.

E. Only when using an encrypted stage: This is incorrect because encryption is automatic for internal stages and tables.

References:

Data Encryption in Snowflake

When accessing unstructured data files in Snowflake, the HTTPS URL identifies the database, schema, stage, and file path.

Example:

https:// .snowflakecomputing.com////

References:

Snowflake Documentation: Managing Unstructured Data