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 10

Question No : 136) Which of the following significantly improves the performance of selective point lookup queries on a table?

A. Clustering

B. Materialized Views

C. Zero-copy Cloning

D. Search Optimization Service

 

Question No : 137) Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B. A Data Exchange allows groups of accounts to share data privately among the accounts.

C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

 

Question No : 138) By default, which Snowflake role is required to create a share?

A. ORGADMIN

B. SECURITYADMIN

C. SHAREADMIN

D. ACCOUNTADMIN

 

Question No : 139) What internal stages are available in Snowflake? (Choose three.)

A. Schema stage

B. Named stage

C. User stage

D. Stream stage

E. Table stage

F. Database stage

 

Question No : 140) When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

A. 10-50 MB

B. 100-250 MB

C. 300-500 MB

D. 1000-1500 MB

 

Question No : 141) A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?

A. Use auto-ingest Snowpipes to load large files in a serverless model.

B. Produce the largest files possible, reducing the overall number of files to process.

C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

 

Question No : 142) A user created a new worksheet within the Snowsight Ul and wants to share this with teammates. How can this worksheet be shared?

A. Create a zero-copy clone of the worksheet and grant permissions to teammates

B. Create a private Data Exchange so that any teammate can use the worksheet

C. Share the worksheet with teammates within Snowsight

D. Create a database and grant all permissions to teammates

 

Question No : 143) What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A. The shared objects are transferred.

B. The shared objects are copied.

C. The shared objects become accessible.

D. The shared objects can be re-shared.

 

Question No : 144) User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW. Which command will show all privileges granted to that schema?

A. SHOW GRANTS ON ROLE DATA_SCIENCE

B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C. SHOW GRANTS TO USER INQUISITIVE_PERSON

D. SHOW GRANTS OF ROLE DATA_SCIENCE

 

Question No : 145) What is the maximum Time Travel retention period for a temporary Snowflake table?

A. 90 days

B. 1 day

C. 7 days

D. 45 days

 

Question No : 146) How many resource monitors can be assigned at the account level?

A. 1

B. 2

C. 3

D. 4

 

Question No : 147) Which of the following can be used when unloading data from Snowflake? (Choose two.)

A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B. Use the ENCODING file format option to change the encoding from the default UTF-8.

C. The OBJECT_CONSTRUCT function can be used to convert relational data to semistructured data.

D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

 

Question No : 148) The Snowflake Cloud Data Platform is described as having which of the following architectures?

A. Shared-disk

B. Shared-nothing

C. Multi-cluster shared data

D. Serverless query engine

 

Question No : 149) What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A. Reader

B. Consumer

C. Vendor

D. Standard

E. Personalized

 

Question No : 150) In the Snowflake access control model, which entity owns an object by default?

A. The user who created the object

B. The SYSADMIN role

C. Ownership depends on the type of object

D. The role used to create the object

 

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.