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
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
Latest Databricks Certified Data Engineer Professional Dumps Valid Version with 278 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund