Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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)_