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

COF-C02 PDF — 1300 Questions

What is a key feature of Snowflake architecture?

  1. Zero-copy cloning creates a mirror copy of a database that updates with the original.
  2. Software updates are automatically applied on a quarterly basis.
  3. Snowflake eliminates resource contention with its virtual warehouse implementation.
  4. Multi-cluster warehouses allow users to run a query that spans across multiple clusters.
  5. Snowflake automatically sorts DATE columns during ingest, for fast retrieval by date.

Answer(s): C



When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  1. There is no need to have a Snowflake account in the target region, a share will be created for each user.
  2. The listing is replicated into all selected regions automatically, the data is not.
  3. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
  4. Shares attached to listings in remote regions can be viewed from any account in an organization.
  5. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Answer(s): B,E



When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  1. 10-50 MB
  2. 100-250 MB
  3. 300-500 MB
  4. 1000-1500 MB

Answer(s): B



Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  1. External Tokenization
  2. External Tables
  3. Materialized Views
  4. User-Defined Table Functions (UDTF)

Answer(s): A



Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)

  1. MIN(<< column value >>)
  2. COPY
  3. SUM(<< column value >>)
  4. UPDATE

Answer(s): B,C,D



What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  1. VIEWS_HISTORY
  2. OBJECT_HISTORY
  3. ACCESS_HISTORY
  4. LOGIN_HISTORY

Answer(s): C



Which feature is only available in the Enterprise or higher editions of Snowflake?

  1. Column-level security
  2. SOC 2 type II certification
  3. Multi-factor Authentication (MFA)
  4. Object-level access control

Answer(s): A


Reference:

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



Will data cached in a warehouse be lost when the warehouse is resized?

  1. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  2. Yes, because the compute resource is replaced in its entirety with a new compute resource.
  3. No, because the size of the cache is independent from the warehouse size.
  4. Yes, because the new compute resource will no longer have access to the cache encryption key.

Answer(s): D



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