Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 121:

  Which Snowflake layer is always leveraged when accessing a query from the result cache?

  A. Metadata

  B. Data Storage

  C. Compute

  D. Cloud Services

  Correct Answer: D

• Question 122:

  What is the following SQL command used for?

  Select * from table(validate(t1, job_id => '_last'));

  A. To validate external table files in table t1 across all sessions

  B. To validate task SQL statements against table t1 in the last 14 days

  C. To validate a file for errors before it gets executed using a COPY command

  D. To return errors from the last executed COPY command into table t1 in the current session

  Correct Answer: D

• Question 123:

  Which of the following can be used when unloading data from Snowflake? (Choose two.)

  A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

  B. Use the ENCODING file format option to change the encoding from the default UTF-8.

  C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

  E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

  Correct Answer: AD

• Question 124:

  Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

  A. A directory table is a separate database object.

  B. Directory tables store data file metadata.

  C. A directory table will be automatically added to a stage.

  D. Directory tables do not have their own grantable privileges.

  E. Directory table data can not be refreshed manually.

  Correct Answer: BD

• Question 125:

  Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

  A. Schemas

  B. Roles

  C. Secure Views

  D. Stored Procedures

  E. Tables

  F. Secure User-Defined Functions (UDFs)

  Correct Answer: ABF

• Question 126:

  Which statement describes how Snowflake supports reader accounts?

  A. A reader account can consume data from the provider account that created it and combine it with its own data.

  B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

  C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

  D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

  Correct Answer: C

• Question 127:

  Which of the following describes the Snowflake Cloud Services layer?

  A. Coordinates activities in the Snowflake account

  B. Executes queries submitted by the Snowflake account users

  C. Manages quotas on the Snowflake account storage

  D. Manages the virtual warehouse cache to speed up queries

  Correct Answer: A

• Question 128:

  How can a row access policy be applied to a table or a view? (Choose two.)

  A. Within the policy DDL

  B. Within the create table or create view DDL

  C. By future APPLY for all objects in a schema

  D. Within a control table

  E. Using the command ALTER