Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1491:

  What happens when a Data Provider revokes privileges to a Share on an object in their source database?

  A. The object immediately becomes unavailable for all Data Consumers
  B. Any additional data arriving after this point in time will not be visible to Data Consumers
  C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
  D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts
  A. The object immediately becomes unavailable for all Data Consumers

  ---

  Explanation

• Question 1492:

  Multiple business units within a company use a single Snowflake account. What features should be used if the company needs to separate costs by business unit? (Select TWO).

  A. User roles
  B. Query history
  C. Object tagging
  D. Resource monitors
  E. Virtual warehouses
  C. Object tagging
  D. Resource monitors

  ---

  Explanation

  Object Tagging (C):

  Resource Monitors (D):

  Why Other Options Are Incorrect:

  A. User roles: Roles manage access control, not cost tracking.

  B. Query history: Tracks query details but does not provide cost separation.

  E. Virtual warehouses: While costs are associated with warehouses, they do not provide cost separation unless paired with tagging or resource monitors.

  References:

  Object Tagging

  Resource Monitors

• Question 1493:

  What is the minimum duration charged when starting a virtual warehouse?

  A. 1 second
  B. 1 minute
  C. 1 hour
  D. 1 day
  B. 1 minute

  ---

  Explanation

• Question 1494:

  The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  A. 60 minutes
  B. 24 hours
  C. 14 days
  D. 30 days
  E. 1 year
  C. 14 days

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

• Question 1495:

  Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html

• Question 1496:

  Any user with the appropriate privileges can view data storage for individual tables by using which queries? (Choose two.)

  A. METERING_HISTORY view in the ACCOUNT_USAGE schema
  B. TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
  C. STORAGE_USAGE view in the ACCOUNT_USAGE schema
  D. TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema
  E. METERING_DAILY_HISTORY view in the ORGANIZATION_USAGE schema
  B. TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
  D. TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema

  ---

  Explanation

• Question 1497:

  When cloning a schema, which Snowflake object will not be included in the clone?

  A. An external stage
  B. A named internal stage
  C. A task
  D. A User-De ned Function (UDF)
  A. An external stage

  ---

  Explanation

• Question 1498:

  When loading data into Snowflake, how should the data be organized?

  A. Into single files with 100-250 MB of compressed data per file
  B. Into single files with 1-100 MB of compressed data per file
  C. Into files of maximum size of 1 GB of compressed data per file
  D. Into files of maximum size of 4 GB of compressed data per file
  A. Into single files with 100-250 MB of compressed data per file

  ---

  Explanation

• Question 1499:

  What is the consequence of disabling auto-suspend for a Snowflake virtual warehouse?

  A. Enhanced data security
  B. Improved query performance
  C. Increased credit consumption
  D. Reduced storage costs
  C. Increased credit consumption

  ---

  Explanation

  Disabling auto-suspend prevents a virtual warehouse from automatically shutting down during periods of inactivity, leading to increased credit consumption because the warehouse continues consuming resources even when idle. This can significantly raise costs, especially for underutilized warehouses.

  References: Snowflake Documentation: Virtual Warehouses Snowflake Credit Management

• Question 1500:

  Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?

  A. SnowSQL
  B. ODBC
  C. R
  D. HIVE
  A. SnowSQL
  B. ODBC

  ---

  Explanation

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