ExamGecko
Home / Snowflake / COF-R02
Ask Question

Snowflake COF-R02 Practice Test - Questions Answers, Page 24

Question list
Search

Question 231

Report
Export
Collapse

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Amazon Web Services
Amazon Web Services
Docker
Docker
IBM Cloud
IBM Cloud
Microsoft Azure Cloud
Microsoft Azure Cloud
Google Cloud Platform
Google Cloud Platform
Oracle Cloud
Oracle Cloud
Suggested answer: B, D, E
asked 23/09/2024
Unai M
39 questions

Question 232

Report
Export
Collapse

In the Snowflake access control model, which entity owns an object by default?

The user who created the object
The user who created the object
The SYSADMIN role
The SYSADMIN role
Ownership depends on the type of object
Ownership depends on the type of object
The role used to create the object
The role used to create the object
Suggested answer: D
asked 23/09/2024
Vitalii Kucher
30 questions

Question 233

Report
Export
Collapse

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake (VPC)
Virtual Private Snowflake (VPC)
Suggested answer: D
asked 23/09/2024
lakshmi govindu
43 questions

Question 234

Report
Export
Collapse

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Compute resources
Compute resources
Query execution
Query execution
Authentication
Authentication
Data storage
Data storage
Metadata
Metadata
Suggested answer: C, E
asked 23/09/2024
Andre Passos
35 questions

Question 235

Report
Export
Collapse

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?

Row access policies
Row access policies
Data masking policies
Data masking policies
Data encryption
Data encryption
Role based access control
Role based access control
Suggested answer: B
asked 23/09/2024
Zaccheri Brown
34 questions

Question 236

Report
Export
Collapse

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?

view @my_stage
view @my_stage
list @my_stage
list @my_stage
show @my_stage
show @my_stage
display @my_stage
display @my_stage
Suggested answer: B
asked 23/09/2024
Andrey Markov
33 questions

Question 237

Report
Export
Collapse

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

Management of metadata
Management of metadata
Computing the data
Computing the data
Maintaining Availability Zones
Maintaining Availability Zones
Infrastructure security
Infrastructure security
Parsing and optimizing queries
Parsing and optimizing queries
Suggested answer: A, E
asked 23/09/2024
Norman Camacho
47 questions

Question 238

Report
Export
Collapse

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

The Data Consumer pays for data storage as well as for data computing.
The Data Consumer pays for data storage as well as for data computing.
The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
A Snowflake account can both provide and consume shared data.
A Snowflake account can both provide and consume shared data.
The Provider is charged for compute resources used by the Data Consumer to query the shared data.
The Provider is charged for compute resources used by the Data Consumer to query the shared data.
The Data Consumer pays only for compute resources to query the shared data.
The Data Consumer pays only for compute resources to query the shared data.
Suggested answer: B, C
asked 23/09/2024
Khang Nguyen An
30 questions

Question 239

Report
Export
Collapse

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

Snowflake COF-R02 image Question 239 74075 09232024004436000000

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

select src:dealership from car_sales;
select src:dealership from car_sales;
select src.dealership from car_sales;
select src.dealership from car_sales;
select src:Dealership from car_sales;
select src:Dealership from car_sales;
select dealership from car_sales;
select dealership from car_sales;
Suggested answer: A
asked 23/09/2024
Oliver Buss
29 questions

Question 240

Report
Export
Collapse

Which of the following significantly improves the performance of selective point lookup queries on a table?

Clustering
Clustering
Materialized Views
Materialized Views
Zero-copy Cloning
Zero-copy Cloning
Search Optimization Service
Search Optimization Service
Suggested answer: A
asked 23/09/2024
Vageesh Shanmukha
48 questions
Total 330 questions
Go to page: of 33