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

COF-C02 PDF — 1300 Questions

Network policies can be set at which Snowflake levels? (Choose two.)

  1. Role
  2. Schema
  3. User
  4. Database
  5. Account
  6. Tables

Answer(s): C,E


Reference:

https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies



What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  1. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 30 days.
    Fail Safe retention time is 1 day.
  2. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 365 days.
    Fail Safe retention time is 7 days.
  3. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  4. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  5. Default Time Travel Retention is set to 7 days.
    Maximum Time Travel Retention is 1 day.
    Fail Safe retention time is 90 days.
  6. Default Time Travel Retention is set to 90 days.
    Maximum Time Travel Retention is 7 days.
    Fail Safe retention time is 356 days.

Answer(s): D



Which of the following objects are contained within a schema? (Choose two.)

  1. Role
  2. Stream
  3. Warehouse
  4. External table
  5. User
  6. Share

Answer(s): B,D



Which of the following statements describe features of Snowflake data caching? (Choose two.)

  1. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
  2. When the data cache is full, the least-recently used data will be cleared to make room.
  3. A user can only access their own queries from the query result cache.
  4. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  5. The RESULT_SCAN table function can access and filter the contents of the query result cache.

Answer(s): B,E



A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

  1. Compress the file and load the compressed file.
  2. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
  3. Use a larger-sized warehouse.
  4. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Answer(s): D



What is a feature of a stored procedure in Snowflake?

  1. They can be created as secure and hide the underlying metadata from all users.
  2. They can access tables from a single database.
  3. They can only contain a single SQL statement.
  4. They can be created to run with a caller's rights or an owner's rights.

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html



Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  1. CONTENT
  2. PATH
  3. BYTE_SIZE
  4. INDEX
  5. DATATYPE

Answer(s): B,D



What is the minimum Snowflake edition required to create a materialized view?

  1. Standard Edition
  2. Enterprise Edition
  3. Business Critical Edition
  4. Virtual Private Snowflake Edition

Answer(s): B



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