Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 31:

  True or False: Data Providers can share data with only the Data Consumer.

  A. True
  B. False
  B. False

• Question 32:

  True or False: Snowflake charges a premium for storing semi-structured data.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

• Question 33:

  What are supported file formats for unloading data from Snowflake? (Choose three.)

  A. XML
  B. JSON
  C. Parquet
  D. ORC
  E. AVRO
  F. CSV
  B. JSON
  C. Parquet
  F. CSV

• Question 34:

  By default, which Snowflake role is required to create a share?

  A. ORGADMIN
  B. SECURITYADMIN
  C. SHAREADMIN
  D. ACCOUNTADMIN
  C. SHAREADMIN

• Question 35:

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

  A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
  B. Clustering keys sort the designated columns over time, without blocking DML operations
  C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
  D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
  B. Clustering keys sort the designated columns over time, without blocking DML operations

• Question 36:

  What are value types that a VARIANT column can store? (Select TWO)

  A. STRUCT
  B. OBJECT
  C. BINARY
  D. ARRAY
  E. CLOB
  B. OBJECT
  D. ARRAY

  ---

  Explanation/Reference:

  Characteristics of a VARIANT

  A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

  https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

• Question 37:

  Which of the following objects can be shared through secure data sharing?

  A. Masking policy
  B. Stored procedure
  C. Task
  D. External table
  D. External table

  ---

  Explanation/Reference:

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs

  Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers. https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing% 20enables%20sharing,External%20tables

• Question 38:

  Select the different types of Internal Stages: (Choose three.)

  A. Named Stage
  B. User Stage
  C. Table Stage
  D. Schema Stage
  A. Named Stage
  B. User Stage
  C. Table Stage

  ---

  Explanation/Reference:

  Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

• Question 39:

  Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  A. Database replication and failover
  B. Automated index management
  C. Customer managed keys (Tri-secret secure)
  D. Extended time travel
  E. Native support for geospatial data
  A. Database replication and failover
  D. Extended time travel

• Question 40:

  True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html