Question 330
A review of the governed data platform at Westlake Retail documents this problem: A data owner expects managed and external tables to delete underlying files identically on DROP. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
A lifecycle test confirms the specified external files are retained or managed files are governed as documented. The observation provides evidence that the proposed fix (Choose managed or external Unity Catalog tables by explicit storage-ownership and cleanup requirements.) addressed the reported issue (A data owner expects managed and external tables to delete underlying files identically on DROP.) for Westlake Retail and its online commerce and inventory workflows. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
Both authorized query engines return matching records from the selected supported table representation. This is suitable evidence for another condition (A catalog's operational data must be queried across multiple engines with table-level metadata interoperability.) after a different response (Evaluate Delta or Iceberg compatibility and supported Unity Catalog table features against engine requirements.). For Westlake Retail, it does not prove the required result: A lifecycle test confirms the specified external files are retained or managed files are governed as documented.
A controlled MERGE update succeeds atomically and readers see a consistent resulting dataset. This is suitable evidence for another condition (A data platform stores frequently updated analytic facts as raw CSV files and cannot support reliable ACID upserts.) after a different response (Use Delta tables where transactional updates, schema enforcement, and reliable history are required.). For Westlake Retail, it does not prove the required result: A lifecycle test confirms the specified external files are retained or managed files are governed as documented.
A changed label replaces the prior value without creating unnecessary historical dimension rows. This is suitable evidence for another condition (A lookup attribute must always show the latest label and no historical label versions are needed.) after a different response (Choose an SCD Type 1 overwrite strategy for that specific attribute.). For Westlake Retail, it does not prove the required result: A lifecycle test confirms the specified external files are retained or managed files are governed as documented.