ADA-C02: SnowPro Advanced — Administrator

By Snowflake · Question Mode

QuestionQ53

VerifiedManage and administer Snowflake accounts, data security, and governance

MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries allow the user to view the historical data that was in the table before this query ran?

Choose three
Explanation

Snowflake Time Travel supports AT(TIMESTAMP => ...) for a specified historical time, AT(OFFSET => ...) for a number of seconds before the current time, and BEFORE(STATEMENT => ...) for the table state immediately before the identified statement completed. A timestamp of 07:00 and an offset of 30 minutes from 07:30 both precede the 07:01 update.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!