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 12

Question No : 166) Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

A. CREATE_SHARE on the account

B. SHARE on databases and schemas

C. SELECT on tables used by the secure view

D. REFERENCE_USAGE on databases


Question No : 167) Which SQL command can be used to see the CREATE definition of a masking policy?

A. SHOW MASKING POLICIES

B. DESCRIBE MASKING POLICY

C. GET_DDL

D. LIST MASKING POLICIES


Question No : 168) A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?

A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

B. The transient table version cannot be retrieved after 24 hours.

C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.

D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.


Question No : 169) Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

A. UPDATE TABLE FROM STREAM

B. SELECT FROM STREAM

C. INSERT INTO TABLE SELECT FROM STREAM

D. ALTER TABLE AS SELECT FROM STREAM

E. BEGIN COMMIT


Question No : 170) What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B. Scaling out adds clusters of varying sizes to a virtual warehouse.

C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.


Question No : 171) Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A. SHOW STORAGE BY TABLE;

B. SHOW TABLES;

C. Information Schema -> TABLE_HISTORY

D. Information Schema -> TABLE_FUNCTION

E. Information Schema -> TABLE_STORAGE_METRICS


Question No : 172) Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

A. External Tokenization

B. External Tables

C. Materialized Views

D. User-Defined Table Functions (UDTF)


Question No : 173) What type of query benefits the MOST from search optimization?

A. A query that uses only disjunction (i.e., OR) predicates

B. A query that includes analytical expressions

C. A query that uses equality predicates or predicates that use IN

D. A query that filters on semi-structured data types


Question No : 174) If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A. The columns that are queried in the select clause.

B. The columns with very high cardinality.

C. The columns with many different values.

D. The columns most actively used in the select filters.


Question No : 175) Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A. Bytes sent over network

B. Percentage scanned from cache

C. Partitions total

D. Bytes spilled to local storage

E. Partitions scanned


Question No : 176) What is the purpose of multi-cluster virtual warehouses?

A. To create separate data warehouses to increase query optimization

B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C. To eliminate or reduce Queuing of concurrent queries

D. To allow the warehouse to resize automatically


Question No : 177) Which of the following objects are contained within a schema? (Choose two.)

A. Role

B. Stream

C. Warehouse

D. External table

E. User

F. Share


Question No : 178) Which data type can store more than one type of data structure?

A. JSON

B. BINARY

C. VARCHAR

D. VARIANT


Question No : 179) Users are responsible for data storage costs until what occurs?

A. Data expires from Time Travel

B. Data expires from Fail-safe

C. Data is deleted from a table

D. Data is truncated from a table


Question No : 180) Which feature allows a user the ability to control the organization of data in a micropartition?

A. Range Partitioning

B. Search Optimization Service

C. Automatic Clustering

D. Horizontal Partitioning
 

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.