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

Coral

20 days 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

21 days 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

...

2 months 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 months ago

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

upvoted 0 times

...

Frederica

1 months ago

I think option C is the best choice.

upvoted 0 times

...

My

2 months 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

2 months 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

2 months 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

...