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

Updated On: 16-Feb-2026

True or False: The COPY command must specify a File Format in order to execute.

  1. True
  2. False

Answer(s): B



Which of the following commands sets the Virtual Warehouse for a session?

  1. COPY WAREHOUSE FROM <<config file>>;
  2. SET WAREHOUSE = <<warehouse name>>;
  3. USE WAREHOUSE <<warehouse name>>;
  4. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html



Which of the following objects can be cloned? (Choose four.)

  1. Tables
  2. Named File Formats
  3. Schemas
  4. Shares
  5. Databases
  6. Users

Answer(s): A,B,C,E



Which object allows you to limit the number of credits consumed within a Snowflake account?

  1. Account Usage Tracking
  2. Resource Monitor
  3. Warehouse Limit Parameter
  4. Credit Consumption Tracker

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/resource-monitors.html



Snowflake is designed for which type of workloads? (Choose two.)

  1. OLAP (Analytics) workloads
  2. OLTP (Transactional) workloads
  3. Concurrent workloads
  4. On-premise workloads

Answer(s): A,C






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

Join the COF-C02 Discussion