Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 221:

  What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

  A. The clone always stays in sync with the original table.
  B. The clone has better query performance.
  C. The clone is created almost instantly.
  D. The clone will have time travel history from the original table.
  E. The clone saves space by not duplicating storage.
  C. The clone is created almost instantly.
  E. The clone saves space by not duplicating storage.

• Question 222:

  Which copy INTO command outputs the data into one file?

  A. SINGLE=TRUE
  B. MAX_FILE_NUMBER=1
  C. FILE_NUMBER=1
  D. MULTIPLE=FAISE
  A. SINGLE=TRUE

• Question 223:

  What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

  A. Custom Edition
  B. Virtual Private Snowflake
  C. Business Critical Edition
  D. Standard Edition
  E. Enterprise Edition
  B. Virtual Private Snowflake
  C. Business Critical Edition

• Question 224:

  What is true about sharing data in Snowflake? (Choose two.)

  A. The Data Consumer pays for data storage as well as for data computing.
  B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
  C. A Snowflake account can both provide and consume shared data.
  D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
  E. The Data Consumer pays only for compute resources to query the shared data.
  B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
  C. A Snowflake account can both provide and consume shared data.

• Question 225:

  A user has a standard multi-cluster warehouse auto-scaling policy in place.

  Which condition will trigger a cluster to shut-down?

  A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
  B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
  C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

• Question 226:

  Which statement MOST accurately describes clustering in Snowflake?

  A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
  B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
  C. The clustering key must be included in the COPY command when loading data into Snowflake.
  D. Clustering can be disabled within a Snowflake account.
  B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

• Question 227:

  Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  A. Customers can change the size of the Warehouse after creation
  B. A Warehouse can be resized while running
  C. A Warehouse can be configured to suspend after a period of inactivity
  D. A Warehouse can be configured to auto-resume when new queries are submitted
  A. Customers can change the size of the Warehouse after creation
  B. A Warehouse can be resized while running
  C. A Warehouse can be configured to suspend after a period of inactivity
  D. A Warehouse can be configured to auto-resume when new queries are submitted

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 228:

  What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  A. Authentication
  B. Resource management
  C. Virtual warehouse caching
  D. Query parsing and optimization
  E. Query execution
  F. Physical storage of micro-partitions
  A. Authentication
  D. Query parsing and optimization
  E. Query execution

• Question 229:

  What is the minimum Snowflake edition required to create a materialized view?

  A. Standard Edition
  B. Enterprise Edition
  C. Business Critical Edition
  D. Virtual Private Snowflake Edition
  B. Enterprise Edition

  ---

  Explanation/Reference:

  Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

• Question 230:

  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
  B. If the virtual warehouse has been suspended