Free COF-C02 Exam Braindumps
SnowPro Core Questions 571–575 (page: 116)

Updated On: 10-Feb-2026

Which privileges are required for a user to restore an object? (Choose two.)

  1. UPDATE
  2. OWNERSHIP
  3. MODIFY
  4. UNDROP
  5. CREATE

Answer(s): B,E



For a multi-cluster virtual warehouse, which parameters are used to calculate the number of credits billed? (Choose two.)

  1. Cache size
  2. Warehouse size
  3. Number of clusters
  4. Volume of data processed
  5. Number of queries executed

Answer(s): B,C



What happens when the values for both an ALLOWED_IP_LIST and a BLOCKED_IP_LIST are used in a network policy?

  1. Snowflake ignores the BLOCKED_IP_LIST first.
  2. Snowflake applies the BLOCKED_IP_LIST first.
  3. Snowflake applies the ALLOWED_IP_LIST first.
  4. Snowflake ignores the ALLOWED_IP_LIST first.

Answer(s): B



What does the orange bar on an operator represent when reviewing the Query Profile?

  1. A measure of progress of the operator's execution.
  2. The fraction of time that this operator consumed within the query step.
  3. The cost of the operator in terms of the virtual warehouse CPU utilization.
  4. The fraction of data scanned from cache versus remote disk for the operator.

Answer(s): B



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

  1. 16 MB
  2. 32 MB
  3. 64 MB
  4. 5 GB

Answer(s): A



Viewing page 116 of 221
Viewing questions 576 - 580 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!