Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 21:

  Which of the following significantly improves the performance of selective point lookup queries on a table?

  A. Clustering

  B. Materialized Views

  C. Zero-copy Cloning

  D. Search Optimization Service

  Correct Answer: A

• Question 22:

  Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

  A. CREATE_SHARE on the account

  B. SHARE on databases and schemas

  C. SELECT on tables used by the secure view

  D. REFERENCE_USAGE on databases

  Correct Answer: C

• Question 23:

  What privilege should a user be granted to change permissions for new objects in a managed access schema?

  A. Grant the OWNERSHIP privilege on the schema.

  B. Grant the OWNERSHIP privilege on the database.

  C. Grant the MANAGE GRANTS global privilege.

  D. Grant ALL privileges on the schema.

  Correct Answer: C

• Question 24:

  Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

  A. Configure the user to be initially disabled.

  B. Force an immediate password change.

  C. Set a default role for the user.

  D. Set the number of minutes to unlock to 15 minutes.

  E. Set the user's access to expire within a specified timeframe.

  Correct Answer: AE

• Question 25:

  Which of the following statements apply to Snowflake in terms of security? (Choose two.)

  A. Snowflake leverages a Role-Based Access Control (RBAC) model.

  B. Snowflake requires a user to configure an IAM user to connect to the database.

  C. All data in Snowflake is encrypted.

  D. Snowflake can run within a user's own Virtual Private Cloud (VPC).

  E. All data in Snowflake is compressed.

  Correct Answer: AD

• Question 26:

  The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

  A. USERADMIN

  B. PUBLIC

  C. ORGADMIN

  D. SYSADMIN

  Correct Answer: D

• Question 27:

  What affects whether the query results cache can be used?

  A. If the query contains a deterministic function

  B. If the virtual warehouse has been suspended

  C. If the referenced data in the table has changed

  D. If multiple users are using the same virtual warehouse

  Correct Answer: B

• Question 28:

  Network policies can be set at which Snowflake levels? (Choose two.)

  A. Role

  B. Schema

  C. User

  D. Database

  E. Account

  F. Tables

  Correct Answer: CE

  Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

• Question 29:

  What file formats does Snowflake support for loading semi-structured data? (Choose three.)

  A. TSV

  B. JSON

  C. PDF

  D. Avro

  E. Parquet

  F. JPEG

  Correct Answer: BDE

• Question 30:

  Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  A. Files

  B. External tables

  C. Secure User-Defined Functions (UDFs)

  D. Sequences

  E. Streams

  Correct Answer: BC