QUESTION: 101

Which of the following objects can be shared through secure data sharing?

Masking policy
Stored procedure
Task
External table

Answer(s): D

Explanation:

Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:

Tables External tables Secure views
Secure materialized views Secure UDFs

Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.

Reference:

https://docs.snowflake.com/en/user-guide/data-sharing- intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables

Reveal Solution Next Question

QUESTION: 102

Which of the following commands cannot be used within a reader account?

CREATE SHARE
ALTER WAREHOUSE
DROP ROLE
SHOW SCHEMAS
DESCRBE TABLE

Answer(s): B

Explanation:

A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

Reveal Solution Next Question

QUESTION: 103

A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

list @mytable;
list @%raytable;
list @ %m.ystage;
list @mystage;

Answer(s): D

Reveal Solution Next Question

QUESTION: 104

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure
Automatic encryption of all data
Up to 90 days of data recovery through Time Travel
Object-level access control
Column-level security to apply data masking policies to tables and views

Answer(s): B,D

Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 27)

QUESTION: 101

Explanation:

Reference:

QUESTION: 102

Explanation:

QUESTION: 103

QUESTION: 104

Reference:

COF-R02 Discussions & Posts