Courts require both case_number and filing_date to be non-null before a row may enter gold calendars. What should the quality gate enforce?
Select an answer to reveal the explanation.
Short Explanation
A court calendar without a case number or filing date is like a hearing slip with the room blank—both fields have to be filled before it goes on the board.
Full Explanation
Multi-field required validations protect municipal gold publishes when several attributes are jointly mandatory. Court calendars that need both case_number and filing_date must enforce both as non-null before a row enters gold; either field alone is insufficient for scheduling, notices, or audit. Combining required-field checks in the quality gate ensures incomplete filings are stopped or quarantined while complete rows publish to the calendar consumers.
Combining format validations so both case_number and filing_date must be non-null before gold calendar publish uses the wrong check type: format checks pattern, not presence, so nulls can slip through while a calendar entry without a filing date cannot be ordered or SLA-tracked and without a case_number cannot support notices or audit. Combining uniqueness validations so both case_number and filing_date must be non-null before gold calendar publish mistakes completeness for distinctness: uniqueness checks do not prove presence, and filing_date values legitimately repeat across cases so valid calendars would be blocked while nulls could still slip through. Separating required-field validations so both case_number and filing_date must be non-null before gold calendar publish fails the joint-gate requirement: isolated checks evaluate each field alone instead of enforcing both together as a single publish decision, so incomplete filings are not reliably stopped or quarantined before gold calendar publish.
Exam caveat: required-field gates at gold do not replace earlier bronze landing of imperfect extracts—teams often land raw rows then enforce completeness at silver/gold. Operational check: publish test rows missing case_number, missing filing_date, and missing both; confirm none reach gold calendars; publish a complete row and verify it appears; review expectation metrics for the combined required-field rule after each court load.
Prefer to study offline? Printable PDF study book + test engine ($7.50, unofficial). These questions stay free here.