ExamGecko
Home Home / Snowflake / COF-R02

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

Question list
Search
Search

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

A.
Amazon Web Services
A.
Amazon Web Services
Answers
B.
Docker
B.
Docker
Answers
C.
IBM Cloud
C.
IBM Cloud
Answers
D.
Microsoft Azure Cloud
D.
Microsoft Azure Cloud
Answers
E.
Google Cloud Platform
E.
Google Cloud Platform
Answers
F.
Oracle Cloud
F.
Oracle Cloud
Answers
Suggested answer: B, D, E

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

A.
The user who created the object
A.
The user who created the object
Answers
B.
The SYSADMIN role
B.
The SYSADMIN role
Answers
C.
Ownership depends on the type of object
C.
Ownership depends on the type of object
Answers
D.
The role used to create the object
D.
The role used to create the object
Answers
Suggested answer: D

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

A.
Standard
A.
Standard
Answers
B.
Enterprise
B.
Enterprise
Answers
C.
Business Critical
C.
Business Critical
Answers
D.
Virtual Private Snowflake (VPC)
D.
Virtual Private Snowflake (VPC)
Answers
Suggested answer: D

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

A.
Compute resources
A.
Compute resources
Answers
B.
Query execution
B.
Query execution
Answers
C.
Authentication
C.
Authentication
Answers
D.
Data storage
D.
Data storage
Answers
E.
Metadata
E.
Metadata
Answers
Suggested answer: C, E

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?

A.
Row access policies
A.
Row access policies
Answers
B.
Data masking policies
B.
Data masking policies
Answers
C.
Data encryption
C.
Data encryption
Answers
D.
Role based access control
D.
Role based access control
Answers
Suggested answer: 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?

A.
view @my_stage
A.
view @my_stage
Answers
B.
list @my_stage
B.
list @my_stage
Answers
C.
show @my_stage
C.
show @my_stage
Answers
D.
display @my_stage
D.
display @my_stage
Answers
Suggested answer: B

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

A.
Management of metadata
A.
Management of metadata
Answers
B.
Computing the data
B.
Computing the data
Answers
C.
Maintaining Availability Zones
C.
Maintaining Availability Zones
Answers
D.
Infrastructure security
D.
Infrastructure security
Answers
E.
Parsing and optimizing queries
E.
Parsing and optimizing queries
Answers
Suggested answer: A, E

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

A.
The Data Consumer pays for data storage as well as for data computing.
A.
The Data Consumer pays for data storage as well as for data computing.
Answers
B.
The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
B.
The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
Answers
C.
A Snowflake account can both provide and consume shared data.
C.
A Snowflake account can both provide and consume shared data.
Answers
D.
The Provider is charged for compute resources used by the Data Consumer to query the shared data.
D.
The Provider is charged for compute resources used by the Data Consumer to query the shared data.
Answers
E.
The Data Consumer pays only for compute resources to query the shared data.
E.
The Data Consumer pays only for compute resources to query the shared data.
Answers
Suggested answer: B, C

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;
A.
select src:dealership from car_sales;
Answers
B.
select src.dealership from car_sales;
B.
select src.dealership from car_sales;
Answers
C.
select src:Dealership from car_sales;
C.
select src:Dealership from car_sales;
Answers
D.
select dealership from car_sales;
D.
select dealership from car_sales;
Answers
Suggested answer: A

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

A.
Clustering
A.
Clustering
Answers
B.
Materialized Views
B.
Materialized Views
Answers
C.
Zero-copy Cloning
C.
Zero-copy Cloning
Answers
D.
Search Optimization Service
D.
Search Optimization Service
Answers
Suggested answer: A
Total 330 questions
Go to page: of 33