Free COF-C02 Exam Braindumps
SnowPro Core Questions 311–315 (page: 64)

Updated On: 10-Feb-2026

Which SQL command can be used to see the CREATE definition of a masking policy?

  1. SHOW MASKING POLICIES
  2. DESCRIBE MASKING POLICY
  3. GET_DDL
  4. LIST MASKING POLICIES

Answer(s): C



Which of the following is the Snowflake Account_Usage.Metering_History view used for?

  1. Gathering the hourly credit usage for an account
  2. Compiling an account's average cloud services cost over the previous month
  3. Summarizing the throughput of Snowpipe costs for an account
  4. Calculating the funds left on an account's contract

Answer(s): A



Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  1. Cloud services layer
  2. Compute layer
  3. Storage layer
  4. Cloud agnostic layer

Answer(s): A



Which of the following Snowflake objects can be shared using a secure share? (Choose two.)

  1. Materialized views
  2. Sequences
  3. Procedures
  4. Tables
  5. Secure User Defined Functions (UDFs)

Answer(s): D,E



What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

  1. Data is hashed by the cluster key to facilitate fast searches for common data values
  2. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
  3. Smaller micro-partitions are created for common data values to allow for more parallelism
  4. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Answer(s): D



Viewing page 64 of 221
Viewing questions 316 - 320 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!