Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Consider a scenario where you need to query a specific version of a Delta Lake table named 'historical_data' from six months ago. Describe the SQL command you would use to achieve this and explain why querying a specific version is important._
A
Use the SELECT * FROM historical_data command to query the latest version of the table.*_
B
Use the DESCRIBE HISTORY command to find the version, then use the SELECT * FROM historical_data VERSION AS OF command to query the specific version.*_
C
Use the RESTORE TABLE command to revert to the desired version and then query the table.
D
Use the VACUUM command to clean up the table and then query the desired version.