A pipeline produces a table that several reporting teams consume. What should accompany the table so consumers can use it correctly?
Select an answer to reveal the explanation.
Short Explanation
Consumers need documented column meanings, the refresh schedule and freshness expectation, and lineage back to source systems. Miss the freshness statement in particular and someone will build a real-time dashboard on a table that updates at 3 a.m.
Full Explanation
A published table should be accompanied by documented column meanings, the refresh schedule and freshness expectation, and lineage back to source systems. Documentation makes a published table usable. Column definitions remove ambiguity about what a figure represents, the refresh schedule and freshness expectation tell consumers how current the data is and prevent misuse in near-real-time contexts, and lineage lets anyone trace a value back to its origin when it is questioned. Pasting the full SQL of the transformation into the table description field is incorrect because raw SQL is an implementation artefact. It documents how the table is built rather than what its columns mean, and it goes out of date silently. A note stating which analyst to contact, since questions can be handled individually, is incorrect because routing every question to one person creates a bottleneck and leaves the answers unrecorded. Saying nothing because self-describing column names are sufficient for a governed table is incorrect because column names carry no units, no grain and no filtering rules. A column called revenue does not say whether it is net or gross, or in what currency. For the exam, associate a published table with documentation, freshness and lineage.