Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1201:

  Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?

  A. Java

  B. JavaScript

  C. SQL

  D. Python

  Correct Answer: ABCD

  Reference: https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

• Question 1202:

  What is the minimum duration charged when starting a virtual warehouse?

  A. 1 second

  B. 1 minute

  C. 1 hour

  D. 1 day

  Correct Answer: B

• Question 1203:

  Which of the following terms best describes Snowflake's database architecture?

  A. Columnar shared nothing

  B. Shared disk

  C. Multi-cluster, shared data

  D. Cloud-native shared memory

  Correct Answer: C

  https://www.snowflake.com/product/architecture/

  Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

• Question 1204:

  Which of the following are options when creating a Virtual Warehouse?

  A. Auto-suspend

  B. Auto-resume

  C. Local SSD size

  D. User count

  Correct Answer: AB

• Question 1205:

  Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  A. Custom

  B. Economy

  C. Optimized

  D. Standard

  Correct Answer: BD

  Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

• Question 1206:

  Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:

  Choose 2 answers

  A. Temporary Tables

  B. Transient Tables

  C. Provisional Tables

  D. Permanent Tables

  Correct Answer: AB

  Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

• Question 1207:

  When loading data into Snowflake, the COPY command supports: Choose 2 answers

  A. Joins

  B. Fitters

  C. Data type conversions

  D. Column reordering

  E. Aggregates

  Correct Answer: CD

• Question 1208:

  Which of the following objects is not covered by Time Travel?

  A. Tables

  B. Schemas

  C. Databases

  D. Stages

  Correct Answer: D

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

• Question 1209:

  Which function unloads data from a relational table to JSON?

  A. TRUNC(ID_NUMBER, -6)

  B. TRUNC(ID_NUMBER, 5)

  C. ID_NUMBER * 100

  D. TO_CHAR(ID_NUMBER)

  Correct Answer: D

  To unload data from a relational table to JSON format, you can use the TO_JSON function, not TO_CHAR. The TO_JSON function converts relational data, including numbers and strings, into a valid JSON format. TO_CHAR is typically used for formatting numbers or dates into string formats but is not used directly for JSON serialization. Therefore, TO_JSON or OBJECT_CONSTRUCT would be more appropriate for unloading data to JSON.

  References: Snowflake Documentation: TO_JSON Function Snowflake Documentation: OBJECT_CONSTRUCT Function