Question 350
During an analytics reporting escalation at Brightstone Legal, the data engineering team identifies a Databricks issue: A catalog's operational data must be queried across multiple engines with table-level metadata interoperability. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
Both authorized query engines return matching records from the selected supported table representation. The observation provides evidence that the proposed fix (Evaluate Delta or Iceberg compatibility and supported Unity Catalog table features against engine requirements.) addressed the reported issue (A catalog's operational data must be queried across multiple engines with table-level metadata interoperability.) for Brightstone Legal and its matter files and sensitive case records. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
A lifecycle test confirms the specified external files are retained or managed files are governed as documented. This is suitable evidence for another condition (A data owner expects managed and external tables to delete underlying files identically on DROP.) after a different response (Choose managed or external Unity Catalog tables by explicit storage-ownership and cleanup requirements.). For Brightstone Legal, it does not prove the required result: Both authorized query engines return matching records from the selected supported table representation.
The chosen optimization operation succeeds and the query plan shows the expected data skipping benefits. This is suitable evidence for another condition (A team wants to apply Z-order optimization automatically to a table already managed by liquid clustering without checking compatibility.) after a different response (Select a supported single clustering and optimization approach for the table's current features.). For Brightstone Legal, it does not prove the required result: Both authorized query engines return matching records from the selected supported table representation.
Two approved engines read the exported data with consistent types and values. This is suitable evidence for another condition (A third-party engine needs open columnar interoperability for a static dataset but a design mandates database-specific serialization for every export.) after a different response (Evaluate Parquet or compatible open table formats according to cross-engine requirements.). For Brightstone Legal, it does not prove the required result: Both authorized query engines return matching records from the selected supported table representation.