How to determine if a table is a managed table vs external table?

How to determine if a table is a managed table vs external table?
A . Run IS_MANAGED(‘table_name’) function
B . All external tables are stored in data lake, managed tables are stored in DELTA lake
C . All managed tables are stored in unity catalog
D . Run SQL command DESCRIBE EXTENDED table_name and check type
E . Run SQL command SHOW TABLES to see the type of the table

View Answer

Answer: D

Explanation:

The answer is Run SQL command DESCRIBE EXTENDED table_name and check type Example of External table

Graphical user

interface, text, application

Description automatically generated

Example of managed table

Graphical user

interface, text, application, Teams

Description automatically generated