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 13

Question No : 181) Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A. Use the DROP command after the load completes.

B. Specify the TEMPORARY option when creating the file format.

C. Specify the PURGE copy option in the COPY INTO command.

D. Use the REMOVE command after the load completes.

E. Use the DELETE LOAD HISTORY command after the load completes.


Question No : 182) What COPY INTO SQL command should be used to unload data into multiple files?

A. SINGLE=TRUE

B. MULTIPLE=TRUE

C. MULTIPLE=FALSE

D. SINGLE=FALSE


Question No : 183) A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

A. 1 second

B. 60 seconds

C. 5 minutes

D. 60 minutes


Question No : 184) How many days is load history for Snowpipe retained?

A. 1 day

B. 7 days

C. 14 days

D. 64 days


Question No : 185) Which file formats are supported for unloading data from Snowflake? (Choose two.)

A. Avro

B. JSON

C. ORC

D. XML

E. Delimited (CSV, TSV, etc.)


Question No : 186) Which statement describes pruning?

A. The filtering or disregarding of micro-partitions that are not needed to return a query.

B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

D. The ability to allow the result of a query to be accessed as if it were a table.


Question No : 187) The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

A. Local disk caching

B. Authentication and access control

C. Metadata management

D. Query processing

E. Database storage


Question No : 188) The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the target table for 14 days

B. In the metadata of the pipe for 14 days

C. In the metadata of the target table for 64 days

D. In the metadata of the pipe for 64 days


Question No : 189) True or False: Snowpipe via REST API can only reference External Stages as source.

A. True

B. False


Question No : 190) Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

A. Database replication and failover

B. Automated index management

C. Customer managed keys (Tri-secret secure)

D. Extended time travel

E. Native support for geospatial data


Question No : 191) What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A. 30 days

B. 7 days

C. 48 hours

D. 24 hours


Question No : 192) Where can a user find and review the failed logins of a specific user for the past 30 days?

A. The USERS view in ACCOUNT_USAGE

B. The LOGIN_HISTORY view in ACCOUNT_USAGE

C. The ACCESS_HISTORY view in ACCOUNT_USAGE

D. The SESSIONS view in ACCOUNT_USAGE


Question No : 193) Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

A. Caching query results

B. Running EXPLAIN and SHOW commands

C. Cloning a database

D. Running a custom query

E. Running COPY commands


Question No : 194) A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?

A. No virtual warehouse will be used, data will be read from the result cache.

B. No virtual warehouse will be used, data will be read from the local disk cache.

C. The default virtual warehouse will be used to read all data.

D. The virtual warehouse that is defined at the session level will be used to read all data.


Question No : 195) If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A. 4

B. 8

C. 16

D. 32
 

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.