Question 310
An enterprise runs an open lakehouse with sources in multiple formats. The team implements Capture file path, ingest timestamp and source system metadata in bronze. The goal was: A vendor requires durable raw provenance for every file used to build a curated table. Which observed result best verifies success?
Explanation
Correct Answer
The team used Capture file path, ingest timestamp and source system metadata in bronze to fulfill “A vendor requires durable raw provenance for every file used to build a curated table.” Observing Each curated record can be traced to its raw source record confirms the intended effect in the resulting workload.
Incorrect Answers
That observation is a valid indicator for “A downstream consumer needs fresh changes from an existing Delta table instead of complete copies” when using Enable and consume Delta Change Data Feed with supported version tracking. The scenario instead tests “A vendor requires durable raw provenance for every file used to build a curated table”; the relevant result is Each curated record can be traced to its raw source record.
The silver target contains one consistent key type and name would demonstrate the separate action Normalize the key field during bronze-to-silver ingestion, which addresses “Several operational feeds use differing column names for the same business key.” It does not verify the requirement “A vendor requires durable raw provenance for every file used to build a curated table” following Capture file path, ingest timestamp and source system metadata in bronze.
That observation is a valid indicator for “A new bronze pipeline requires transactionally consistent append-only event storage” when using Write ingested records into a Delta table with committed transactions. The scenario instead tests “A vendor requires durable raw provenance for every file used to build a curated table”; the relevant result is Each curated record can be traced to its raw source record.