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 16

Question No : 226) Which command can be used to load data files into a Snowflake stage?

A. JOIN

B. COPY INTO

C. PUT

D. GET


Question No : 227) What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

A. Authentication

B. Resource management

C. Virtual warehouse caching

D. Query parsing and optimization

E. Query execution

F. Physical storage of micro-partitions


Question No : 228) A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

A. view @my_stage

B. list @my_stage

C. show @my_stage

D. display @my_stage


Question No : 229) What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A. The explain plan output is available graphically.

B. An explain plan can be used to conduct performance analysis without executing a query.

C. An explain plan will handle queries with temporary tables and the query profiler will not.

D. An explain plan's output will display automatic data skew optimization information.


Question No : 230) What affects whether the query results cache can be used?

A. If the query contains a deterministic function

B. If the virtual warehouse has been suspended

C. If the referenced data in the table has changed

D. If multiple users are using the same virtual warehouse


Question No : 231) What is the recommended compressed file size range for continuous data loads using Snowpipe?

A. 8-16 MB

B. 16-24 MB

C. 10-99 MB

D. 100-250 MB


Question No : 232) Which of the following is a data tokenization integration partner?

A. Protegrity

B. Tableau

C. DBeaver

D. SAP


Question No : 233) What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

A. Custom Edition

B. Virtual Private Snowflake

C. Business Critical Edition

D. Standard Edition

E. Enterprise Edition


Question No : 234) Which of the following describes a Snowflake stored procedure?

A. They can be created as secure and hide the underlying metadata from the user.

B. They can only access tables from a single database.

C. They can contain only a single SQL statement.

D. They can be created to run with a caller's rights or an owner's rights.


Question No : 235) Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

A. Files

B. External tables

C. Secure User-Defined Functions (UDFs)

D. Sequences

E. Streams


Question No : 236) Which Snowflake architectural layer is responsible for a query execution plan?

A. Compute

B. Data storage

C. Cloud services

D. Cloud provider


Question No : 237) What is a responsibility of Snowflake’s virtual warehouses?

A. Infrastructure management

B. Metadata management

C. Query execution

D. Query parsing and optimization

E. Permanent storage of micro-partitions


Question No : 238) Network policies can be set at which Snowflake levels? (Choose two.)

A. Role

B. Schema

C. User

D. Database

E. Account

F. Tables


Question No : 239) Using variables in Snowflake is denoted by using which SQL character?

A. @

B. &

C. $

D. #


Question No : 240) Which statement describes how Snowflake supports reader accounts?

A. A reader account can consume data from the provider account that created it and combine it with its own data.

B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
 

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.