ARA-C01 · Question #81
A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish: What would be the output of this query?
The correct answer is A. Table T_SALES_CLONE successfully created. Snowflake's Time Travel allows cloning a table at a point in the past using the AT or BEFORE clause with an OFFSET. Since the commands are executed sequentially within a 10-minute window, and Snowflake's default Time Travel retention is 1 day (or at minimum the configured…
Question
A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish:
What would be the output of this query?
Exhibit
Options
- ATable T_SALES_CLONE successfully created.
- BTime Travel data is not available for table T_SALES.
- CThe offset -> is not a valid clause in the clone operation.
- DSyntax error line 1 at position 58 unexpected 'at'.
How the community answered
(41 responses)- A95% (39)
- C2% (1)
- D2% (1)
Explanation
Snowflake's Time Travel allows cloning a table at a point in the past using the AT or BEFORE clause with an OFFSET. Since the commands are executed sequentially within a 10-minute window, and Snowflake's default Time Travel retention is 1 day (or at minimum the configured retention period, which covers 10 minutes easily), the data is available for cloning. The clone operation with a valid time offset completes successfully, producing the message 'Table T_SALES_CLONE successfully created.' Option B would only occur if the offset exceeded the retention period. Options C and D suggest syntax errors that don't apply to valid Snowflake clone syntax using AT(OFFSET => ...).
Topics
Community Discussion
No community discussion yet for this question.