Databricks Data Engineer Associate Question 275
Single answerYou are working with a Delta table in Databricks and need to review the history of transactions performed on the table to debug a recent issue. Which command should you use to retrieve this information?
- A
DESCRIBE HISTORY table_name
- B
SHOW HISTORY table_name
- C
DESCRIBE EXTENDED table_name
- D
SELECT * FROM delta.
/path/to/tableLIMIT 10
Show answer and explanation
Correct answer: A
Explanation
To review the history of transactions on a Delta table, you should use the 'DESCRIBE HISTORY' command in Databricks. This command allows users to see details about past operations such as data writes, schema changes, and more. Other commands like 'DESCRIBE EXTENDED' or 'SELECT' do not provide this level of transaction history.
- A. Correct.
This is the correct command to retrieve the history of transactions for a Delta table in Databricks. It provides detailed information about operations performed on the table, such as writes, updates, and schema changes.
- B. Incorrect.
This is not a valid Databricks command to review the history of table transactions. 'SHOW HISTORY' is not a recognized command in this context.
- C. Incorrect.
The 'DESCRIBE EXTENDED' command provides metadata information about a table, such as schema and properties, but it does not show the history of transactions.
- D. Incorrect.
This command retrieves a sample of rows from the Delta table but does not provide any transaction history or metadata.