Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1011:

  A Virtual Warehouse consumes Snowflake credits even when inactive.

  A. True
  B. False
  B. False

  ---

  Explanation

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

• Question 1012:

  Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

  A. Management of metadata
  B. Computing the data
  C. Maintaining Availability Zones
  D. Infrastructure security
  E. Parsing and optimizing queries
  A. Management of metadata
  E. Parsing and optimizing queries

  ---

  Explanation

• Question 1013:

  A complex query has been running in Snowsight for more than one hour. At the same time, several other queries from other worksheets ran successfully.

  What is FASTEST way to cancel the long-running query?

  A. Immediately suspend the virtual warehouse that the query is running on.
  B. Return to the worksheet and abort the query.
  C. Set the auto_suspend virtual warehouse property to 0.
  D. Find the query in the query activity view and cancel the query.
  D. Find the query in the query activity view and cancel the query.

  ---

  Explanation

• Question 1014:

  Which command can be performed on a Snowflake secure view?

  A. SELECT
  B. INSERT
  C. UPDATE
  D. DELETE
  A. SELECT

  ---

  Explanation

  A secure view in Snowflake is designed to enforce stricter access control and prevent unauthorized access to the underlying data. Only SELECT statements can be performed on a secure view, as they are read- only objects. Why Other Options Are Incorrect:

  B. INSERT /

  C. UPDATE /

  D. DELETE: Secure views do not allow DML (Data Manipulation Language) operations.

  References:

  Secure Views Documentation

• Question 1015:

  A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

  A. Yes, because a table owner has full control and can unset masking policies.
  B. Yes, because masking policies only apply to cloned tables.
  C. No, because masking policies must always reference specific access roles.
  D. No, because ownership of a table does not include the ability to change masking policies
  D. No, because ownership of a table does not include the ability to change masking policies

  ---

  Explanation

• Question 1016:

  Which privilege allows a user to change the state of a virtual warehouse that was set to AUTO_RESUME = FALSE?

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

  ---

  Explanation

• Question 1017:

  When unloading data, which file format will keep floating-point number column data without truncating it?

  A. XML
  B. JSON
  C. Parquet
  D. CSV
  B. JSON

  ---

  Explanation

• Question 1018:

  A Snowflake account holds data that will be consumed by a BI tool. Most of the BI users are located in the United States, but some users will require access from abroad with different levels of concurrency.

  What virtual warehouse would be MOST cost-efficient?

  A. A maximized multi-cluster warehouse with the minimum number of clusters that are big enough to handle the expected maximum concurrency.
  B. A large enough standard warehouse able to handle the expected maximum concurrency.
  C. A large enough Snowpark-optimized warehouse that will have sufficient memory to handle the expected maximum concurrency.
  D. An auto-scale, multi-cluster warehouse with a maximum number of clusters that are large enough to handle the expected maximum concurrency.
  D. An auto-scale, multi-cluster warehouse with a maximum number of clusters that are large enough to handle the expected maximum concurrency.

  ---

  Explanation

• Question 1019:

  What object or service uses Change Data Capture (CDC) to record Data Manipulation Language (DML) changes made to tables?

  A. Task
  B. Stream
  C. Snowpipe
  D. Event Table
  B. Stream

  ---

  Explanation

  A Stream is a Snowflake object that tracks DML changes (INSERTS, UPDATES, DELETES) on a table for CDC (Change Data Capture) use cases.

  Snowflake Docs: Streams for Change Data Capture

• Question 1020:

  The Query Profile in the image is for a query executed in Snowsight. Four of the key nodes are highlighted in yellow.

  

  Which highlighted node will be the MOST expensive?

  A. Aggregate[1]
  B. Join[5]
  C. TableScan[2]
  D. TableScan[3]
  D. TableScan[3]

  ---

  Explanation