Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 541:

  A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  A. The primary duster in the virtual warehouse
  B. The entire Virtual Warehouse
  C. The database the Virtual Warehouse resides in
  D. The queries currently being run by the Virtual Warehouse
  B. The entire Virtual Warehouse

  ---

  Explanation

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

• Question 542:

  How can a user change which columns are referenced in a view?

  A. Modify the columns in the underlying table
  B. Use the ALTER VIEW command to update the view
  C. Recreate the view with the required changes
  D. Materialize the view to perform the changes
  C. Recreate the view with the required changes

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/alter-view.html#alter-view

• Question 543:

  Which of the following best describes where Snowflake's metadata is stored?

  A. Within the data files
  B. Inside the Virtual Warehouses
  C. In the Cloud Services Layer
  D. within the drivers
  C. In the Cloud Services Layer

  ---

  Explanation

• Question 544:

  Which statement accurately describes how a virtual warehouse functions?

  A. Increasing the size of a virtual warehouse will always improve data loading performance.
  B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
  C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
  D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.
  C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

  ---

  Explanation

• Question 545:

  A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently. What should the user do?

  A. Add a clustering key to the table.
  B. Add the search optimization service to the table.
  C. Create a materialized view based on the query.
  D. Enable the query acceleration service for the virtual warehouse.
  C. Create a materialized view based on the query.

  ---

  Explanation

• Question 546:

  Which Snowflake security feature has the HIGHEST precedence in the security feature hierarchy?

  A. Account roles
  B. Network policies
  C. Masking policies
  D. Snowflake OAuth
  A. Account roles

  ---

  Explanation

• Question 547:

  How does Snowflake utilize clustering information to improve query performance?

  A. It prunes unnecessary micro-partitions based on clustering metadata.
  B. It compresses the data within micro-partitions for faster querying.
  C. It automatically allocates additional resources to improve query execution.
  D. It organizes clustering information to speed-up data retrieval from storage.
  A. It prunes unnecessary micro-partitions based on clustering metadata.

  ---

  Explanation

• Question 548:

  What does the "percentage scanned from cache" represent in the Query Profile?

  A. The percentage of data scanned from the query cache
  B. The percentage of data scanned from the result cache
  C. The percentage of data scanned from the remote disk cache
  D. The percentage of data scanned from the local disk cache
  D. The percentage of data scanned from the local disk cache

  ---

  Explanation

• Question 549:

  Once created, a micro-partition will never be changed.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

• Question 550:

  Which data formats are supported by Snowflake when unloading semi-structured data? (Choose two.)

  A. Binary file in Avro
  B. Binary file in Parquet
  C. Comma-separated JSON
  D. Newline Delimited JSON
  E. Plain text file containing XML elements
  B. Binary file in Parquet
  D. Newline Delimited JSON

  ---

  Explanation