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

My

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

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

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

...