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

COF-C02 PDF — 1300 Questions

Which formats are supported for unloading data from Snowflake? (Choose two.)

  1. Delimited (CSV, TSV, etc.)
  2. Avro
  3. JSON
  4. ORC

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html



True or False: Data Providers can share data with only the Data Consumer.

  1. True
  2. False

Answer(s): B



The fail-safe retention period is how many days?

  1. 1 day
  2. 7 days
  3. 45 days
  4. 90 days

Answer(s): B


Reference:

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



True or False: Once created, a micro-partition will never be changed.

  1. True
  2. False

Answer(s): A


Reference:

https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/



What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)

  1. Installing and configuring hardware
  2. Patching software
  3. Physical security
  4. Maintaining metadata and statistics

Answer(s): A,B,D



Which of the following statements would be used to export/unload data from Snowflake?

  1. COPY INTO @stage
  2. EXPORT TO @stage
  3. INSERT INTO @stage
  4. EXPORT_TO_STAGE(stage => @stage, select => 'select * from t1');

Answer(s): A


Reference:

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



True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  1. True
  2. False

Answer(s): A



How would you determine the size of the virtual warehouse used for a task?

  1. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
  2. Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
  3. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
  4. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer(s): C



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