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 15

Question No : 211) Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

A. PUT

B. GET

C. COPY

D. SELECT


Question No : 212) When should a multi-cluster warehouse be used in auto-scaling mode?

A. When it is unknown how much compute power is needed 

B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C. If the runtime of the executed query is very slow

D. When a large number of concurrent queries are run on the same warehouse


Question No : 213) Which Snowflake layer is always leveraged when accessing a query from the result cache?

A. Metadata

B. Data Storage

C. Compute

D. Cloud Services


Question No : 214) Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A. INSERT

B. PUT

C. GET

D. COPY


Question No : 215) Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

A. PURGE

B. MODIFY

C. REMOVE

D. DELETE


Question No : 216) What is the minimum Snowflake edition required for row level security?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake


Question No : 217)  Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

A. Query execution

B. Data loading

C. Time Travel data

D. Security

E. Authentication and access control


Question No : 218) What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.

B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.

C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.

F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.


Question No : 219) Which of the following are characteristics of security in Snowflake?

A. Account and user authentication is only available with the Snowflake Business Critical edition.

B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions. 

C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.


Question No : 220) Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

A. Pre-signed URL

B. Scoped URL

C. Signed URL

D. File URL


Question No : 221) When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B. An error will occur, as views with qualified references cannot be cloned.

C. An error will occur, as stored objects cannot be cloned.

D. The stored procedures and views will refer to tables in the source database.


Question No : 222) What file formats does Snowflake support for loading semi-structured data? (Choose three.)

A. TSV

B. JSON

C. PDF

D. Avro

E. Parquet

F. JPEG


Question No : 223) Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A. Schema Stage

B. User Stage

C. Database Stage

D. Table Stage

E. External Named Stage

F. Internal Named Stage


Question No : 224) When cloning a database, what is cloned with the database? (Choose two.)

A. Privileges on the database

B. Existing child objects within the database

C. Future child objects within the database

D. Privileges on the schemas within the database

E. Only schemas and tables within the database


Question No : 225) What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A. The clone always stays in sync with the original table.

B. The clone has better query performance.

C. The clone is created almost instantly.

D. The clone will have time travel history from the original table.

E. The clone saves space by not duplicating storage.

 

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.