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: 4)

COF-C02 PDF — 1300 Questions

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  1. True
  2. False

Answer(s): A



Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  1. Customers can change the size of the Warehouse after creation
  2. A Warehouse can be resized while running
  3. A Warehouse can be configured to suspend after a period of inactivity
  4. A Warehouse can be configured to auto-resume when new queries are submitted

Answer(s): A,B



The PUT command: (Choose two.)

  1. Automatically creates a File Format object
  2. Automatically uses the last Stage created
  3. Automatically compresses files using Gzip
  4. Automatically encrypts files

Answer(s): C,D


Reference:

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



Which type of table corresponds to a single Snowflake session?

  1. Temporary
  2. Transient
  3. Provisional
  4. Permanent

Answer(s): A



Which interfaces can be used to create and/or manage Virtual Warehouses?

  1. The Snowflake Web Interface (UI)
  2. SQL commands
  3. Data integration tools
  4. All of the above

Answer(s): D



When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  1. The Pipe load history is reset to empty
  2. The REFRESH parameter is set to TRUE
  3. Previously loaded files will be ignored
  4. All of the above

Answer(s): A



What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  1. Standard
  2. Premier
  3. Enterprise
  4. Business Critical Edition

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html



Select the three types of tables that exist within Snowflake. (Choose three.)

  1. Temporary
  2. Transient
  3. Provisional
  4. Permanent

Answer(s): A,B,D


Reference:

https://community.snowflake.com/s/article/Making-Transient-table-by-Default



Viewing page 4 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!