Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Describe the process of identifying the location of a table in Delta Lake. Include the necessary SQL command and explain how this information is useful for data management and troubleshooting.
A
Use the DESCRIBE DETAIL table_name command to find the location of a table, which is useful for managing data storage and troubleshooting issues related to data access or corruption._
B
The location of a table in Delta Lake cannot be identified using SQL commands, requiring manual file system navigation.
C
Use the SHOW CREATE TABLE table_name command to identify the table location, which is only useful for recreating the table schema._
D
Delta Lake automatically manages table locations, and there is no need to identify them for any purpose.