Free Preparation Discussions
MENU
Snowflake Exam ADA-C01 Topic 1 Question 19 Discussion
Topic #: 1
A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?
A masking policy is a SQL expression that transforms the data in a column based on the role that queries the column1. The is_role_in_session function returns true if the specified role is in the current session2. Therefore, the masking policy in option A will mask the column data with asterisks whenever it is queried through a view owned by the MASKED_VIEW_ROLE3. The other options use different functions that do not check the ownership of the view, but rather the current role, the invoker role, or the available roles in the session45. These functions may not return the desired result if the role that owns the view is different from the role that queries the view.
Justa
16 days agoAnjelica
18 days agoVeronika
20 days agoMaile
1 months agoBenton
1 days agoRoxanne
1 months agoShannan
2 months agoElise
2 months agoRonnie
2 months ago