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 17

Question No : 241) A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?

A. Use data encryption.

B. Use dynamic data masking.

C. Use secure materialized views.

D. Revoke all roles for functional managers and end users.


Question No : 242) Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE)

A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region


Question No : 243) What is the MINIMUM Snowflake edition required to use the periodic rekeying of micropartitions?

A. Enterprise

B. Business Critical

C. Standard

D. Virtual Private Snowflake


Question No : 244) Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A. Snowflake leverages a Role-Based Access Control (RBAC) model.

B. Snowflake requires a user to configure an IAM user to connect to the database.

C. All data in Snowflake is encrypted.

D. Snowflake can run within a user's own Virtual Private Cloud (VPC).

E. All data in Snowflake is compressed.


Question No : 245) The Snowflake Search Optimization Services supports improved performance of which kind of query?

A. Queries against large tables where frequent DML occurs

B. Queries against tables larger than 1 TB

C. Selective point lookup queries

D. Queries against a subset of columns in a table


Question No : 246) Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

A. SELECT SUM (ORDER_AMT) FROM SALES;

B. SELECT AVG(ORDER_QTY) FROM SALES;

C. SELECT MIN(ORDER_AMT) FROM SALES;

D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;


Question No : 247) What is cached during a query on a virtual warehouse?

A. All columns in a micro-partition

B. Any columns accessed during the query

C. The columns in the result set of the query

D. All rows accessed during the query


Question No : 248) The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

The following JSON is stored in a VARIANT column called src of the CAR_SALES table

 

A user needs to extract the dealership information from the JSON. How can this be accomplished?

A. select src:dealership from car_sales;

B. select src.dealership from car_sales;

C. select src:Dealership from car_sales;

D. select dealership from car_sales;


Question No : 249) Which formats does Snowflake store unstructured data in? (Choose two.)

A. GeoJSON

B. Array

C. XML

D. Object

E. BLOB


Question No : 250) Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

A. Schema

B. View

C. Internal stage

D. Table

E. User

F. Role


Question No : 251) Which Snowflake tool would be BEST to troubleshoot network connectivity?

A. SnowCLI

B. SnowUI

C. SnowSQL

D. SnowCD


Question No : 252) What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

A. Row level access policies

B. Data masking policies

C. Data encryption

D. Time Travel

E. External tokenization


Question No : 253) What is the minimum Snowflake edition that has column-level security enabled?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake


Question No : 254) The is the minimum Fail-safe retention time period for transient tables?

A. 1 day

B. 7 days

C. 12 hours

D. 0 days


Question No : 255) Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

A. CONTENT

B. PATH

C. BYTE_SIZE

D. INDEX

E. DATATYPE
 

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.