Ultimate access to all questions.
A job scheduled to run daily at 12:00 AM loads data into the orders
table, typically taking 30 minutes to complete. However, on a particular day, it failed after 5 minutes, leaving the table in an inconsistent state. A data engineer noticed the discrepancy between source and target counts the next morning at 8:00 AM and decided to restore the table to its state before the job ran and then re-run the job. Which SQL statement should the engineer use to restore the table?