Home / DE Professional practice test / Cost & Performance Optimisation / Question

Databricks Data Engineer Professional · free practice question

A solutions architect is evaluating whether to register new production Delta Lake tables as Unity Catalog managed tables or external tables. The architect…

Exam-style question on Cost & Performance Optimisation from the free DE Professional practice test, with the answer and a full explanation below.

Updated November 16, 2026

Cost & Performance Optimisation Medium

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?

  1. APredictive optimization, automatic liquid clustering, metadata caching, and automatic file deletion 8 days after DROP TABLE, which external tables lack.
  2. BACID transactions, time travel, schema enforcement, and Delta format support, which Unity Catalog provides for managed tables but not external ones.
  3. CDelta Sharing, Iceberg REST Catalog access, credential vending, and column-level lineage tracking, which require the table to be registered as managed.
  4. DPredictive optimization, metadata caching, and file deletion after DROP TABLE; automatic liquid clustering also covers external tables with a LOCATION.
  5. EUnity Catalog access controls, row filters, column masks, and centralized auditing, which do not apply to tables registered as external tables.
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.

Take the full DE Professional practice test free →

Would you pass today?

This question is one of 60 in the free, timed Databricks Data Engineer Professional practice test. Take it and get a section-by-section score.

Start the free test →