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

Updated On: 17-Feb-2026

Which semi-structured file formats are supported when unloading data from a table? (Choose two.)

  1. ORC
  2. XML
  3. Avro
  4. Parquet
  5. JSON

Answer(s): D,E


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html



A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  1. 1 second
  2. 60 seconds
  3. 5 minutes
  4. 60 minutes

Answer(s): B



What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  1. Authentication
  2. Resource management
  3. Virtual warehouse caching
  4. Query parsing and optimization
  5. Query execution
  6. Physical storage of micro-partitions

Answer(s): A,B,D



How long is the Fail-safe period for temporary and transient tables?

  1. There is no Fail-safe period for these tables.
  2. 1 day
  3. 7 days
  4. 31 days
  5. 90 days

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html



Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  1. PUT
  2. GET
  3. COPY
  4. SELECT

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/sql/get.html






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

Join the COF-C02 Discussion