Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 431:

  What is the impact on queries that are being executed when a resource monitor set to the "Notify and Suspend" threshold level is exceeded?

  A. All statements being executed are queued.

  B. All statements being executed are restarted.

  C. All statements being executed are cancelled.

  D. All statements being executed are completed.

  Correct Answer: D

  Notify and Suspend

  Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses after all statements being executed by the warehouse(s) have completed.

  Notify and Suspend Immediately

  Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses immediately, which cancels any statements being executed by the warehouses at the time.

  Notify

  Perform no action, but send an alert notification (to all account administrators with notifications enabled).

• Question 432:

  What does the "percentage scanned from cache" represent in the Query Profile?

  A. The percentage of data scanned from the query cache

  B. The percentage of data scanned from the result cache

  C. The percentage of data scanned from the remote disk cache

  D. The percentage of data scanned from the local disk cache

  Correct Answer: D

• Question 433:

  Which role has the ability to create a share from a shared database by default?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. ORGADMIN

  Correct Answer: A

• Question 434:

  Which object-level parameters can be set to help control query processing and concurrency? (Choose two).

  A. MAX_CONCURRENCY_LEVEL

  B. DATA_RETENTION_TIME_IN_DAYS

  C. MIN_DATA_RETENTION_TIME_IN_DAYS

  D. STATEMENT_TIMEOUT_IN_SECONDS

  E. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  Correct Answer: DE

• Question 435:

  What metadata does Snowflake store for rows in micro-partitions? (Choose two.)

  A. Range of values

  B. Distinct values

  C. Index values

  D. Sorted values

  E. Null values

  Correct Answer: AB

• Question 436:

  What are valid sub-clauses to the OVER clause for a window function? (Choose two.)

  A. GROUP BY

  B. LIMIT

  C. ORDER BY

  D. PARTITION BY

  E. UNION ALL

  Correct Answer: CD

• Question 437:

  Which kind of Snowflake table stores file-level metadata for each file in a stage?

  A. Directory

  B. External

  C. Temporary

  D. Transient

  Correct Answer: A

  The kind of Snowflake table that stores file-level metadata for each file in a stage is called a directory table

  https://docs.snowflake.com/en/user-guide/data-load-dirtables

• Question 438:

  Which activities are included in the Cloud Services layer? (Choose two.)

  A. Data storage

  B. Dynamic data masking

  C. Partition scanning

  D. User authentication

  E. Infrastructure management

  Correct Answer: DE

  The Cloud Services layer in Snowflake is responsible for critical data-related activities1. Services managed in this layer include:

  Authentication Infrastructure management Metadata management Query parsing and optimization Access control

• Question 439:

  While attempting to avoid data duplication, which COPY INTO option should be used to load files with expired load metadata?

  A. LOAD_UNCERTAIN_FILES

  B. FORCE

  C. VALIDATION_MODE

  D. LAST_MODIFIED

  Correct Answer: A

  To load files whose metadata has expired, set the LOAD_UNCERTAIN_FILES copy option to true. The copy option references load metadata, if available, to avoid data duplication, but also attempts to load files with expired load metadata.

• Question 440:

  Which data types can be used in Snowflake to store semi-structured data? (Choose two.)

  A. ARRAY

  B. BLOB

  C. CLOB

  D. JSON

  E. VARIANT

  Correct Answer: AE