COF-C02 SnowPro Core Certification Exam (COF-C02)

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Exam pool B)

How often are the Account and Table master keys automatically rotated by Snowflake?

Select an option, then click Submit answer.

  • 30 Days

  • 60 Days

  • 90 Days

  • 365 Days.

Question 11 (Exam pool B)

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

Select an option, then click Submit answer.

  • To validate external table files in table t1 across all sessions

  • To validate task SQL statements against table t1 in the last 14 days

  • To validate a file for errors before it gets executed using a COPY command

  • To return errors from the last executed COPY command into table t1 in the current session

Question 12 (Exam pool A)

Which of the following describes how clustering keys work in Snowflake?

Select an option, then click Submit answer.

  • Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

  • Clustering keys sort the designated columns over time, without blocking DML operations

  • Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

  • Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time