Snowflake Exam ADA-C01 Topic 1 Question 16 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 16
Topic #: 1

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is

'8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).

ASELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);

BSELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);

CSELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);

DSELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

ESELECT * FROM my_table AT (OFFSET => -60*30);

FSELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

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 Elenor at Jun 20, 2024, 06:11 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gilberto

1 months ago

Options A and E both mention 'OFFSET', but I'm not sure if they're doing the same thing. I'll have to experiment and see which one gives me the data I need.

upvoted 0 times

Flo

4 days ago

A) SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);

upvoted 0 times

...

2 months ago

Haha, 'TIME_TRAVEL'? Sounds like something out of a sci-fi movie. I'll give it a shot and see if it works!

upvoted 0 times

Whitley

1 months ago

User2: Yeah, that sounds like it could show the historical data before the query was executed.

upvoted 0 times

...

Howard

1 months ago

User1: I think option A might work, it mentions TIME_TRAVEL with an offset.

upvoted 0 times

...

Jospeh

2 months ago

I agree with Tyra. Those options seem to be the most relevant for viewing historical data.

upvoted 0 times

...

2 months ago

I think options A, B, and F are correct.

upvoted 0 times

...