Answer-first summary for fast verification
Answer: All of the above
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'.
Author: LeetQuiz Editorial Team
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
SHOW CREATE TABLE transactions
B
DESCRIBE EXTENDED transactions
C
SHOW TABLE EXTENDED LIKE 'transactions'
D
DESCRIBE FORMATTED transactions
E
All of the above
No comments yet.