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 9

Question No : 121) Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B. Allows a user to import the files in a sequential order

C. Increases the latency staging and accuracy when loading the data

D. Allows optimization of parallel operations

 

Question No : 122) Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

A. Schemas

B. Roles

C. Secure Views

D. Stored Procedures

E. Tables

F. Secure User-Defined Functions (UDFs)

 

Question No : 123) What are supported file formats for unloading data from Snowflake? (Choose three.)

A. XML

B. JSON

C. Parquet

D. ORC

E. AVRO

F. CSV

 

Question No : 124) What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

A. The warehouse size does not change until all queries currently running in the warehouse have completed.

B. The warehouse size does not change until all queries currently in the warehouse queue have completed.

C. The warehouse size does not change until the warehouse is suspended and restarted.

D. It does not return from the command until the warehouse has finished changing its size.

 

Question No : 125) Which of the following statements describe features of Snowflake data caching? (Choose two.)

A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B. When the data cache is full, the least-recently used data will be cleared to make room.

C. A user can only access their own queries from the query result cache.

D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

 

Question No : 126) Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

A. Data is live, ready-to-query, and can be personalized.

B. Data needs to be loaded into a cloud provider as a consumer account.

C. Data is not available for copying or moving to an individual Snowflake account.

D. Data is available without copying or moving.

E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

 

Question No : 127) In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A. When the system has enough load for 2 minutes

B. When the system has enough load for 6 minutes

C. When the system has enough load for 8 minutes

D. When the system has enough load for 10 minutes

 

Question No : 128) A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share. Based on this configuration what is true of the reader account?

A. The reader account will automatically use the Standard edition of Snowflake.

B. The reader account compute will be billed to the provider account.

C. The reader account can clone data the provider has shared, but cannot re-share it.

D. The reader account can create a copy of the shared data using CREATE TABLE AS...

 

Question No : 129) Which command sets the Virtual Warehouse for a session?

A. COPY WAREHOUSE FROM <>;
B. SET WAREHOUSE = <>;
C. USE WAREHOUSE <>;
D. USE VIRTUAL_WAREHOUSE <>; 

 

Question No : 130) Which of the following accurately describes shares?

A. Tables, secure views, and secure UDFs can be shared

B. Shares can be shared

C. Data consumers can clone a new table from a share

D. Access to a share cannot be revoked once granted

 

Question No : 131) Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

A. The number of queries executed

B. The number of active users assigned to the warehouse

C. The size of the virtual warehouse

D. The length of time the warehouse is running

E. The duration of the queries that are executed

 

Question No : 132) How can a user change which columns are referenced in a view?

A. Modify the columns in the underlying table

B. Use the ALTER VIEW command to update the view

C. Recreate the view with the required changes

D. Materialize the view to perform the changes

 

Question No : 133) Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

A. COPY INTO

B. CREATE PIPE

C. INSERT INTO

D. TABLE STREAM

 

Question No : 134) What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake

 

Question No : 135) What are common issues found by using the Query Profile? (Choose two.)

A. Identifying queries that will likely run very slowly before executing them

B. Locating queries that consume a high amount of credits

C. Identifying logical issues with the queries

D. Identifying inefficient micro-partition pruning

E. Data spilling to a local or remote disk

 

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.