Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1291:

  Which function determines the kind of value stored in a VARIANT column?

  A. CHECK_JSON
  B. IS_ARRAY
  C. IS_JSON
  D. TYPEOF
  D. TYPEOF

  ---

  Explanation

  Reports the type of a value stored in a VARIANT column. The type is returned as a string. https://docs.snowflake.com/en/sql-reference/functions/typeof

• Question 1292:

  Which statistic displayed in a Query Profile is specific to external functions?

  A. Bytes written
  B. Total invocations
  C. Partitions scanned
  D. Bytes sent over the network
  D. Bytes sent over the network

  ---

  Explanation

• Question 1293:

  Which data governance control has Snowflake embedded in the application?

  A. Network policies
  B. Credit computation
  C. Data storage
  D. Attribute-based access control
  D. Attribute-based access control

  ---

  Explanation

• Question 1294:

  What data type should be used to store JSON data natively in Snowflake?

  A. JSON
  B. String
  C. Object
  D. VARIANT
  D. VARIANT

  ---

  Explanation

• Question 1295:

  What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)

  A. Bytes spilled to local cache.
  B. Bytes spilled to local storage.
  C. Bytes spilled to remote cache.
  D. Bytes spilled to remote storage.
  E. Bytes spilled to remote metastore.
  B. Bytes spilled to local storage.
  D. Bytes spilled to remote storage.

  ---

  Explanation

• Question 1296:

  How can a user access information about a query execution plan without consuming virtual warehouse compute resources?

  A. Use the EXPLAIN function.
  B. Review the Query Profile metrics.
  C. Review the data in the Account_Usage view.
  D. Use the Snowsight dashboard.
  A. Use the EXPLAIN function.

  ---

  Explanation

• Question 1297:

  What is the MINIMUM Snowflake edition required to use the query acceleration service?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  B. Enterprise

  ---

  Explanation

• Question 1298:

  What storage cost is completely eliminated when a Snowflake table is defined as transient?

  A. Active
  B. Fail-safe
  C. Staged
  D. Time Travel
  B. Fail-safe

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-temp-transient

• Question 1299:

  What is the MAXIMUM number of days a Snowflake-managed encryption key can be used before it gets automatically rotated?

  A. 1 day
  B. 14 days
  C. 30 days
  D. 120 days
  C. 30 days

  ---

  Explanation

• Question 1300:

  Which table function is used to view all errors encountered during a previous data load?

  A. VALIDATE
  B. INFER_SCHEMA
  C. GENERATOR
  D. QUERY_HISTORY
  A. VALIDATE

  ---

  Explanation