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

COF-C02 PDF — 1300 Questions

True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

  1. True
  2. False

Answer(s): B



True or False: Pipes can be suspended and resumed.

  1. True
  2. False

Answer(s): A



Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)

  1. Java
  2. Javascript
  3. SQL
  4. Python

Answer(s): B,C


Reference:

https://docs.snowflake.com/en/sql-reference/user-defined-functions.html



When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)

  1. When users will be using compute at different times throughout a 24/7 period
  2. When managing a steady workload
  3. When the compute must be available with no delay or lag time
  4. When you do not want to have to manually turn on the Warehouse each time a user needs it

Answer(s): B,C


Reference:

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



Which of the following are valid approaches to loading data into a Snowflake table? (Choose all that apply.)

  1. Bulk copy from an External Stage
  2. Continuous load using Snowpipe REST API
  3. The Snowflake Web Interface (UI) data loading wizard
  4. Bulk copy from an Internal Stage

Answer(s): A,B,C


Reference:

https://docs.snowflake.com/en/user-guide/data-load-overview.html



If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when:

  1. All Snowflakes sessions using the Warehouse are terminated.
  2. The last query using the Warehouse completes.
  3. There are no users logged into Snowflake.
  4. The Warehouse is inactive for a specified period of time.

Answer(s): D


Reference:

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



True or False: Multi-Factor Authentication (MFA) in Snowflake is only supported in conjunction with Single Sign-On (SSO).

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html



The number of queries that a Virtual Warehouse can concurrently process is determined by (Choose two.):

  1. The complexity of each query
  2. The CONCURRENT_QUERY_LIMIT parameter set on the Snowflake account
  3. The size of the data required for each query
  4. The tool that is executing the query

Answer(s): A,C


Reference:

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



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