Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ADA-C01 Topic 1 Question 19 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 19
Topic #: 1
[All ADA-C01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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.


Contribute your Thoughts:

Shannan
2 days ago
I'm not sure, but I think option C might also be correct because it mentions refreshing the data in PROD_AWS_WEST which is the secondary database.
upvoted 0 times
...
Elise
4 days ago
I agree with Ronnie, option A seems to be the right choice because the secondary database is located in AWS_WEST.
upvoted 0 times
...
Ronnie
6 days ago
I think the correct command is A) Location : AWS_WEST Command : REFRESH DATABASE PROD_AWS WEST REFRESH;
upvoted 0 times
...

Save Cancel