COF-C02 Snowflake Exam Questions and Free Practice Test

Question 67

- (Topic 1)
Which Snowflake partner specializes in data catalog solutions?

A. Alation

B. DataRobot

C. dbt

D. Tableau

Correct Answer:A
Alation is known for specializing in data catalog solutions and is a partner of Snowflake. Data catalog solutions are essential for organizations to effectively manage their metadata and make it easily accessible and understandable for users, which aligns with the capabilities provided by Alation.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake??s official documentation and partner listings

Question 68

- (Topic 3)
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A. A VARIANT column

B. A column with very low cardinality

C. A column with very high cardinality

D. A column that is most actively used in selective filters

E. A column that is most actively used in join predicates

Correct Answer:CD
Snowflake recommends using columns with very high cardinality and those that are most actively used in selective filters as clustering keys. High cardinality columns have a wide range of unique values, which helps in evenly distributing the data across micro-partitions. Columns used in selective filters help in pruning the number of micro- partitions to scan, thus improving query performance. References: Based on general database optimization principles.

Question 69

- (Topic 3)
What can a Snowflake user do in the Admin area of Snowsight?

A. Analyze query performance.

B. Write queries and execute them.

C. Provide an overview of the listings in the Snowflake Marketplace.

D. Connect to Snowflake partners to explore extended functionality.

Correct Answer:A
In the Admin area of Snowsight, users can analyze query performance, manage Snowflake warehouses, set up and view details about resource monitors, manage users and roles, and administer Snowflake accounts in their organization2.

Question 70

- (Topic 2)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B. Allows a user to import the files in a sequential order

C. Increases the latency staging and accuracy when loading the data

D. Allows optimization of parallel operations

Correct Answer:D
Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing. Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process

Question 71

- (Topic 6)
Which function is used to unload a relational table into a JSON file*?

A. PARSE_JSON

B. JSON_EXTRACT_PATH_TEXT

C. OBJECT_CONSTRUCT

D. TO_JSON

Correct Answer:D
TheTO_JSONfunction in Snowflake is used to convert a relational table or individual rows into JSON format. This function is helpful for exporting data in JSON format.
✑ Using TO_JSON Function:
SELECT TO_JSON(OBJECT_CONSTRUCT(*))
FROM my_table;
✑ Exporting Data:TheTO_JSONfunction converts the table rows into JSON format, which can then be exported to a file.
References:
✑ Snowflake Documentation: TO_JSON Function
✑ Snowflake Documentation: Exporting Data

Question 72

- (Topic 3)
What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

A. Swift

B. JavaScript

C. Python

D. SQL

Correct Answer:C
The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks. References: Based on general programming and cloud data service knowledge as of 2021.

START COF-C02 EXAM