Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1091:

  True or False: Pipes can be suspended and resumed.

  A. True

  B. False

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes

  Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

• Question 1092:

  Which of the following is true of Snowpipe via REST API? Choose 2 answers

  A. you can only use it on internal Stages

  B. All COPY INTO options are available fluting pipe creation

  C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands

  D. Snowpipe keeps track of which files it has loaded

  Correct Answer: CD

  https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes

• Question 1093:

  Which of the following are options when creating a virtual Warehouse? Choose 2 answers

  A. Auto-drop

  B. Auto resize

  C. Auto-resume

  D. Auto-suspend

  Correct Answer: CD

  https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse

• Question 1094:

  Which of the following objects can be cloned? (Choose four.)

  A. Tables

  B. Named File Formats

  C. Schemas

  D. Shares

  E. Databases

  F. Users

  Correct Answer: ABCE

  Which Objects Can Be Cloned?

  Data Containment Objects. Databases. Schemas. Tables. Streams. Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

• Question 1095:

  True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  A. True

  B. False

  Correct Answer: A

  Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

• Question 1096:

  Select the different types of Internal Stages: (Choose three.)

  A. Named Stage

  B. User Stage

  C. Table Stage

  D. Schema Stage

  Correct Answer: ABC

  Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

• Question 1097:

  When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  A. The Pipe load history is reset to empty

  B. The REFRESH parameter is set to TRUE

  C. Previously loaded files will be ignored

  D. All of the above

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

• Question 1098:

  Which of the following statements about data sharing are true? choose 2 answers

  A. New objects created by a Data Provider are automatically shared with existing Data Consumers and Reader Accounts

  B. All database objects can be included In a shared database

  C. Reader Accounts are created and funded by Data Prowlers

  D. Shared databases are read-only

  Correct Answer: CD

• Question 1099:

  True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/constraints-overview.html

• Question 1100:

  Account-level storage usage can be monitored via:

  A. The snowflake wet Interface (UI) in the Databases section.

  B. The Snowflake web interface (UI) in the Account-> Billing a usage section

  C. The Information Schema-> ACCOUNT_USAGE_HISTORY View

  D. The Account usage Schema-> ACCOUNT_USAGE_METRICS View

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-usage-billing.html