Free COF-C02 Exam Braindumps
SnowPro Core Questions 296–300 (page: 61)

Updated On: 10-Feb-2026

If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?

  1. All queries will terminate when the resources are maximized.
  2. The warehouse will scale out automatically
  3. The warehouse will move to a suspended state.
  4. New queries will be queued and executed when capacity is available.

Answer(s): D



Masking policies can be applied to which of the following Snowflake objects? (Choose two.)

  1. A materialized view
  2. A stored procedure
  3. A table
  4. A stream
  5. A pipe
  6. A User-Defined Function (UDF)

Answer(s): A,C



What actions are supported by Snowflake resource monitors? (Choose two.)

  1. Alert
  2. Notify
  3. Notify and suspend
  4. Abort
  5. Suspend immediately

Answer(s): B,C



A user executes the following SQL query:
create table SALES_BKP like SALES;

What are the cost implications for processing this query?

  1. Processing costs will be generated based on how long the query takes.
  2. Storage costs will be generated based on the size of the data.
  3. No costs will be incurred as the query will use metadata.
  4. The cost for running the virtual warehouse will be charged by the second.

Answer(s): C



What is the maximum length of time travel available in the Snowflake Standard Edition?

  1. 1 Day
  2. 7 Days
  3. 30 Days
  4. 90 Days

Answer(s): A



Viewing page 61 of 221
Viewing questions 301 - 305 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!