Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
A data engineer is trying to determine if the Delta table named 'transactions' is an external table or a managed table. Which command can be used to identify the table type?
A data engineer is trying to determine if the Delta table named 'transactions' is an external table or a managed table. Which command can be used to identify the table type?
Real Exam
Explanation:
All the provided options will display the 'Type' of the table, indicating whether it is an 'EXTERNAL' or a 'MANAGED' table. For more details on each option, you can refer to the following commands: SHOW CREATE TABLE, SHOW TABLE EXTENDED, and DESCRIBE TABLE (EXTENDED OR FORMATTED). Therefore, the correct answer is 'All of the above'.