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

Updated On: 17-Feb-2026

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  1. Users
  2. Tables
  3. Databases
  4. Internal Stages

Answer(s): B,C,D



What is the default File Format used in the COPY command if one is not specified?

  1. CSV
  2. JSON
  3. Parquet
  4. XML

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html



True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  1. True
  2. False

Answer(s): A


Reference:

https://acrotrend.com/snowflake-data-sharing/



True or False: You can define multiple columns within a clustering key on a table.

  1. True
  2. False

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html



True or False: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

  1. True
  2. False

Answer(s): B


Reference:

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






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

Join the COF-C02 Discussion