Snowflake Exam ADA-C01 Topic 1 Question 19 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 19
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?

ALocation : AWS_WEST
Command : REFRESH DATABASE PROD_AWS WEST REFRESH;

BLocation : AWS_WEST
Command : ALTER DATABASE PROD AWS WEST REFRESH;

CLocation : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

DLocation : AWS EAST
Command: ALTER DATABASE PROD_AWS_WEST REFRESH;

Show Suggested 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.

by Ming at Jul 18, 2024, 04:11 PM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Justa

1 months ago

This question is like a geography quiz, but with databases instead of maps. I'm going to use my best guess and choose option A.

upvoted 0 times

Therese

4 days ago

User 2: That sounds right. Let's go with option A.

upvoted 0 times

...

Caren

5 days ago

User 1: I think the command is REFRESH DATABASE PROD_AWS WEST REFRESH; and the location is AWS_WEST.

upvoted 0 times

...

Anjelica

1 months ago

Wait, are we refreshing the West or the East? I'm so confused, I think I'll just go with option C and hope for the best.

upvoted 0 times

...

Veronika

1 months ago

Haha, this question is like a game of 'Guess Which Region'! I'm going to go with option B just to be different.

upvoted 0 times

...

Maile

2 months ago

Hmm, I'm not sure about that. I was thinking option D might be the right answer since the priRoxanne database object is PROD_AWS_EAST, which is located in AWS_EAST.

upvoted 0 times

Gilberto

13 days ago

User3: Yes, option D is the right choice for refreshing the data between AWS regions.

upvoted 0 times

...

Kina

14 days ago

User2: I agree, the command should be ALTER DATABASE PROD_AWS_WEST REFRESH.

upvoted 0 times

...

Benton

16 days ago

User1: I think option D is correct because the primary database is in AWS_EAST.

upvoted 0 times

...

Roxanne

2 months ago

I think option A is the correct choice. The secondary database object is PROD_AWS_WEST, which is located in AWS_WEST, so the command and location should match that.

upvoted 0 times

...