Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 971:

  When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?

  A. FILE_FORMAT
  B. PATTERN
  C. VALIDATION_MODE
  D. FILES
  B. PATTERN

  ---

  Explanation

• Question 972:

  Which data types can be used in Snowflake to store semi-structured data? (Choose two.)

  A. ARRAY
  B. BLOB
  C. CLOB
  D. JSON
  E. VARIANT
  A. ARRAY
  E. VARIANT

  ---

  Explanation

• Question 973:

  A data provider needs to securely collaborate with data consumers who do not reside in the same region. What Snowflake sharing mechanism should be used?

  A. Direct share
  B. Data Exchange
  C. Data replication
  D. Listing
  B. Data Exchange

  ---

  Explanation

• Question 974:

  What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Choose two.)

  A. VARIANT
  B. ARRAY
  C. BINARY
  D. OBJECT
  E. VARCHAR
  C. BINARY
  E. VARCHAR

  ---

  Explanation

• Question 975:

  Which Snowflake table types are used to manage costs for short-lived tables? (Choose two.)

  A. External tables
  B. Permanent tables
  C. Shared tables
  D. Temporary tables
  E. Transient tables
  D. Temporary tables
  E. Transient tables

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-storage-considerations

• Question 976:

  Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  A. Use the DROP command after the load completes.
  B. Specify the TEMPORARY option when creating the file format.
  C. Specify the PURGE copy option in the COPY INTO command.
  D. Use the REMOVE command after the load completes.
  E. Use the DELETE LOAD HISTORY command after the load completes.
  C. Specify the PURGE copy option in the COPY INTO command.
  D. Use the REMOVE command after the load completes.

  ---

  Explanation

• Question 977:

  What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

  A. Hierarchical key model
  B. Client-side encryption
  C. Tri-secret secure encryption
  D. Key pair authentication
  C. Tri-secret secure encryption

  ---

  Explanation

  https://www.phdata.io/blog/encrypting-snowflake-data-with-own-keys/

• Question 978:

  Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

  A. A VARIANT column is more secure than a string column.
  B. A VARIANT column compresses data and a string column does not.
  C. A VARIANT column can be used to create a data hierarchy and a string column cannot.
  D. A VARIANT column will have a better query performance than a string column.
  C. A VARIANT column can be used to create a data hierarchy and a string column cannot.

  ---

  Explanation

• Question 979:

  Snowflake supports federated authentication in all editions.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://community.snowflake.com/s/news/federated-authentication-sso-now-available-in-all-snowflake-editions- MC6N3I63LJGNGMHCTKGKFDH4NH2Q

• Question 980:

  At what levels can network policies be de ned in Snow ake? (Choose two.)

  A. User
  B. Account
  C. Table
  D. Schema
  E. Database
  A. User
  B. Account

  ---

  Explanation