Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1281:

  Which virtual warehouse con guration is recommended speci cally for a steady workload that has no execution lag?

  A. AUTO_RESUME = FALSE
  B. AUTO_SUSPEND = 0
  C. STATEMENT_TIMEOUT_IN_SECONDS = 3600
  D. MIN_CLUSTER_COUNT = 1 - MAX_CLUSTER_COUNT = 3
  D. MIN_CLUSTER_COUNT = 1 - MAX_CLUSTER_COUNT = 3

  ---

  Explanation

• Question 1282:

  What will happen to partitions if a table is cloned and the original table type is then changed from permanent to transient?

  A. Old partitions will not be changed to transient, but any new partitions added to the clone will follow the transient lifecycle.
  B. Old partitions will be changed to transient, and any new partitions added to the clone will follow the transient lifecycle.
  C. Both old and new partitions will be changed to transient, but the original table will keep the original table type.
  D. Both old and new partitions will be changed to transient, and the original table type will change to transient.
  A. Old partitions will not be changed to transient, but any new partitions added to the clone will follow the transient lifecycle.

  ---

  Explanation

• Question 1283:

  This statement is run:

  SELECT { 'key' : { 'subkey': 'value' }} mycolumn;

  What notations will retrieve the 'value' from the VARIANT column? (Choose two.)

  A. mycolumn.key.subkey
  B. mycolumn.key:subkey
  C. mycolumn:key.subkey
  D. mycolumn['key'].subkey
  E. mycolumn:key:subkey
  B. mycolumn.key:subkey
  E. mycolumn:key:subkey

  ---

  Explanation

• Question 1284:

  Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?

  A. Permanent table
  B. External table
  C. Temporary table
  D. Transient table
  D. Transient table

  ---

  Explanation

  Transient Tables:

  Why Other Options Are Incorrect:

  A. Permanent table: Supports Fail-safe and incurs additional costs.

  B. External table: Stores metadata for external data but does not store actual data.

  C. Temporary table: Data persists only within a session and is not suitable for multi-session use.

  References:

  Transient Tables Documentation

• Question 1285:

  Which view will show the MOST recent information about table-level storage utilization?

  A. The TABLE_STORAGE_METRICS view in a Snowflake data share
  B. The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
  C. The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA
  D. The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA
  C. The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA

  ---

  Explanation

• Question 1286:

  What privileges are required to execute a task?

  A. To execute a task, you need the EXECUTE TASK.
  B. A task is an account-level object and can only be executed by the Account Admin role.
  C. Tasks run automatically and do run under any rote.
  D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
  A. To execute a task, you need the EXECUTE TASK.

  ---

  Explanation

• Question 1287:

  Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

  A. RETURN_-1_ROWS
  B. RETURN_n_ROWS
  C. RETURN_ERRORS
  D. RETURN_ALL_ERRORS
  D. RETURN_ALL_ERRORS

  ---

  Explanation

• Question 1288:

  How can data be shared in Snowflake with another account located in the same region without the need to copy or move the data?

  A. Use the Snowflake Marketplace
  B. Use a stream
  C. Use a Data Exchange
  D. Use a direct share
  D. Use a direct share

  ---

  Explanation

  Direct Shares allow secure data sharing between Snowflake accounts in the same region . No data is copied; Snowflake provides access to the original data using metadata and access control.

  Snowflake Docs: Data Sharing

• Question 1289:

  When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

• Question 1290:

  A clustering key was defined on a table, but it is no longer needed. How can the key be removed?

  A. ALTER TABLE PURGE CLUSTERING KEY
  B. ALTER TABLE DELETE CLUSTERING KEY
  C. ALTER TABLE DROP CLUSTERING KEY
  D. ALTER TABLE REMOVE CLUSTERING KEY
  C. ALTER TABLE DROP CLUSTERING KEY

  ---

  Explanation