Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 871:

  Which objects together comprise a namespace in Snowflake? (Choose two.)

  A. Account
  B. Database
  C. Schema
  D. Table
  E. Virtual warehouse
  B. Database
  C. Schema

  ---

  Explanation

• Question 872:

  A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify and Suspend Immediately".

  

  What is the MAXIMUM limit of credits that Warehouse 2 can consume?

  B. 1500
  C. 3500
  D. 5000
  D. 5000

  ---

  Explanation

  Warehouse 2 is controlled by policy on the account level and all five warehouses usage count toward this limit. Having limit on another warehouses (in this example: 3, 4, 5) just means that warehouse 3, 4, 5 can be suspended earlier when reaching their limits.

  The question ask for the MAXIMUM, so the best case scenario for warehouse 2 is that other warehouses doesn't consume ANY resources and in such case warehouse 2 can burn whole 5000 limit.

• Question 873:

  The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)

  A. Views for all the objects contained in the database
  B. Views for all the objects contained in the Snowflake account
  C. Views for historical and usage data across the Snowflake account
  D. Table functions for historical and usage data across the Snowflake account
  E. Table functions for account-level objects, such as roles, virtual warehouses, and databases
  A. Views for all the objects contained in the database
  D. Table functions for historical and usage data across the Snowflake account

  ---

  Explanation

• Question 874:

  What can be used to view warehouse usage over time? (Select Two).

  A. The load HISTORY view
  B. The Query history view
  C. The show warehouses command
  D. The WAREHOUSE_METERING__HISTORY View
  E. The billing and usage tab in the Snowflake web Ul
  D. The WAREHOUSE_METERING__HISTORY View
  E. The billing and usage tab in the Snowflake web Ul

  ---

  Explanation

• Question 875:

  Which stages are created by default, with no need to use the CREATE STAGE command? (Choose two.)

  A. External stage
  B. Internal stage
  C. Named stage
  D. Table stage
  E. User stage
  D. Table stage
  E. User stage

  ---

  Explanation

• Question 876:

  What happens when an external or an internal stage is dropped? (Select TWO).

  A. When dropping an external stage, the files are not removed and only the stage is dropped
  B. When dropping an external stage, both the stage and the files within the stage are removed
  C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
  D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
  E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
  A. When dropping an external stage, the files are not removed and only the stage is dropped
  D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

  ---

  Explanation

• Question 877:

  What is the purpose of configuring the scale factor parameter when using the Query Acceleration Service?

  A. It increases the default selectivity of any filter parameters when the query is accelerated.
  B. It is used when there are not enough partitions in a table to accelerate the query.
  C. It controls costs by setting an upper bound on the amount of compute resources a warehouse can use for query acceleration.
  D. It is a concurrency control tool used to avoid unnecessary scaling up when the query is accelerated and the warehouse is running in Maximized mode.
  C. It controls costs by setting an upper bound on the amount of compute resources a warehouse can use for query acceleration.

  ---

  Explanation

  The scale factor parameter limits the maximum number of resources (parallel threads) that the Query Acceleration Service can use. It helps control costs by bounding resource usage during query acceleration.

  Snowflake Docs: Query Acceleration Service

• Question 878:

  When unloading data from Snowflake, what is the default file size of each file?

  A. 16 MB
  B. 32 MB
  C. 64 MB
  D. 5 GB
  A. 16 MB

  ---

  Explanation

• Question 879:

  The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  A. Users
  B. Tables
  C. Databases
  D. Internal Stages
  B. Tables
  C. Databases
  D. Internal Stages

  ---

  Explanation

• Question 880:

  When can a newly configured virtual warehouse start running SQL queries?

  A. After 50% of the warehouse provisioning has completed
  B. During the time slots defined by the ACCOUNTADMIN
  C. When the warehouse provisioning is completed
  D. After the warehouse replication is completed
  C. When the warehouse provisioning is completed

  ---

  Explanation