Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 151:

  Which role has the ability to create and manage users and roles?

  A. ORGADMIN

  B. USERADMIN

  C. SYSADMIN

  D. SECURITYADMIN

  Correct Answer: B

• Question 152:

  What issues can be identified and troubleshooted using the Query Profile? (Choose two.)

  A. Full index scans

  B. Cartesian products

  C. Insufficient privileges

  D. Queries too large to fit in memory

  E. Virtual warehouse credit consumption

  Correct Answer: BD

• Question 153:

  Which table function is used to view all errors encountered during a previous data load?

  A. VALIDATE

  B. INFER_SCHEMA

  C. GENERATOR

  D. QUERY_HISTORY

  Correct Answer: A

• Question 154:

  A user wants to access files stored in a stage without authenticating into Snowflake.

  Which type of URL should be used?

  A. File URL

  B. Staged URL

  C. Scoped URL

  D. Pre-signed URL

  Correct Answer: D

• Question 155:

  Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)

  A. Partitions scanned

  B. Partitions total

  C. Bytes scanned

  D. Bytes spilled

  E. Bytes written

  Correct Answer: AB

• Question 156:

  Which operation can be performed on Snowflake external tables?

  A. INSERT

  B. JOIN

  C. RENAME

  D. ALTER

  Correct Answer: B

• Question 157:

  What does a table with a clustering depth of 1 mean in Snowflake?

  A. The table has only 1 micro-partition.

  B. The table has 1 overlapping micro-partition.

  C. The table has no overlapping micro-partitions.

  D. The table has no micro-partitions.

  Correct Answer: C

• Question 158:

  What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?

  A. Faster query performance and increased storage consumption

  B. Slower query performance and increased storage consumption

  C. Faster query performance and decreased storage consumption

  D. Slower query performance and decreased storage consumption

  Correct Answer: B

• Question 159:

  Which Snowflake object contains all the information required to share a database?

  A. Private listing

  B. Secure view

  C. Sequence

  D. Share

  Correct Answer: D

• Question 160:

  What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

  A. The type of SQL statements executed

  B. The number of tables or databases queried

  C. The amount of data stored in the warehouse

  D. The length of time the compute resources in each cluster run

  Correct Answer: D