Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 521:

  Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

  A. NOTIFY
  B. NOTIFY_USERS
  C. SUSPEND
  D. SUSPEND_IMMEDIATE
  D. SUSPEND_IMMEDIATE

  ---

  Explanation

• Question 522:

  A network policy applied at the user level takes precedence over a network policy applied to what Snowflake object?

  A. A role
  B. An account
  C. A database
  D. An organization
  B. An account

  ---

  Explanation

  A network policy applied at the user level takes precedence over an account-level network policy.

  This allows for more granular control of network access for individual users.

  References:

  Snowflake Documentation: Network Policies

• Question 523:

  Which of the following describes how clustering keys work in Snowflake?

  A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
  B. Clustering keys sort the designated columns over time, without blocking DML operations
  C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
  D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
  B. Clustering keys sort the designated columns over time, without blocking DML operations

  ---

  Explanation

• Question 524:

  How does Snowflake support Multi-Factor Authentication (MFA) with a second factor device?

  A. Through Role-Based Access Control (RBAC)
  B. Through integration with OAuth
  C. Using time-based, one-time passcodes
  D. Using federated authentication and Single Sign-On (SSO)
  C. Using time-based, one-time passcodes

  ---

  Explanation

• Question 525:

  What will happen if the volume of data stored in Snowflake increases over time?

  A. Snow ake will automatically increase the size of the virtual warehouse used to run queries against the storage data.
  B. The number of clusters in the active virtual warehouse being used will scale automatically to accommodate the increased storage data volume.
  C. As the stored data volume increases, the warehouse performance will decline.
  D. The warehouse performance and size will not be affected when the volume of stored data increases.
  D. The warehouse performance and size will not be affected when the volume of stored data increases.

  ---

  Explanation

• Question 526:

  What happens to deleted or modified records during the Time Travel retention period?

  A. They are permanently deleted.
  B. They are moved to a separate table.
  C. They are versioned for recovery.
  D. They are archived in a backup.
  C. They are versioned for recovery.

  ---

  Explanation

• Question 527:

  Who can grant object privileges in a regular schema?

  A. Object owner
  B. Schema owner
  C. Database Owner
  D. SYSADMIN
  A. Object owner

  ---

  Explanation

• Question 528:

  Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

  A. Caching
  B. Cluster depth
  C. Query pruning
  D. Retrieval optimization
  C. Query pruning

  ---

  Explanation

  https://blog.devgenius.io/snowflake-micro-partitions-clustering-keys-dbt-b6cb1212dcbe

• Question 529:

  Which metadata does Snowflake store about the rows in a micro-partition? (Select TWO).

  A. The range of values for each column
  B. The average values for each column
  C. The number of distinct values
  D. The total number of values
  E. The number of times each column has been queried
  A. The range of values for each column
  C. The number of distinct values

  ---

  Explanation

• Question 530:

  What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).

  A. INSERT
  B. UPDATE
  C. DELETE
  D. TRUNCATE
  E. UPSERT
  A. INSERT
  C. DELETE

  ---

  Explanation

  In Snowflake streams, theMETADATASACTIONcolumn indicates the type of data manipulation operation that has occurred. The possible values includeINSERTandDELETE. INSERT:Indicates that a new row has been inserted into the table. DELETE:Indicates that a row has been deleted from the table.

  References: Snowflake Documentation: Change Data Capture (CDC) with Streams Snowflake Documentation: Stream Data Capture