A solutions architect is evaluating whether to register new production Delta Lake tables as Unity Catalog managed tables or external tables. The architect wants to take full advantage of platform-managed performance optimizations and operational simplifications. Which combination of features is EXCLUSIVELY available to Unity Catalog managed tables and NOT available for external tables?
Show answer & explanation
Correct answer: A
WHY A: The Databricks documentation lists features unique to Unity Catalog managed tables: (1) Predictive optimization, which automatically runs OPTIMIZE, VACUUM, and ANALYZE; these must be manually scheduled for external tables. (2) Automatic liquid clustering, which selects clustering keys based on workload patterns and is enabled via predictive optimization; not available for external tables. (3) Metadata caching, in-memory caching of Delta transaction metadata to reduce cloud storage requests; always enabled for managed tables. (4) Automatic file deletion after DROP TABLE: managed tables delete the underlying cloud storage files after 8 days, while external tables require manual storage cleanup. WHY NOT B: ACID transactions, time travel, and schema enforcement are Delta Lake features available to both managed and external Delta tables; they are not exclusive to managed tables. WHY NOT C: Delta Sharing and credential vending work with both managed and external tables through Unity Catalog; they do not require managed registration. WHY NOT D: Automatic liquid clustering (with predictive optimization) is exclusive to managed tables; external tables cannot benefit from automatic clustering key selection. WHY NOT E: Unity Catalog access controls, row/column security, and auditing apply to every table registered in Unity Catalog, including external tables.