SnowPro Core Certification COF-C02 Exam Dumps

SnowPro Core Certification Exam (COF-C02) Questions and Answers

Question 21

For which use cases is running a virtual warehouse required? (Select TWO).

When creating a table

When loading data into a table

When unloading data from a table

When executing a show command

When executing a list command

Question 22

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Question 23

How should clustering be used to optimize the performance of queries that run on a very large table?

Manually re-cluster the table regularly.

Choose one high cardinality column as the clustering key.

Use the column that is most-frequently used in query select clauses as the clustering key.

Assess the average table depth to identify how clustering is impacting the query.

Question 24

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

Data:employee.name

DATA:employee.name

data:Employee.name

data:employee.name