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

Katina

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

...

Krystina

3 days ago

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

upvoted 0 times

...

1 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

...