Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 571:

  When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?

  A. BROTLI

  B. GZIP

  C. LZO

  D. ZSTD

  Correct Answer: C

• Question 572:

  Which data type is supported by Snowflake data classification?

  A. Binary

  B. Float

  C. Geography

  D. Variant

  Correct Answer: B

• Question 573:

  The information schema provides storage information for which of the following objects? (Choose two.)

  A. Users

  B. Databases

  C. Internal stages

  D. Resource monitors

  E. Pipes

  Correct Answer: BE

• Question 574:

  What should be considered when deciding to use a Secure View? (Choose two.)

  A. No details of the query execution plan will be available in the query profiler.

  B. Once created there is no way to determine if a view is secure or not.

  C. Secure views do not take advantage of the same internal optimizations as standard views.

  D. It is not possible to create secure materialized views.

  E. The view definition of a secure view is still visible to users by way of the information schema.

  Correct Answer: AC

• Question 575:

  What data type should be used to store JSON data natively in Snowflake?

  A. JSON

  B. String

  C. Object

  D. VARIANT

  Correct Answer: D

• Question 576:

  Which statement is true about Multi-Factor Authentication (MFA) in Snowflake?

  A. MFA can be enforced or applied for a given role.

  B. Snowflake users are automatically enrolled in MFA.

  C. Users enroll in MFA by submitting a request to Snowflake Support.

  D. MFA is an integrated Snowflake feature.

  Correct Answer: D

• Question 577:

  What is a core benefit of clustering?

  A. To guarantee uniquely identifiable records in the database

  B. To increase scan efficiency in queries by improving pruning

  C. To improve performance by creating a separate file for point lookups

  D. To provide data redundancy by duplicating micro-partitions

  Correct Answer: B

• Question 578:

  A clustering key was defined on a table, but it is no longer needed.

  How can the key be removed?

  A. ALTER TABLE PURGE CLUSTERING KEY

  B. ALTER TABLE DELETE CLUSTERING KEY

  C. ALTER TABLE DROP CLUSTERING KEY

  D. ALTER TABLE REMOVE CLUSTERING KEY

  Correct Answer: C

• Question 579:

  Which Query Profile result indicates that a warehouse is sized too small?

  A. There are a lot of filter nodes.

  B. Bytes are spilling to external storage.

  C. The number of processed rows is very high.

  D. The number of partitions scanned is the same as partitions total.

  Correct Answer: B

• Question 580:

  Which SQL command can be used to verify the privileges that are granted to a role?

  A. SHOW GRANTS ON ROLE

  B. SHOW ROLES

  C. SHOW GRANTS TO ROLE

  D. SHOW GRANTS FOR ROLE

  Correct Answer: C