Question 170
The team has a bad MERGE statement ID and needs to inspect data from immediately before it executed. Which option applies?
Explanation
Correct Answer
Correct: the BEFORE STATEMENT selector. SELECT ... BEFORE (STATEMENT => ...) queries the state immediately preceding a specified statement.
Incorrect Answers
Not correct for this case: SELECT ... AT (TIMESTAMP => ...) queries an eligible table's historical state at a timestamp; the scenario specifically needs the BEFORE STATEMENT selector.
Not correct for this case: UNDROP TABLE restores a recently dropped eligible table; the scenario specifically needs the BEFORE STATEMENT selector.
Not correct for this case: CREATE TABLE ... CLONE ... AT creates a separate table cloned from an eligible historical point; the scenario specifically needs the BEFORE STATEMENT selector.