Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You've discovered that a process inadvertently updated a table, and you need to query yesterday's version of the data for analysis. What is the most effective method to access historical data for this purpose?
A
SELECT * FROM TIME_TRAVEL(table_name) WHERE time_stamp = ‘timestamp‘
B
TIME_TRAVEL FROM table_name WHERE time_stamp = date_sub(current_date(), 1)
C
SELECT * FROM table_name TIMESTAMP AS OF date_sub(current_date(), 1)
D
DISCRIBE HISTORY table_name AS OF date_sub(current_date(), 1)
E
SHOW HISTORY table_name AS OF date_sub(current_date(), 1)
