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 7

Question No : 91) Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

A. ORC

B. XML

C. Avro

D. Parquet

E. JSON

 

Question No : 92) What is the MOST performant file format for loading data in Snowflake?

A. CSV (Unzipped)

B. Parquet

C. CSV (Gzipped)

D. ORC

 

Question No : 93)  A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

A. The primary cluster in the virtual warehouse

B. The entire virtual warehouse

C. The database in which the virtual warehouse resides

D. The Queries currently being run on the virtual warehouse

 

Question No : 94) What happens when a cloned table is replicated to a secondary database? (Select TWO)

A. A read-only copy of the cloned tables is stored.

B. The replication will not be successful.

C. The physical data is replicated

D. Additional costs for storage are charged to a secondary account

E. Metadata pointers to cloned tables are replicated

 

Question No : 95) How would you determine the size of the virtual warehouse used for a task?

A. 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 

B. 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

C. 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

D. 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

 

Question No : 96) What happens when a virtual warehouse is resized?

A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected 

B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete. 

D. Users who are trying to use the warehouse will receive an error message until the resizing is complete

 

Question No : 97) Which stage type can be altered and dropped?

A. Database stage

B. External stage

C. Table stage

D. User stage

 

Question No : 98) 

In which use cases does Snowflake apply egress charges?
A. Data sharing within a specific region
B. Query result retrieval
C. Database replication
D. Loading data into Snowflake

 

Question No : 99) What is the recommended file sizing for data loading using Snowpipe?

A. A compressed file size greater than 100 MB, and up to 250 MB

B. A compressed file size greater than 100 GB, and up to 250 GB

C. A compressed file size greater than 10 MB, and up to 100 MB

D. A compressed file size greater than 1 GB, and up to 2 GB

 

Question No : 100) A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?

A. Organize files into logical paths

B. Store the files on the external stage to ensure caching is maintained

C. Use pattern matching for regular expression execution

D. Load the data in one large file

 

Question No : 101) Which of the following statements describes a schema in Snowflake?

A. A logical grouping of objects that belongs to a single database

B. A logical grouping of objects that belongs to multiple databases

C. A named Snowflake object that includes all the information required to share a database

D. A uniquely identified Snowflake account within a business entity

 

Question No : 102) Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A. Gathering the hourly credit usage for an account

B. Compiling an account's average cloud services cost over the previous month

C. Summarizing the throughput of Snowpipe costs for an account

D. Calculating the funds left on an account's contract

 

Question No : 103) How would a user run a multi-cluster warehouse in maximized mode?

A. Configure the maximum clusters setting to "Maximum."

B. Turn on the additional clusters manually after starting the warehouse.

C. Set the minimum Clusters and maximum Clusters settings to the same value.

D. Set the minimum clusters and maximum clusters settings to different values.

 

Question No : 104) A materialized view should be created when which of the following occurs? (Choose two.)

A. There is minimal cost associated with running the query.

B. The query consumes many compute resources every time it runs.

C. The base table gets updated frequently.

D. The query is highly optimized and does not consume many compute resources.

E. The results of the query do not change often and are used frequently.

 

Question No : 105) What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

A. To validate external table files in table t1 across all sessions

B. To validate task SQL statements against table t1 in the last 14 days

C. To validate a file for errors before it gets executed using a COPY command

D. To return errors from the last executed COPY command into table t1 in the current

session

 

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.