Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 961:

  Which minimum Snowflake edition allows for a dedicated metadata store?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: D

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

• Question 962:

  Which of the following is a data tokenization integration partner?

  A. Protegrity

  B. Tableau

  C. DBeaver

  D. SAP

  Correct Answer: A

• Question 963:

  Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Cloud services layer

  B. Compute layer

  C. Storage layer

  D. Cloud agnostic layer

  Correct Answer: A

  Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

• Question 964:

  What is the minimum Snowflake edition required for row level security?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: B

• Question 965:

  Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

  A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

  B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

  C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

  D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

  E. grant SELECT on all tables in database DB1 to role MYROLE;

  F. grant SELECT on future tables in database DB1 to role MYROLE;

  Correct Answer: CD

• Question 966:

  Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

  A. USAGE

  B. OPERATE

  C. MONITOR

  D. MODIFY

  Correct Answer: B

  Reference: https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege

• Question 967:

  What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

  A. The shared objects are transferred.

  B. The shared objects are copied.

  C. The shared objects become accessible.

  D. The shared objects can be re-shared.

  Correct Answer: C

• Question 968:

  Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  A. CONTENT

  B. PATH

  C. BYTE_SIZE

  D. INDEX

  E. DATATYPE

  Correct Answer: BD

• Question 969:

  Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

  A. INSERT

  B. PUT

  C. GET

  D. COPY

  Correct Answer: D

• Question 970:

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

  A. XML

  B. JSON

  C. Parquet

  D. ORC

  E. AVRO

  F. CSV

  Correct Answer: BCF