Free COF-C02 Exam Braindumps
SnowPro Core Questions 471–475 (page: 96)

Updated On: 10-Feb-2026

How long is a query visible in the Query History page in the Snowflake Web Interface (UI)?

  1. 60 minutes
  2. 24 hours
  3. 14 days
  4. 30 days

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/ui-history.html#:~:text=The%20History%20page%20displays%20queries,days%2C%20no%20results%20are%20returned



Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

  1. Scale up the existing warehouse
  2. Create separate warehouses for each user
  3. Create separate warehouses for each workload
  4. Stop loading and querying data at the same time

Answer(s): C



Where does zero-copy cloning occur in Snowflake?

  1. In the virtual warehouse results cache
  2. In the metadata layer of the cloud services layer
  3. In the remote cache layer
  4. In the query results cache

Answer(s): D


Reference:

https://thinketl.com/snowflake-zero-copy-cloning/



Which view will return users who have queried a table?

  1. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENT_HISTORY
  2. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY
  3. SNOWFLAKE.ACCOUNT_USAGE.COLUMNS
  4. SNOWFLAKE.ACCOUNT_USAGE.OBJECT_DEPENDENCIES

Answer(s): B



Why do Snowflake’s virtual warehouses have scaling policies?

  1. To help save extra storage costs
  2. To help increase the performance of serverless computing features
  3. To help control the credits consumed by a multi-cluster warehouse running in auto-scale mode
  4. To help control the credits consumed by a multi-cluster warehouse running in maximized mode

Answer(s): C


Reference:

https://thinketl.com/snowflake-virtual-warehouses/



Viewing page 96 of 221
Viewing questions 476 - 480 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!