Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 291:

  Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

  A. Schemas
  B. Roles
  C. Secure Views
  D. Stored Procedures
  E. Tables
  F. Secure User-Defined Functions (UDFs)
  C. Secure Views
  E. Tables
  F. Secure User-Defined Functions (UDFs)

  ---

  Explanation

• Question 292:

  Which metrics are provided in the Query Profile?

  A. Query execution time and number of rows processed
  B. Data retention period and backup schedules
  C. Roles and permission of users running the queries
  D. The costs of running queries by user
  A. Query execution time and number of rows processed

  ---

  Explanation

  The Query Profile tool provides a visual breakdown of query execution including:

  Execution time per step

  Rows processed, scanned, or returnedThis helps analyze performance bottlenecks and optimize SQL.

  Snowflake Docs: Query Profile

• Question 293:

  If DATA_RETENTION_TIME_IN_DAYS = 7 and MAX_DATA_EXTENSION_TIME_IN_DAYS = 8 are set. How many days will pass before a stream becomes stale?

  A. 7
  B. 8
  C. 14
  D. 15
  D. 15

  ---

  Explanation

• Question 294:

  A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

  A. The primary cluster in the virtual warehouse
  B. The entire virtual warehouse
  C. The database in which the virtual warehouse resides
  D. The Queries currently being run on the virtual warehouse
  B. The entire virtual warehouse

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in %20the%20warehouse.

• Question 295:

  If a multi-cluster virtual warehouse is running in Auto-scale mode, how are workloads with unpredictable usage patterns handled?

  A. Snowflake automatically resizes the warehouse based on usage requirements.
  B. Snowflake automatically starts and stops additional clusters as needed.
  C. Snowflake notifies users when to adjust the number of clusters to improve workload performance.
  D. Snowflake automatically starts additional clusters when the primary cluster reaches 50% capacity.
  B. Snowflake automatically starts and stops additional clusters as needed.

  ---

  Explanation

  In Auto-scale mode, a multi-cluster virtual warehouse can automatically scale out by starting additional clusters as needed to handle concurrent queries . This is ideal for unpredictable or bursty workloads.

  Clusters spin up based on queue length and system load .

  They automatically shut down when not in use .

  Snowflake Docs: Multi-Cluster Warehouses

• Question 296:

  Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)

  A. Bytes scanned
  B. Bytes written to result
  C. Partitions scanned
  D. Partitions total
  E. Percentage scanned from cache
  C. Partitions scanned
  D. Partitions total

  ---

  Explanation

• Question 297:

  Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  A. parse_json()
  B. json_extract_path_text()
  C. object_construct()
  D. flatten
  A. parse_json()

  ---

  Explanation

• Question 298:

  Which function should be used to insert JSON formatted string data into a VARIANT field?

  A. FLATTEN
  B. CHECK_JSON
  C. PARSE_JSON
  D. TO_VARIANT
  C. PARSE_JSON

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions/to_json

• Question 299:

  How does the search optimization service improve query performance?

  A. By clustering the tables
  B. By creating a persistent data structure
  C. By using caching
  D. By optimizing the use of micro-partitions
  B. By creating a persistent data structure

  ---

  Explanation

  The Search Optimization Service in Snowflake enhances query performance by creating a persistent data structure that enables faster access to specific data, particularly for queries with selective filters on columns not often used in clustering. This persistent structure accelerates data retrieval without depending on clustering or caching, thereby improving response times for targeted queries. Snowflake's micro-partitioning automatically manages table structure, but search optimization allows further enhancement for certain high-frequency, specific access patterns.

• Question 300:

  What is the MINIMUM Snowflake edition required to use a dedicated metadata store?

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

  ---

  Explanation