Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 61:

  When loading data into Snowflake, how should the data be organized?

  A. Into single files with 100-250 MB of compressed data per file
  B. Into single files with 1-100 MB of compressed data per file
  C. Into files of maximum size of 1 GB of compressed data per file
  D. Into files of maximum size of 4 GB of compressed data per file
  A. Into single files with 100-250 MB of compressed data per file

• Question 62:

  Which of the following commands cannot be used within a reader account?

  A. CREATE SHARE
  B. ALTER WAREHOUSE
  C. DROP ROLE
  D. SHOW SCHEMAS
  E. DESCRBE TABLE
  B. ALTER WAREHOUSE

  ---

  Explanation/Reference:

  A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

• Question 63:

  What internal stages are available in Snowflake? (Choose three.)

  A. Schema stage
  B. Named stage
  C. User stage
  D. Stream stage
  E. Table stage
  F. Database stage
  A. Schema stage
  B. Named stage
  E. Table stage

• Question 64:

  A user has unloaded data from a Snowflake table to an external stage.

  Which command can be used to verify if data has been uploaded to the external stage named my_stage?

  A. view @my_stage
  B. list @my_stage
  C. show @my_stage
  D. display @my_stage
  B. list @my_stage

• Question 65:

  Network policies can be applied to which of the following Snowflake objects? (Choose two.)

  A. Roles
  B. Databases
  C. Warehouses
  D. Users
  E. Accounts
  A. Roles
  D. Users

• Question 66:

  Which of the following statements are true of Snowflake releases: (Choose two.)

  A. They happen approximately weekly
  B. They roll up and release approximately monthly, but customers can request early release application
  C. During a release, new customer requests/queries/connections transparently move over to the newer version
  D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
  A. They happen approximately weekly
  C. During a release, new customer requests/queries/connections transparently move over to the newer version

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/intro-releases.html

• Question 67:

  True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

  A. True
  B. False
  B. False

• Question 68:

  Which data types does Snowflake support when querying semi-structured data? (Select TWO)

  A. VARIANT
  B. ARRAY
  C. VARCHAR
  D. XML
  E. BLOB
  A. VARIANT
  B. ARRAY

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data

  A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

  The maximum length of a VARIANT is 16 MB.

  A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

• Question 69:

  Which TABLE function helps to convert semi-structured data to a relational representation?

  A. CHECK_JSON
  B. TO_JSON
  C. FLATTEN
  D. PARSE_JSON
  D. PARSE_JSON

• Question 70:

  Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

  A. ROLES
  B. POLICY_REFERENCES
  C. QUERY_HISTORY
  D. RESOURCE_MONIT ORS
  E. ACCESS_HISTORY
  B. POLICY_REFERENCES
  C. QUERY_HISTORY

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.