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