Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. Snowflake
  3. COF-C02

Snowflake SnowPro Core COF-C02 Exam Questions in PDF

Free Snowflake COF-C02 Dumps Questions (page: 16)

COF-C02 PDF — 1300 Questions

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



True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  1. True
  2. False

Answer(s): B


Reference:

https://www.mobilize.net/blog/overcoming-the-filesize-limit-when-importing-data-into-snowflake



True or False: A Virtual Warehouse can be resized while suspended.

  1. True
  2. False

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse



True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html



Viewing page 16 of 139

Share your comments for Snowflake COF-C02 exam with other users:

A
AI Tutor Explanation
4/25/2026 1:42:20 PM

Question 104:

  • Correct answer: D) Multi-Terabyte (TB) Range

  • Brief explanation:
- clustering keys organize data into micro-partitions to improve pruning when queries filter on those columns. - The performance benefit is most significant for very large tables; for small tables the overhead of maintaining clustering outweighs gains. - Therefore, as a best practice, define clustering keys on tables at the TB scale.

Thane, India
A
AI Tutor Explanation
4/21/2026 8:48:36 AM

Question 3:

  • False is the correct answer (Option B).

Why:
  • In Snowflake, a database is a metadata object that exists within a single Snowflake account. Accounts are isolated—there isn’t one database that lives in multiple accounts.
  • You can access data across accounts via data sharing or database replication, but these create separate database objects in the other accounts (e.g., a database in the consumer account created from a share), not a single shared database across accounts.

So a single database cannot exist in more than one Snowflake account.

Thane, India
AI Tutor 👋 I’m here to help!