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 2

Question No : 16) Which data type can be used to store geospatial data in Snowflake?

A. Variant

B. Object

C. Geometry

D. Geography

 

Question No : 17) Which command is used to unload data from a Snowflake table into a file in a stage?

A. COPY INTO

B. GET

C. WRITE

D. EXTRACT INTO

 

Question No : 18) True or False: Fail-safe can be disabled within a Snowflake account.

A. True

B. False

 

Question No : 19) What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A. The ability to scale up warehouses

B. The use of warehouse auto scaling

C. The ability to resize warehouses

D. Use of multi-clustered warehouses

E. The use of warehouse indexing

 

Question No : 20) What Snowflake role must be granted for a user to create and manage accounts?

A. ACCOUNTADMIN

B. ORGADMIN

C. SECURITYADMIN

D. SYSADMIN

 

Question No : 21) What is a limitation of a Materialized View?

A. A Materialized View cannot support any aggregate functions

B. A Materialized View can only reference up to two tables

C. A Materialized View cannot be joined with other tables

D. A Materialized View cannot be defined with a JOIN

 

Question No : 22) True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A. True

B. False

 

Question No : 23) What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

A. Data is hashed by the cluster key to facilitate fast searches for common data values

B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C. Smaller micro-partitions are created for common data values to allow for more parallelism

D. Data may be co-located by the cluster key within the micro-partitions to improve pruning performance

 

Question No : 24) Which services does the Snowflake Cloud Services layer manage? (Select TWO).

A. Compute resources

B. Query execution

C. Authentication

D. Data storage

E. Metadata

 

Question No : 25) In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A. Compute Credits = 50 Credits Cloud Services = 10

B. Compute Credits = 80 Credits Cloud Services = 5

C. Compute Credits = 10 Credits Cloud Services = 9

D. Compute Credits = 120 Credits Cloud Services = 10

E. Compute Credits = 200 Credits Cloud Services = 26

 

Question No : 26) Where would a Snowflake user find information about query activity from 90 days ago?

A. account__usage . query history view

B. account__usage.query__history__archive View

C. information__schema . cruery_history view

D. information__schema - query history_by_ses s i on view

 

Question No : 27) What can be used to view warehouse usage over time? (Select Two).

A. The load HISTORY view

B. The Query history view

C. The show warehouses command

D. The WAREHOUSE_METERING__HISTORY View

E. The billing and usage tab in the Snowflake web Ul

 

Question No : 28) Which Snowflake feature is used for both querying and restoring data?

A. Cluster keys

B. Time Travel

C. Fail-safe

D. Cloning

 

Question No : 29) When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse. According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

A. Use multi-clustered warehousing to scale out warehouse capacity.

B. Scale up the warehouse size to allow Queries to execute faster.

C. Stop and start the warehouse to clear the queued queries

D. Migrate some queries to a new warehouse to reduce load

E. Limit user access to the warehouse so fewer queries are run against it.

 

Question No : 30) During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

A. STATEMENT_TIMEOUT__IN__SECONDS

B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C. MAX_CONCURRENCY__LEVEL

D. QUERY_TIMEOUT_IN_SECONDS

 

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.