Practice — DQ13-018–034
DQ13-018 — Dimensions & Rules · Foundational · Recall
Which example is most clearly an Integrity problem? - A. A customer's phone number has one digit too few. - B. An order contains a customer key that has no corresponding Customer parent record. - C. A feed arrives two hours late. - D. A customer appears twice with different customer IDs.
DQ13-019 — Dimensions & Rules · Standard · Recall
What does Timeliness primarily measure? - A. Whether the data still reflects current reality. - B. Whether duplicate entities have been merged. - C. Whether data is available within the time needed by the consuming process or user. - D. Whether a value belongs to its allowed domain.
DQ13-020 — Dimensions & Rules · Standard · Recall
What does Currency primarily measure? - A. Whether the data was delivered before a processing deadline. - B. Whether all mandatory fields are populated. - C. Whether relationships among records are valid. - D. Whether the data is sufficiently up to date for the business need, considering how quickly the underlying fact changes.
DQ13-021 — Dimensions & Rules · Standard · Understand
Which condition is best tested by Reasonableness? - A. Whether a value or aggregate falls within plausible expectations or a benchmark, even if it is syntactically valid. - B. Whether a key has a matching parent. - C. Whether a required field is null. - D. Whether two duplicate records represent the same entity.
DQ13-022 — Dimensions & Rules · Standard · Recall
Which question is primarily about Uniqueness/Deduplication? - A. Does the address exist in the real world? - B. Has the same real-world entity been recorded more than once under the identification logic? - C. Does the state code belong to the approved domain? - D. Did the file arrive before the SLA cutoff?
DQ13-023 — Dimensions & Rules · Standard · Recall
What does Accuracy mean in Chapter 13? - A. The degree to which data conforms to a specified format. - B. The percentage of mandatory fields populated. - C. The degree to which data correctly represents the real-life entity or event. - D. The elapsed time between creation and delivery.
DQ13-024 — Dimensions & Rules · Difficult · Distinguish
A customer email follows the approved email format but belongs to a different person. Which assessment is best? - A. The value is accurate because it passed the format rule. - B. The value is incomplete because it belongs to another person. - C. The value is untimely because ownership changed. - D. The value may be valid in format but inaccurate with respect to reality.
DQ13-025 — Dimensions & Rules · Difficult · Distinguish
A file containing today's correct balances arrives three hours after the required 8:00 a.m. cutoff. Which dimension is the clearest failure? - A. Timeliness. - B. Currency. - C. Accuracy. - D. Uniqueness.
DQ13-026 — Dimensions & Rules · Difficult · Distinguish
A feed arrives exactly on schedule, but its customer addresses were last refreshed two years ago and no longer meet the consumer's currentness requirement. Which dimension is primary? - A. Timeliness. - B. Currency. - C. Integrity. - D. Completeness.
DQ13-027 — Dimensions & Rules · Difficult · Distinguish
Every Order has a CUSTOMER_ID populated, but 4% of those IDs do not match any Customer record. Which dimension is the deciding failure? - A. Completeness. - B. Currency. - C. Integrity. - D. Reasonableness.
DQ13-028 — Dimensions & Rules · Difficult · Distinguish
Two records represent the same real customer under different IDs. Which dimension is primary? - A. Consistency. - B. Timeliness. - C. Validity. - D. Uniqueness/Deduplication.
DQ13-029 — Dimensions & Rules · Standard · Distinguish
Which statement best describes the relationship between Business Rules and Data Quality Rules? - A. Business Rules express how data should exist for successful/compliant operation; Data Quality Rules align those expectations with measurable DQ dimensions. - B. They are unrelated: Business Rules govern processes while DQ Rules only govern databases. - C. DQ Rules are tool-generated metrics and do not require business expectations. - D. Business Rules are always less specific than Data Quality Rules and cannot be measured.
DQ13-030 — Dimensions & Rules · Standard · Apply
A rule requires STATE_CODE to be one of the values in an approved reference table. What kind of rule is this primarily? - A. Completeness through record presence. - B. Validity through value-domain membership. - C. Accuracy verification against reality. - D. Timeliness through elapsed-time measurement.
DQ13-031 — Dimensions & Rules · Standard · Apply
A debt-manager field must be populated only when ACCOUNT_STATUS='Debt Risk' and must be blank otherwise. Which dimension is this rule primarily expressing? - A. Uniqueness. - B. Timeliness. - C. Completeness with conditional population requirements. - D. Accuracy.
DQ13-032 — Dimensions & Rules · Standard · Apply
A daily transaction-count rule flags values outside an expected benchmark range even though the count is a valid integer. Which dimension is primary? - A. Validity. - B. Integrity. - C. Completeness. - D. Reasonableness.
DQ13-033 — Dimensions & Rules · Standard · Apply
Which method most directly verifies Accuracy? - A. Compare the value with reality or a trusted corresponding source and confirm that it matches. - B. Check that the string has the correct length. - C. Check that the value appears in the approved domain. - D. Check that the field is populated.
DQ13-034 — Lifecycle & Activities · Standard · Understand
In the Data Quality improvement lifecycle, what belongs primarily in Plan? - A. Run recurring production scorecards only. - B. Assess the problem's scope, business impact, likely causes, and improvement options. - C. Implement the selected root-cause fix. - D. Perform routine correction of newly detected defects.