Question 830
A data governance team needs to trace reports to upstream ingestion flows. An auditor must prove the outcome of Inspect supported column-level lineage and associated policy metadata for this requirement: One column must be traced through a masked transformation into an aggregate. Which test result is best?
Explanation
Correct Answer
The provenance chain shows the input and governed output dependency directly measures whether Inspect supported column-level lineage and associated policy metadata achieved the requirement “One column must be traced through a masked transformation into an aggregate.” It checks the operating result rather than just a configured resource name.
Incorrect Answers
Lineage links the final view to its upstream source tables would demonstrate the separate action Inspect Unity Catalog column/table lineage for the view, which addresses “Auditors ask which source tables feed a final customer lifetime value view.” It does not verify the requirement “One column must be traced through a masked transformation into an aggregate” following Inspect supported column-level lineage and associated policy metadata.
The impact list includes dependent tables and reports pertains to a different control (Query or visualize downstream lineage from the source asset) and a different need (A raw ingestion table is being replaced and owners must identify impacted reports). It cannot establish that Inspect supported column-level lineage and associated policy metadata met the stated goal.
That observation is a valid indicator for “A compliance team asks who created a derived customer metric and when it was modified” when using Inspect UC object metadata and audit history as available. The scenario instead tests “One column must be traced through a masked transformation into an aggregate”; the relevant result is The provenance chain shows the input and governed output dependency.