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

COF-C02 PDF — 1300 Questions

The FLATTEN function is used to query which type of data in Snowflake?

  1. Structured data
  2. Semi-structured data
  3. Both of the above
  4. None of the above

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/querying-semistructured.html



True or False: An active warehouse is required to run a COPY INTO statement.

  1. True
  2. False

Answer(s): A



True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html



True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  1. True
  2. False

Answer(s): A



True or False: It is best practice to define a clustering key on every table.

  1. True
  2. False

Answer(s): B


Reference:

https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/



Which of the following statements is true of Snowflake?

  1. It was built specifically for the cloud
  2. It was built as an on-premises solution and then ported to the cloud
  3. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
  4. It was built for Hadoop architecture
  5. It's based on an Oracle Architecture

Answer(s): A


Reference:

https://www.stitchdata.com/resources/snowflake/



What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

  1. Standard
  2. Premier
  3. Enterprise
  4. Business Critical Edition

Answer(s): C


Reference:

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



How many shares can be consumed by a single Data Consumer?

  1. 1
  2. 10
  3. 100, but can be increased by contacting support
  4. Unlimited

Answer(s): D


Reference:

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



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