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

COF-C02 PDF — 1300 Questions

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Choose two.)

  1. The ability to scale up warehouses
  2. The use of warehouse auto scaling
  3. The ability to resize warehouses
  4. Use of multi-clustered warehouses
  5. The use of warehouse indexing

Answer(s): B,D



Which COPY INTO command outputs the data into one file?

  1. SINGLE=TRUE
  2. MAX_FILE_NUMBER=1
  3. FILE_NUMBER=1
  4. MULTIPLE=FALSE

Answer(s): A



In which scenarios would a user have to pay Cloud Services costs? (Choose two.)

  1. Compute Credits = 50 Credits Cloud Services = 10
  2. Compute Credits = 80 Credits Cloud Services = 5
  3. Compute Credits = 100 Credits Cloud Services = 9
  4. Compute Credits = 120 Credits Cloud Services = 10
  5. Compute Credits = 200 Credits Cloud Services = 26

Answer(s): A,E



A user created a new worksheet within the Snowsight UI and wants to share this with teammates.
How can this worksheet be shared?

  1. Create a zero-copy clone of the worksheet and grant permissions to teammates.
  2. Create a private Data Exchange so that any teammate can use the worksheet.
  3. Share the worksheet with teammates within Snowsight.
  4. Create a database and grant all permissions to teammates.

Answer(s): C



How can a row access policy be applied to a table or a view? (Choose two.)

  1. Within the policy DDL
  2. Within the create table or create view DDL
  3. By future APPLY for all objects in a schema
  4. Within a control table
  5. Using the command ALTER

Answer(s): B,E



Which command can be used to load data files into a Snowflake stage?

  1. JOIN
  2. COPY INTO
  3. PUT
  4. GET

Answer(s): C



What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  1. Reader
  2. Consumer
  3. Vendor
  4. Standard
  5. Personalized

Answer(s): D,E



What is the maximum Time Travel retention period for a temporary Snowflake table?

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

Answer(s): B



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