Snowflake ADA-C01 Exam - Topic 3 Question 20 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 20
Topic #: 3

A data provider wants to share data from multiple databases with a data consumer account.

How can this be accomplished?

AThe data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

BThe data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

CThe data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

DThe data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

Show Suggested Answer

Suggested Answer: A

The MINS_TO_BYPASS_MFA property allows the account administrator to temporarily disable MFA for a user who has lost their phone or changed their phone number1. The user can log in without MFA for the specified number of minutes, and then re-enroll in MFA using their new phone1. This does not revoke their MFA enrollment, unlike the DISABLE_MFA property, which cancels their enrollment and requires them to re-enroll from scratch1. The other options are not valid ways to bypass MFA, as SnowSQL does support MFA authentication2, and there is no such URL parameter as /?mode=mfa_bypass&code= for Snowflake3

by Fallon at Aug 06, 2024, 04:35 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Selma

6 months ago

I agree with A, but C is interesting too!

upvoted 0 times

...

Twana

6 months ago

Wait, are we sure about the REFERENCE_USAGE privilege? Sounds off.

upvoted 0 times

...

Tamra

6 months ago

Definitely A, that's the standard approach.

upvoted 0 times

...

Bettina

7 months ago

I think C makes more sense for sharing across databases.

upvoted 0 times

...

Brett

7 months ago

Option A is correct, you need USAGE privilege.

upvoted 0 times

...

Miesha

7 months ago

I vaguely recall that the REFERENCE_USAGE privilege is important for sharing data across databases, so maybe B or C is correct?

upvoted 0 times

...

Azalee

7 months ago

I’m leaning towards D because it mentions granting privileges on the database where the secure view is created, but I could be mixing it up with another topic.

upvoted 0 times

...

Amber

7 months ago

I remember practicing a question similar to this, and I feel like the USAGE privilege was mentioned a lot. Could it be A?

upvoted 0 times

...

Rickie

8 months ago

I think the answer might be C, but I'm not entirely sure about the specifics of the REFERENCE_USAGE privilege.

upvoted 0 times

...

Natalie

8 months ago

I feel pretty confident about this one. The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view. That way, the data consumer account can access the data through the secure view. Option A is the correct answer.

upvoted 0 times

...

Katy

8 months ago

I'm not entirely sure about this one. The question mentions multiple databases, so I'm wondering if Option D might be the right choice, since it specifically mentions granting the REFERENCE_USAGE privilege on the database where the secure view is created. I'll need to think this through a bit more.

upvoted 0 times

...

Ligia

8 months ago

Okay, I've got this. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role that includes the objects from multiple databases. That way, the data consumer account can access the data through the secure view. Option C is the way to go.

upvoted 0 times

...

Carlee

8 months ago

Hmm, this is a tricky one. I'm a bit confused about the difference between USAGE and REFERENCE_USAGE privileges. I'll need to review the documentation to make sure I understand which one is the correct choice for this scenario.

upvoted 0 times

...

Lorean

8 months ago

I think the key here is creating a secure view and granting the appropriate privileges. Option A seems to be the most straightforward approach, but I'll need to double-check the exact syntax for granting the USAGE privilege.

upvoted 0 times

...

Virgie

8 months ago

I'm a little confused by this question. I'm not sure I fully understand the differences between all these protocols and how they relate to cloud computing. I'll have to review my notes and try to reason through this step-by-step.

upvoted 0 times

...

Micaela

8 months ago

I remember we calculated the sales volume contribution variance in class, but I'm a bit confused about how to apply the actual versus budgeted ratios here.

upvoted 0 times

...

Coral

1 year ago

Wait, so the data provider has to grant a privilege just to let the consumer access the data? Sounds like a lot of red tape if you ask me!

upvoted 0 times

...

Abel

1 year ago

I'm going with Option C. It's the only one that mentions including objects from multiple databases in a share, which seems to be the requirement.

upvoted 0 times

Cletus

11 months ago

User3: I agree, Option C seems like the best solution for the data provider to accomplish sharing data with a data consumer account.

upvoted 0 times

...

Felix

11 months ago

User2: That makes sense, it seems like the most appropriate choice for sharing data from multiple databases.

upvoted 0 times

...

Jonelle

11 months ago

User1: I think Option C is the way to go, it mentions including objects from multiple databases in a share.

upvoted 0 times

...

Katina

1 year ago

Hmm, I'm leaning towards Option D, but I'm not 100% confident. I hope the exam doesn't have too many questions like this one!

upvoted 0 times

Laurel

1 year ago

User 3: I'm not sure, but let's hope for the best during the exam.

upvoted 0 times

...

Laila

1 year ago

User 2: I agree, it seems like the most logical option.

upvoted 0 times

...

Arlene

1 year ago

User 1: I think Option D is the correct choice.

upvoted 0 times

...

Krystina

1 year ago

I'm not sure about the difference between USAGE and REFERENCE_USAGE privileges. This question is a bit tricky.

upvoted 0 times

...

Margo

1 year ago

Option C seems to be the correct answer. Granting the REFERENCE_USAGE privilege to a database role allows the data provider to include objects from multiple databases in a share.

upvoted 0 times

Margarett

1 year ago

Yes, granting the REFERENCE_USAGE privilege to a database role is the way to go.

upvoted 0 times

...

Frederica

1 year ago

I think option C is the best choice.

upvoted 0 times

...

My

1 year ago

I'm not sure, but I think D could also be a valid option. Granting the REFERENCE_USAGE privilege on the database where the secure view is created might simplify the process.

upvoted 0 times

...

Delfina

1 year ago

I disagree, I believe the answer is C. Granting the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share makes more sense to me.

upvoted 0 times

...

Crissy

1 year ago

I think the answer is A, because granting the USAGE privilege on each database referenced by the secure view seems like the most secure option.

upvoted 0 times

...