Snowflake
ADA-C01 · Question #81
ADA-C01 Question #81: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
Question
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? (Choose three.)
Options
- 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-
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.