Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 371:

  A JSON document is stored in the source_column of type VARIANT. The document has an array called elements. The array contains the name key that has a string value. How can a Snowflake user extract the name from the first element?

  A. source_column.elements[1]:name

  B. source_column.elements[0]:name

  C. source_column:elements[1].name

  D. source_column:elements[0].name

  Correct Answer: D

• Question 372:

  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

  Correct Answer: C

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

• Question 373:

  Which permission on a Snowflake virtual warehouse allows the role to resize the warehouse?

  A. ALTER

  B. MODIFY

  C. MONITOR

  D. USAGE

  Correct Answer: B

  https://stackoverflow.com/questions/67444656/how-do-you-restrict-a-warehouse-to-resize-to-role-in-snowflake

• Question 374:

  What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

  A. Hierarchical key model

  B. Client-side encryption

  C. Tri-secret secure encryption

  D. Key pair authentication

  Correct Answer: C

  https://www.phdata.io/blog/encrypting-snowflake-data-with-own-keys/

• Question 375:

  What is the COPY INTO command option default for unloading data into multiple files?

  A. SINGLE = 0

  B. SINGLE = NULL

  C. SINGLE = TRUE

  D. SINGLE = FALSE

  Correct Answer: D

• Question 376:

  A size 3X-Large multi-cluster warehouse runs one cluster for one full hour and then runs two clusters for the next full hour. What would be the total number of credits billed?

  A. 64

  B. 128

  C. 149

  D. 192

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/warehouses-overview

• Question 377:

  What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?

  A. Improved performance for small, simple queries

  B. Improved performance for large, complex queries

  C. Decreased performance for large, complex queries

  D. Decreased consumption of Snowflake credits

  Correct Answer: C

• Question 378:

  By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

  A. 0 days

  B. 1 day

  C. 7 days

  D. 14 days

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/data-time-travel

• Question 379:

  What type of query will benefit from the query acceleration service?

  A. Queries without filters or aggregation

  B. Queries with large scans and selective filters

  C. Queries where the GROUP BY has high cardinality

  D. Queries of tables that have search optimization service enabled

  Correct Answer: B

  Examples of the types of workloads that might benefit from the query acceleration service:

  1) Ad hoc analytics.

  2) Workloads with unpredictable data volume per query.

  3) Queries with large scans and selective filters.

  https://docs.snowflake.com/en/user-guide/query-acceleration-service#label-query-acceleration-scale-factor

• Question 380:

  How does the search optimization service help Snowflake users improve query performance?

  A. It scans the micro-partitions based on the joins used in the queries and scans only join columns.

  B. It maintains a persistent data structure that keeps track of the values of the table's columns in each of its micro-partitions.

  C. It scans the local disk cache to avoid scans on the tables used in the query.

  D. It keeps track of running queries and their results and saves those extra scans on the table.

  Correct Answer: B

  To improve performance for point lookups, the search optimization service creates and maintains a persistent data structure called a search access path. The search access path keeps track of which values of the table's columns might be found in each of its micro-partitions, allowing some to be skipped when scanning the table.

  https://docs.snowflake.com/en/user-guide/search-optimization-service#how-does-the-search-optimization-service-work