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

Dortha

6 months ago

I disagree, I don't think C works here.

upvoted 0 times

...

Caitlin

6 months ago

Definitely B and F for sure!

upvoted 0 times

...

Mariann

6 months ago

Wait, can you really use OFFSET like that? Seems off.

upvoted 0 times

...

Queenie

7 months ago

I think D is also a valid option!

upvoted 0 times

...

Stephaine

7 months ago

A and B look solid for historical data.

upvoted 0 times

...

Ricarda

7 months ago

I feel like option A could work too, but I'm a bit confused about the OFFSET syntax. Did we cover that in class?

upvoted 0 times

...

Brandon

7 months ago

I remember practicing a question similar to this, and I think option F might also be correct since it mentions retrieving data before a specific statement.

upvoted 0 times

...

Coral

7 months ago

I'm not too sure about option D; it sounds familiar, but I can't recall if it actually retrieves data prior to a specific statement.

upvoted 0 times

...

Skye

8 months ago

I think option B is definitely one of the correct answers since it specifies a timestamp right before the update.

upvoted 0 times

...

Crissy

8 months ago

This is a good test of my SQL knowledge. I'm feeling confident I can figure this out, but I'll take my time and make sure I select the right three options.

upvoted 0 times

...

Viva

8 months ago

I've got a strategy - I'll start by eliminating the options that don't seem to match the criteria, then focus on the remaining ones to determine the best solution.

upvoted 0 times

...

Jolene

8 months ago

Okay, let's see. I think options B and D seem the most promising based on the information provided. I'll make sure to double-check the syntax for those.

upvoted 0 times

...

Lenna

8 months ago

Hmm, this looks like a tricky one. I'll need to carefully read through the options and think about the time travel capabilities of the database.

upvoted 0 times

...

Dominque

8 months ago

I'm a bit confused by the different time travel functions here. I'll need to review the documentation to make sure I understand the differences between them.

upvoted 0 times

...

Remedios

8 months ago

Hmm, I'm not totally sure about this one. I know it's related to risk, but I'm a bit confused about the difference between the options. Let me think this through carefully.

upvoted 0 times

...

Cathrine

8 months ago

Okay, let me see if I can break this down. The variable varInput is a String, so I'll need to consider how String operations might affect the output.

upvoted 0 times

...

Gilberto

1 year 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