Snowflake ADA-C01 Exam - 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

Rickie

4 months ago

REFRESH DATABASE PROD_AWS_WEST REFRESH? Really? That’s a weird command!

upvoted 0 times

...

Loreen

5 months ago

I’m not sure about the command syntax in option B, looks off.

upvoted 0 times

...

Elenora

5 months ago

Wait, why would you refresh from AWS_EAST? That doesn't make sense.

upvoted 0 times

...

Nikita

5 months ago

I think option A is correct, sounds right to me!

upvoted 0 times

...

Kate

5 months ago

The secondary database is in AWS_WEST, so we need to refresh from there.

upvoted 0 times

...

Glory

6 months ago

I recall that the command needs to be executed in the location of the secondary database, which is AWS_WEST. I hope I got that right!

upvoted 0 times

...

Catarina

6 months ago

I’m a bit confused about whether to use ALTER DATABASE or REFRESH DATABASE. I think I leaned towards REFRESH in my studies.

upvoted 0 times

...

Darell

6 months ago

I remember practicing a similar question where we had to specify the correct location for the secondary database. I feel like it should be AWS_WEST.

upvoted 0 times

...

Karrie

6 months ago

I think the command should be something like REFRESH DATABASE, but I'm not sure about the exact syntax.

upvoted 0 times

...

Garry

6 months ago

This looks straightforward enough. The key is to identify the primary and secondary databases and their locations, then select the appropriate command and location to refresh the data. I'm feeling confident about this one.

upvoted 0 times

...

Nickie

6 months ago

I'm not entirely sure about this one. The options seem a bit tricky, and I want to make sure I don't miss any important details. I'll review the question carefully and try to eliminate the incorrect answers before making my final selection.

upvoted 0 times

...

Brock

6 months ago

Okay, I think I've got this. The primary database is PROD_AWS_EAST in the AWS_EAST location, and the secondary is PROD_AWS_WEST in the AWS_WEST location. So the correct answer should be to run the refresh command from the AWS_WEST location.

upvoted 0 times

...

Hailey

6 months ago

This seems like a straightforward database replication question. I'll need to carefully read through the details and options to determine the correct command and location.

upvoted 0 times

...

Ardella

6 months ago

Hmm, I'm a bit confused by the wording of the question. I'll need to double-check the database object names and locations to make sure I understand which one is the primary and which is the secondary.

upvoted 0 times

...

Eura

6 months ago

Aha, I remember now - the Development Team composition is meant to be stable throughout the Sprint. This is a core Scrum principle. I'll select the right answer.

upvoted 0 times

...

Justa

11 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

Alyssa

9 months ago

Therese: Great, let's go ahead and refresh the data with that command and location.

upvoted 0 times

...

Eleonore

9 months ago

User 3: I agree, option A seems to be the correct choice.

upvoted 0 times

...

Therese

10 months ago

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

upvoted 0 times

...

Caren

10 months ago

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

upvoted 0 times

...

Anjelica

11 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

11 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

Son

10 months ago

I agree with option B, it sounds like the right choice.

upvoted 0 times

...

Pansy

10 months ago

I'm going with option C, it seems more logical to me.

upvoted 0 times

...

Maddie

10 months ago

I think option B is the correct one.

upvoted 0 times

...

Maile

11 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

10 months ago

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

upvoted 0 times

...

Kina

10 months ago

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

upvoted 0 times

...

Benton

10 months ago

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

upvoted 0 times

...

Roxanne

12 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

...