Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1661:

  For a multi-cluster Warehouse, the number of credits billed is calculated on:

  A. The number of queries that ran using the Warehouse.
  B. The size of the Warehouse and the number of clusters that ran within a given time period.
  C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
  D. The number of users who accessed the Warehouse.
  B. The size of the Warehouse and the number of clusters that ran within a given time period.

  ---

  Explanation

• Question 1662:

  How is the MANAGE GRANTS privilege applied?

  A. Globally
  B. At the database level
  C. At the schema level
  D. At the table level
  A. Globally

  ---

  Explanation

• Question 1663:

  An external stage, my_stage contains many directories, including one, app_ files that contains CSV les. How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?

  A. COPY INTO my_table FROM @my_stage PATTERN='.*[.]csv';
  B. COPY INTO my_table FROM @my_stage/app_ files PATTERN='.*[.]csv';
  C. COPY INTO my_table FROM @my_stage/app_ files PATTERN='.*[.]txt';
  D. COPY INTO my_table FROM @my_stage PATTERN='.*[.]txt';
  B. COPY INTO my_table FROM @my_stage/app_ files PATTERN='.*[.]csv';

  ---

  Explanation

• Question 1664:

  Which Snowflake view is used to support compliance auditing?

  A. ACCESS_HISTORY
  B. COPY_HISTORY
  C. QUERY_HISTORY
  D. ROW_ACCESS_POLICIES
  A. ACCESS_HISTORY

  ---

  Explanation

• Question 1665:

  A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.

  Which set operator should be used?

  A. INTERSECT
  B. MERGE
  C. MINUS
  D. UNION
  A. INTERSECT

  ---

  Explanation

• Question 1666:

  Which command is used to generate a zero-copy "snapshot" of any table, schema, or database?

  A. ALTER
  B. CREATE ... CLONE
  C. COPY INTO
  D. CREATE REPLICATION GROUP
  B. CREATE ... CLONE

  ---

  Explanation

• Question 1667:

  How should a Snowflake user configure a virtual warehouse to be in Maximized mode?

  A. Set the WAREHOUSE_SIZE to 6XL.
  B. Set the STATEMENT_TIMEOUT_IN_SECONDS to 0.
  C. Set the MAX_CONCURRENCY_LEVEL to a value of 12 or larger.
  D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.
  D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

  ---

  Explanation

• Question 1668:

  As a best practice, clustering keys should only be defined on tables of which minimum size?

  A. Multi-Kilobyte (KB) Range
  B. Multi-Megabyte (MB) Range
  C. Multi-Gigabyte (GB) Range
  D. Multi-Terabyte (TB) Range
  D. Multi-Terabyte (TB) Range

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 1669:

  A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

  1.Created a user called "CONSUMER"

  2.Created a database to hold the share and an extra-small warehouse to query the data

  3.Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

  Based on this configuration what is true of the reader account?

  A. The reader account will automatically use the Standard edition of Snowflake.
  B. The reader account compute will be billed to the provider account.
  C. The reader account can clone data the provider has shared, but cannot re-share it.
  D. The reader account can create a copy of the shared data using CREATE TABLE AS...
  B. The reader account compute will be billed to the provider account.

  ---

  Explanation

• Question 1670:

  What privilege is required to view the load statistics on a virtual warehouse?

  A. MODIFY
  B. OPERATE
  C. MONITOR
  D. USAGE
  D. USAGE

  ---

  Explanation