Question 230A manufacturer discards thousands of supplier records when a mandatory field is blank instead of assessing business impact. A reviewer proposes: Classify quality exceptions by severity and route them through proportionate remediation workflows. Which data-management principle best supports that choice? Data-quality measurement only helps when linked to accountable decisions and corrective action Quality tolerances should reflect consequences and fitness for business purpose Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally Aggregate quality scores can hide concentrated risks that matter to specific controls ExplanationCorrect Answer C:Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. This is why the recommended action fits the given facts: A manufacturer discards thousands of supplier records when a mandatory field is blank instead of assessing business impact. Verification would show: Exception queues preserve recoverable records and prioritize defects affecting purchase orders.Incorrect Answers A:Data-quality measurement only helps when linked to accountable decisions and corrective action. This does not establish the proposed intervention. The governing principle here is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. Apply it by: Classify quality exceptions by severity and route them through proportionate remediation workflows. B:Quality tolerances should reflect consequences and fitness for business purpose. This does not establish the proposed intervention. The governing principle here is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. Apply it by: Classify quality exceptions by severity and route them through proportionate remediation workflows. D:Aggregate quality scores can hide concentrated risks that matter to specific controls. This does not establish the proposed intervention. The governing principle here is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. Apply it by: Classify quality exceptions by severity and route them through proportionate remediation workflows.
Question 231A distributor reports a perfect address completeness score although many stored addresses refer to demolished facilities. After the proposed change—Verify address accuracy against reliable external evidence and business confirmation—which observation best verifies that this specific weakness has been addressed? Source-specific completeness rates expose the failing partner and improve after remediation Daily checks detect missing claim attributes before approval cutoffs Sampled addresses are confirmed against current trusted records and correction histories A reviewed set of identity candidates has controlled merges and falling duplicate rates ExplanationCorrect Answer C:Sampled addresses are confirmed against current trusted records and correction histories. This is specific evidence for the intervention: Verify address accuracy against reliable external evidence and business confirmation. The underlying principle is: Completeness measures presence while accuracy measures correspondence to real-world facts.Incorrect Answers A:Completeness describes the presence of required data, not its correctness or timely arrival. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sampled addresses are confirmed against current trusted records and correction histories. B:Quality monitoring frequency should reflect when an issue can cause material harm. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sampled addresses are confirmed against current trusted records and correction histories. D:Uniqueness evaluates whether real-world entities or records are represented without unacceptable duplication. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sampled addresses are confirmed against current trusted records and correction histories.
Question 232An insurer publishes executive dashboards without reconciling warehouse claim payments to the general ledger. If this weakness continues, what is the most directly associated business or data risk? A growing analytical workload may become too slow or costly for business use Operational credit decisions may rely on material outdated information Analytical metrics may include repeated events and overcount sales Leadership may rely on financially inconsistent analytics ExplanationCorrect Answer D:Leadership may rely on financially inconsistent analytics. This follows from the unresolved case facts. The preventive intervention is: Add finance-approved control totals, reconciliation thresholds, and ownership to the warehouse pipeline. The reason is: Analytical trust requires evidence that transformed facts reconcile to authoritative business systems.Incorrect Answers A:Warehouse performance depends on physical design matched to analytical workload and query patterns. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Leadership may rely on financially inconsistent analytics. B:A warehouse optimized for periodic reporting may not satisfy operational real-time use cases. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Leadership may rely on financially inconsistent analytics. C:Warehouse ETL or ELT processes should validate inputs before declaring data fit for analysis. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Leadership may rely on financially inconsistent analytics.
Question 233A university runs disconnected governance, quality, and modeling projects without a shared roadmap or prioritization process. After the proposed change—Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities—which observation best verifies that this specific weakness has been addressed? A documented operating plan links visit definitions, accountable teams, quality measures, and clinical report acceptance tests A single portfolio shows linked deliverables, owners, dependencies, milestone acceptance, and resources Approved use cases and baseline measures show how catalog adoption improves specific production decisions Council decisions identify an accountable owner, binding resolution, and implementation deadline ExplanationCorrect Answer B:A single portfolio shows linked deliverables, owners, dependencies, milestone acceptance, and resources. This is specific evidence for the intervention: Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities. The underlying principle is: Related data-management disciplines need an integrated operating plan so their outputs reinforce one another.Incorrect Answers A:Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A single portfolio shows linked deliverables, owners, dependencies, milestone acceptance, and resources. C:Business-driven data management establishes requirements and success measures before selecting supporting technology. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A single portfolio shows linked deliverables, owners, dependencies, milestone acceptance, and resources. D:Data governance is the exercise of authority and control over data-management decisions rather than a committee title alone. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A single portfolio shows linked deliverables, owners, dependencies, milestone acceptance, and resources.
Question 234An analytics engineer uses a star schema's fact table as the canonical operational system for editing customer addresses. If this weakness continues, what is the most directly associated business or data risk? Reports and customer service may diverge when the warehouse is edited directly Repeated values can diverge and corrupt the interpretation of old shipments Item-level updates and reconciliation may become error-prone Billing may apply an obsolete or contradictory subscription plan ExplanationCorrect Answer A:Reports and customer service may diverge when the warehouse is edited directly. This follows from the unresolved case facts. The preventive intervention is: Separate transactional write models from dimensional analytical representations. The reason is: Dimensional models optimize analytical measurement and are not automatically authoritative transaction stores.Incorrect Answers B:Normalization reduces update anomalies when attributes belong to different entities. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Reports and customer service may diverge when the warehouse is edited directly. C:Repeating values in one field impede first normal form and reliable relational operations. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Reports and customer service may diverge when the warehouse is edited directly. D:Relational models should make changing cardinality and time-dependent associations explicit. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Reports and customer service may diverge when the warehouse is edited directly.
Question 235An e-commerce system treats placeholders such as 'UNKNOWN' and '000000' as legitimate complete customer phone numbers. If this weakness continues, what is the most directly associated business or data risk? A falling error rate may be caused by hidden data loss rather than improved data Invalid values can pass completeness checks and distort age-based clinical decisions Completeness dashboards may falsely count unusable contact information High-impact billing errors may go unresolved behind low-risk cleanup work ExplanationCorrect Answer C:Completeness dashboards may falsely count unusable contact information. This follows from the unresolved case facts. The preventive intervention is: Define semantic missing-value rules and normalize placeholders before quality scoring. The reason is: A nonblank value can still be semantically missing or invalid for its declared purpose.Incorrect Answers A:Quality metrics require transparent populations and calculations so apparent improvements are meaningful. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Completeness dashboards may falsely count unusable contact information. B:Validity assesses whether values conform to specified business and format rules, not merely whether they are present. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Completeness dashboards may falsely count unusable contact information. D:Quality tolerances should reflect consequences and fitness for business purpose. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Completeness dashboards may falsely count unusable contact information.
Question 236A hospital restores a backup successfully but requires two days before applications can use the database again. Which data-management action most directly corrects the identified problem? Test patches against dependent applications and use a governed backup and rollback plan Define recovery-point objectives from business impact and align backup or log-capture frequency Conduct periodic end-to-end restore tests including key availability and data integrity checks Test and optimize the full recovery process against an approved recovery-time objective ExplanationCorrect Answer D:Test and optimize the full recovery process against an approved recovery-time objective. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. Practical verification is: A disaster exercise records end-to-end service availability within the approved RTO.Incorrect Answers A:Database operations must control changes that can affect service compatibility and recoverability. That is relevant to a different intervention. For the stated situation, the required action is: Test and optimize the full recovery process against an approved recovery-time objective. The governing reason is: RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. B:RPO describes tolerated data loss in time and is distinct from how long restoration takes. That is relevant to a different intervention. For the stated situation, the required action is: Test and optimize the full recovery process against an approved recovery-time objective. The governing reason is: RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. C:Backup completion is not evidence that a usable recovery can be executed. That is relevant to a different intervention. For the stated situation, the required action is: Test and optimize the full recovery process against an approved recovery-time objective. The governing reason is: RTO concerns elapsed service restoration time and includes dependencies beyond the file restore.
Question 237A bank's fraud model receives yesterday's account status while new closures are recorded continuously. A reviewer proposes: Define freshness expectations and monitor data currency at decision time. Which data-management principle best supports that choice? Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone Completeness describes the presence of required data, not its correctness or timely arrival Consistency evaluates agreement among related representations under defined semantics Integrity concerns relationships and constraints among related data, not just value formatting ExplanationCorrect Answer A:Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone. This is why the recommended action fits the given facts: A bank's fraud model receives yesterday's account status while new closures are recorded continuously. Verification would show: Decision-time tests show the latest relevant status within an approved freshness threshold.Incorrect Answers B:Completeness describes the presence of required data, not its correctness or timely arrival. This does not establish the proposed intervention. The governing principle here is: Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone. Apply it by: Define freshness expectations and monitor data currency at decision time. C:Consistency evaluates agreement among related representations under defined semantics. This does not establish the proposed intervention. The governing principle here is: Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone. Apply it by: Define freshness expectations and monitor data currency at decision time. D:Integrity concerns relationships and constraints among related data, not just value formatting. This does not establish the proposed intervention. The governing principle here is: Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone. Apply it by: Define freshness expectations and monitor data currency at decision time.
Question 238Two finance applications exchange dates as free-text strings and disagree on day-month order in regional feeds. After the proposed change—Publish a typed interface contract with unambiguous time zone and date formats—which observation best verifies that this specific weakness has been addressed? Contract tests reject the incompatible payload and notify the correct interface owner Partner validation confirms distinct null reasons survive round-trip exchange A tested crosswalk matches verified identities and flags uncertain name collisions Integration fixtures from each region resolve to the same intended settlement date ExplanationCorrect Answer D:Integration fixtures from each region resolve to the same intended settlement date. This is specific evidence for the intervention: Publish a typed interface contract with unambiguous time zone and date formats. The underlying principle is: Interoperability requires consistent semantics and explicit data types across heterogeneous systems.Incorrect Answers A:Interoperability depends on agreements about data structure and meaning, not merely transport success. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Integration fixtures from each region resolve to the same intended settlement date. B:Common file formats do not establish interoperable meaning unless data conventions are agreed. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Integration fixtures from each region resolve to the same intended settlement date. C:Data joining needs controlled entity resolution when operational identifiers differ or are ambiguous. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Integration fixtures from each region resolve to the same intended settlement date.
Question 239A hospital grants every analytics employee permission to read all medical data because central reporting is convenient. If this weakness continues, what is the most directly associated business or data risk? Insider misuse or accidental disclosure of patient information becomes more likely A routine role update may open a new exfiltration route Personal payroll information may be exposed through lower-security test systems Improper data access may become impossible to reconstruct reliably ExplanationCorrect Answer A:Insider misuse or accidental disclosure of patient information becomes more likely. This follows from the unresolved case facts. The preventive intervention is: Apply role-based least privilege and purpose-aligned authorization to sensitive patient data. The reason is: Access rights should reflect approved duties and data sensitivity rather than broad team membership.Incorrect Answers B:Authorization changes can unintentionally expand the reach of sensitive data. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Insider misuse or accidental disclosure of patient information becomes more likely. C:Production confidentiality requirements continue when sensitive data is copied into development and testing. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Insider misuse or accidental disclosure of patient information becomes more likely. D:An audit trail must have integrity and accountability to support investigation and oversight. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Insider misuse or accidental disclosure of patient information becomes more likely.
Question 240A supplier hierarchy model stores only current parent links, erasing the ownership structure that existed when earlier contracts were signed. A reviewer proposes: Retain effective-dated legal and commercial hierarchy history. Which data-management principle best supports that choice? Master-data relationships depend on business purpose and should not collapse distinct hierarchy semantics Master-data relationships may need historical validity to interpret past business events Master records are consolidated views that still require traceable source lineage and decision history Master-data updates can alter who a counterparty is, not just a descriptive field ExplanationCorrect Answer B:Master-data relationships may need historical validity to interpret past business events. This is why the recommended action fits the given facts: A supplier hierarchy model stores only current parent links, erasing the ownership structure that existed when earlier contracts were signed. Verification would show: A historical query reconstructs parent ownership as of each contract execution date.Incorrect Answers A:Master-data relationships depend on business purpose and should not collapse distinct hierarchy semantics. This does not establish the proposed intervention. The governing principle here is: Master-data relationships may need historical validity to interpret past business events. Apply it by: Retain effective-dated legal and commercial hierarchy history. C:Master records are consolidated views that still require traceable source lineage and decision history. This does not establish the proposed intervention. The governing principle here is: Master-data relationships may need historical validity to interpret past business events. Apply it by: Retain effective-dated legal and commercial hierarchy history. D:Master-data updates can alter who a counterparty is, not just a descriptive field. This does not establish the proposed intervention. The governing principle here is: Master-data relationships may need historical validity to interpret past business events. Apply it by: Retain effective-dated legal and commercial hierarchy history.