Snowflake COF-C02 Exam Questions
SnowPro Core (Page 43 )

Updated On: 17-Feb-2026

Which command can be used to load data files into a Snowflake stage?

  1. JOIN
  2. COPY INTO
  3. PUT
  4. GET

Answer(s): C



What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  1. Reader
  2. Consumer
  3. Vendor
  4. Standard
  5. Personalized

Answer(s): D,E



What is the maximum Time Travel retention period for a temporary Snowflake table?

  1. 90 days
  2. 1 day
  3. 7 days
  4. 45 days

Answer(s): B



When should a multi-cluster warehouse be used in auto-scaling mode?

  1. When it is unknown how much compute power is needed
  2. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
  3. If the runtime of the executed query is very slow
  4. When a large number of concurrent queries are run on the same warehouse

Answer(s): D



What happens when a cloned table is replicated to a secondary database? (Choose two.)

  1. A read-only copy of the cloned tables is stored.
  2. The replication will not be successful.
  3. The physical data is replicated.
  4. Additional costs for storage are charged to a secondary account.
  5. Metadata pointers to cloned tables are replicated.

Answer(s): C,D






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

Join the COF-C02 Discussion