Transit wants analysts and Genie to interpret delay reason code enums correctly. What should stewards maintain on the ridership delay table?
Select an answer to reveal the explanation.
Short Explanation
Column descriptions are the transit codebook taped next to the delay field—Genie and analysts read the same plain-language meanings instead of guessing enums.
Full Explanation
Column definitions and descriptions that document delay reason code meanings are what transit stewards should maintain so analysts and Genie interpret ridership delay enums correctly. Governed comments turn opaque municipal codes into shared business language in Catalog Explorer and AI-assisted exploration, reducing misaggregation of delay categories.
Table constraints and checks that enforce delay reason code allowed values reject invalid entries to protect data quality—they say nothing about what any individual delay reason code actually means, so analysts and Genie are left guessing at enum values exactly as before. Column comments and tags that classify delay reason code sensitivity tiers label the governance or confidentiality tier; they do not attach any definition of what the codes mean, so even the analysts and Genie sessions that see the sensitivity label still have no stewarded description of what each code means. Column lineage details that trace delay reason code full upstream origins document where the values came from, not what the underlying delay reason enums mean—Genie can still misinterpret or mis-cite a raw code value if the column itself carries no definition, no matter how well the upstream origins are traced.
Exam caveat: Descriptions improve semantic clarity; they do not grant or deny SELECT, and they are not substitutes for certified gold metrics. Keep enum descriptions synchronized when the transit agency adds or retires delay codes so Genie does not cite stale meanings. Sensitivity classification remains separate if a column mixes operational codes with sensitive free text; it labels confidentiality tiers but does not define code meanings.
Operational check: Open the ridership delay table in Catalog Explorer, confirm the delay reason column has definitions that list code meanings, ask Genie or an analyst to explain a sample code and verify alignment with the stewarded description, and update comments when the official transit delay codebook changes.
Prefer to study offline? Printable PDF study book + test engine ($7.50, unofficial). These questions stay free here.