support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. COF-C02

Free COF-C02 Exam Braindumps
SnowPro Core Questions 216–220 (page: 45)

Updated On: 10-Feb-2026
Page 45 of 221
PDF with 1300 Questions

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

  1. Row access policies
  2. Data masking policies
  3. Data encryption
  4. Role based access control

Answer(s): B



A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

  1. view @my_stage
  2. list @my_stage
  3. show @my_stage
  4. display @my_stage

Answer(s): B



Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

  1. Management of metadata
  2. Computing the data
  3. Maintaining Availability Zones
  4. Infrastructure security
  5. Parsing and optimizing queries

Answer(s): A,E



What is true about sharing data in Snowflake? (Choose two.)

  1. The Data Consumer pays for data storage as well as for data computing.
  2. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
  3. A Snowflake account can both provide and consume shared data.
  4. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
  5. The Data Consumer pays only for compute resources to query the shared data.

Answer(s): C,E



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?

  1. select src:dealership from car_sales;
  2. select src.dealership from car_sales;
  3. select src:Dealership from car_sales;
  4. select dealership from car_sales;

Answer(s): A



  PDF
Viewing page 45 of 221
Viewing questions 221 - 225 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!