Logo
  • Home
  • All Courses
    • Amazon - AWS
    • Cisco
    • CompTIA
    • EC Council
    • Microsoft
    • Oracle
    • Salesforce
    • Snowflake
  • Testimonials
  • Blogs
  • Login
  • Register
  • Cart

SnowPro Core Certification Exam (COF-C02) Free Questions - Part 3

Question No : 31) Will data cached in a warehouse be lost when the warehouse is resized?

A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B. Yes. because the compute resource is replaced in its entirety with a new compute resource.

C. No. because the size of the cache is independent from the warehouse size

D. Yes. became the new compute resource will no longer have access to the cache encryption key

 

Question No : 32) Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A. Each Snowflake account can be hosted in a different cloud vendor and region.

B. Each Snowflake account must be hosted in a different cloud vendor and region

C. All Snowflake accounts must be hosted in the same cloud vendor and region

D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

 

Question No : 33) What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A. Data can be filtered by an optional where clause

B. Incoming data can be joined with other tables

C. Columns can be reordered

D. Columns can be omitted

E. Row level access can be defined

 

Question No : 34) What is a responsibility of Snowflake's virtual warehouses?

A. Infrastructure management

B. Metadata management

C. Query execution

D. Query parsing and optimization

E. Management of the storage layer

 

Question No : 35) What tasks can be completed using the copy command? (Select TWO)

A. Columns can be aggregated

B. Columns can be joined with an existing table

C. Columns can be reordered

D. Columns can be omitted

E. Data can be loaded without the need to spin up a virtual warehouse

 

Question No : 36) Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

A. Load files that are approximately 25 MB or smaller.

B. Remove all dates and timestamps.

C. Load files that are approximately 100-250 MB (or larger)

D. Avoid using embedded characters such as commas for numeric data types

E. Remove semi-structured data types

 

Question No : 37) A sales table FCT_SALES has 100 million records. The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

A. Query against the result set cache

B. Query against a virtual warehouse cache

C. Query against the most-recently created micro-partition

D. Query against the metadata excite

 

Question No : 38) Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A. Pipes

B. Streams

C. Tasks

D. Procedures

 

Question No : 39) The fail-safe retention period is how many days?

A. 1 day

B. 7 days

C. 45 days

D. 90 days

 

Question No : 40) In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A. Bytes scanned

B. Bytes sent over the network

C. Number of partitions scanned

D. Percentage scanned from cache

E. External bytes scanned

 

Question No : 41) What is the purpose of an External Function?

A. To call code that executes outside of Snowflake

B. To run a function in another Snowflake database

C. To share data in Snowflake with external parties

D. To ingest data from on-premises data sources

 

Question No : 42) Which command can be used to load data into an internal stage?

A. LOAD

B. copy

C. GET

D. PUT

 

Question No : 43) What feature can be used to reorganize a very large table on one or more columns?

A. Micro-partitions

B. Clustering keys

C. Key partitions

D. Clustered partitions

 

Question No : 44) True or False: A Virtual Warehouse can be resized while suspended.

A. True

B. False

 

Question No : 45) Which of the following describes how clustering keys work in Snowflake?

A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B. Clustering keys sort the designated columns over time, without blocking DML operations

C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

 

COF-C02 Answers

 

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

Part 9

Part 10

Part 11

Part 12

Part 13

Part 14

Part 15

Part 16

Part 17

Part 18

Logo

Our goal is to help students clear their exam by providing them genuine questions which helps students to achieve their goal. Many students have cleared their exam by going through our courses. Are you ready to clear yours?


Site Secured

mcaafe-secure

Last Scanned: 08-05-2025

Links

  • FAQ
  • Money Back Guarantee
  • About Us
  • Privacy Policy
  • Terms & Conditions
  • Contact Us
  • Testimonials

Disclaimer

  • SAP, Microsoft, Google, Amazon, Qualtrics, and all other brands are Registered Trademarks of their respective companies.
  • Theexamquestions.com is no way affiliated With any brand hosted on this website.
  • Theexamquestions.com offers only probable exam questions and answers.
  • Theexamquestions.com offer learning materials and practice tests created by subject matter technology experts to assist and help learners prepare for those exams. Theexamquestions.com do not offer dumps or questions from the actual exam.
  • Theexamquestions.com does not own or claim any ownership on any of the brands.
  • All Certification Brands used on the website are owned by the respective brand owners.

All course contents, trademarks, service marks, trade names, product names and logos appearing on the site are the property of their respective owners. The website Theexamquestions.com is in no way affiliated with any of the certification providers. Copyright © 2025 www.theexamquestions.com. All rights reserved.