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

COF-C02 PDF — 1300 Questions

Which Snowflake layer is always leveraged when accessing a query from the result cache?

  1. Metadata
  2. Data Storage
  3. Compute
  4. Cloud Services

Answer(s): D



Which connectors are available in the downloads section of the Snowflake web interface (UI)? (Choose two.)

  1. SnowSQL
  2. JDBC
  3. ODBC
  4. HIVE
  5. Scala

Answer(s): B,C



A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

  1. Use data encryption.
  2. Use dynamic data masking.
  3. Use secure materialized views.
  4. Revoke all roles for functional managers and end users.

Answer(s): B



Users are responsible for data storage costs until what occurs?

  1. Data expires from Time Travel
  2. Data expires from Fail-safe
  3. Data is deleted from a table
  4. Data is truncated from a table

Answer(s): B



A user has an application that writes a new file to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

  1. Create a task that runs a COPY INTO operation from an external stage every 5 minutes.
  2. Create a task that PUTS the files in an internal stage and automate the data loading wizard.
  3. Create a task that runs a GET operation to intermittently check for new files.
  4. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

Answer(s): D



What affects whether the query results cache can be used?

  1. If the query contains a deterministic function
  2. If the virtual warehouse has been suspended
  3. If the referenced data in the table has changed
  4. If multiple users are using the same virtual warehouse

Answer(s): C



Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

  1. SELECT SUM (ORDER_AMT) FROM SALES;
  2. SELECT AVG(ORDER_QTY) FROM SALES;
  3. SELECT MIN(ORDER_AMT) FROM SALES;
  4. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Answer(s): C



How many days is load history for Snowpipe retained?

  1. 1 day
  2. 7 days
  3. 14 days
  4. 64 days

Answer(s): C



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