Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 161:

  Which views are included in the DATA_SHARING_USAGE schema?

  A. ACCESS_HISTORY

  B. DATA_TRANSFER_HISTORY

  C. WAREHOUSE_METERING_HISTORY

  D. MONETIZED_USAGE_DAILY

  E. LISTING_TELEMETRY_DAILY

  Correct Answer: DE

• Question 162:

  Which command line flags can be used to log into a Snowflake account using SnowSQL? (Choose two.)

  A. -d

  B. -o

  C. -e

  D. -a E. -c

  Correct Answer: AD

• Question 163:

  What is a key benefit of using organizations in Snowflake?

  A. Ability to use ACCOUNT_USAGE views

  B. Ability to use zero-copy cloning across accounts

  C. Ability to consolidate account management and billing

  D. Ability to access new releases for testing and validation purposes

  Correct Answer: C

• Question 164:

  Which privilege is required on a virtual warehouse to abort any existing executing queries?

  A. USAGE

  B. OPERATE

  C. MODIFY

  D. MONITOR

  Correct Answer: B

• Question 165:

  Which command should be used to look into the validity of an XML object in Snowflake?

  A. XMLGET

  B. TO_XML

  C. PARSE_XML

  D. CHECK_XML

  Correct Answer: D

• Question 166:

  Who can activate a network policy for users in a Snowflake account? (Choose two.)

  A. ACCOUNTADMIN

  B. USERADMIN

  C. PUBLIC

  D. SYSADMIN

  E. Any role that has the global ATTACH POLICY privilege

  Correct Answer: AE

• Question 167:

  For which use cases is running a virtual warehouse required? (Choose two.)

  A. When creating a table

  B. When loading data into a table

  C. When unloading data from a table

  D. When executing a SHOW command

  E. When executing a LIST command

  Correct Answer: BC

• Question 168:

  What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

  A. Use the automatic sharing feature for seamless access.

  B. Drop the object and then re-add it to the database to trigger sharing.

  C. Recreate the object with a different name in the database before sharing.

  D. Use the GRANT privilege ... TO SHARE command to grant the necessary privileges.

  Correct Answer: D

• Question 169:

  Which Snowflake privilege is required on a pipe object to pause or resume pipes?

  A. OPERATE

  B. READ

  C. SELECT

  D. USAGE

  Correct Answer: A

• Question 170:

  Which commands can a Snowflake user execute to specify a cluster key for a table? (Choose two.)

  A. CREATE

  B. UPDATE

  C. ALTER

  D. SET

  E. SHOW

  Correct Answer: AC