Question 140An e-commerce system treats placeholders such as 'UNKNOWN' and '000000' as legitimate complete customer phone numbers. Which data-management action most directly corrects the identified problem? Define semantic missing-value rules and normalize placeholders before quality scoring Track quality denominators, exclusion rules, and verified correction outcomes Create domain validity rules for dates and review exception rates with clinical stewards Set quality thresholds based on critical data elements, use cases, and quantified impact ExplanationCorrect Answer A:Define semantic missing-value rules and normalize placeholders before quality scoring. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: A nonblank value can still be semantically missing or invalid for its declared purpose. Practical verification is: Quality tests flag known placeholders and demonstrate improved usable contact coverage.Incorrect Answers B:Quality metrics require transparent populations and calculations so apparent improvements are meaningful. That is relevant to a different intervention. For the stated situation, the required action is: Define semantic missing-value rules and normalize placeholders before quality scoring. The governing reason is: A nonblank value can still be semantically missing or invalid for its declared purpose. C:Validity assesses whether values conform to specified business and format rules, not merely whether they are present. That is relevant to a different intervention. For the stated situation, the required action is: Define semantic missing-value rules and normalize placeholders before quality scoring. The governing reason is: A nonblank value can still be semantically missing or invalid for its declared purpose. D:Quality tolerances should reflect consequences and fitness for business purpose. That is relevant to a different intervention. For the stated situation, the required action is: Define semantic missing-value rules and normalize placeholders before quality scoring. The governing reason is: A nonblank value can still be semantically missing or invalid for its declared purpose.
Question 141A regional insurer stores sensitive claim attachments for years after their approved business and legal retention periods. After the proposed change—Enforce secure retention and defensible destruction according to classification and holds—which observation best verifies that this specific weakness has been addressed? Expired items are removed from active and backup handling under approved documented schedules Audit sampling meets investigation needs with restricted readers and controlled retention Key-access audits and a compromise drill demonstrate independent protection of secret material The vendor receives only approved aggregates and controlled queries cannot reveal individual rows ExplanationCorrect Answer A:Expired items are removed from active and backup handling under approved documented schedules. This is specific evidence for the intervention: Enforce secure retention and defensible destruction according to classification and holds. The underlying principle is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies.Incorrect Answers B:Security monitoring itself can create new repositories of sensitive information that need protection. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Expired items are removed from active and backup handling under approved documented schedules. C:Encryption does not reduce exposure when unauthorized users can access the effective key. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Expired items are removed from active and backup handling under approved documented schedules. D:Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Expired items are removed from active and backup handling under approved documented schedules.
Question 142A utility's technical schema labels a field 'CUST_STS' with no interpretation of status values. Which data-management action most directly corrects the identified problem? Add governed business definitions and link them to technical datasets in the catalog Publish accessible governed metadata with links to implementation artifacts Enrich metadata with criticality, business capabilities, and accountable use cases Document business code meanings, permissible values, and mappings alongside technical metadata ExplanationCorrect Answer D:Document business code meanings, permissible values, and mappings alongside technical metadata. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: A technical column name alone rarely conveys the semantics needed for correct reuse. Practical verification is: A consumer resolves each status code to its approved business meaning and effective period.Incorrect Answers A:Business metadata expresses meaning while technical metadata describes structures and implementation. That is relevant to a different intervention. For the stated situation, the required action is: Document business code meanings, permissible values, and mappings alongside technical metadata. The governing reason is: A technical column name alone rarely conveys the semantics needed for correct reuse. B:Metadata should serve business and technical consumers without requiring direct source-system access. That is relevant to a different intervention. For the stated situation, the required action is: Document business code meanings, permissible values, and mappings alongside technical metadata. The governing reason is: A technical column name alone rarely conveys the semantics needed for correct reuse. C:Metadata supports prioritization when technical assets can be connected to business impact. That is relevant to a different intervention. For the stated situation, the required action is: Document business code meanings, permissible values, and mappings alongside technical metadata. The governing reason is: A technical column name alone rarely conveys the semantics needed for correct reuse.
Question 143A retailer designs a single address field even though an order may have billing, shipping, and pickup locations. A reviewer proposes: Model separate address roles and their cardinality relative to orders. Which data-management principle best supports that choice? Relational models should make changing cardinality and time-dependent associations explicit Repeating values in one field impede first normal form and reliable relational operations Cardinality and business roles determine the relationships needed to represent reality Temporal data modeling preserves historically applicable facts rather than only current states ExplanationCorrect Answer C:Cardinality and business roles determine the relationships needed to represent reality. This is why the recommended action fits the given facts: A retailer designs a single address field even though an order may have billing, shipping, and pickup locations. Verification would show: Test orders hold distinct billing, shipping, and pickup addresses without overwriting.Incorrect Answers A:Relational models should make changing cardinality and time-dependent associations explicit. This does not establish the proposed intervention. The governing principle here is: Cardinality and business roles determine the relationships needed to represent reality. Apply it by: Model separate address roles and their cardinality relative to orders. B:Repeating values in one field impede first normal form and reliable relational operations. This does not establish the proposed intervention. The governing principle here is: Cardinality and business roles determine the relationships needed to represent reality. Apply it by: Model separate address roles and their cardinality relative to orders. D:Temporal data modeling preserves historically applicable facts rather than only current states. This does not establish the proposed intervention. The governing principle here is: Cardinality and business roles determine the relationships needed to represent reality. Apply it by: Model separate address roles and their cardinality relative to orders.
Question 144A retailer trains a customer targeting model on historic promotions that excluded some neighborhoods without considering the effect on underserved groups. If this weakness continues, what is the most directly associated business or data risk? The model may perpetuate discriminatory service patterns without explicit discriminatory rules Vulnerable customers may be systematically charged more based on inferred desperation Sensitive student records may be re-identified and reused in ways families did not expect Unexpected profiling may erode trust and harm customers despite formal contract acceptance ExplanationCorrect Answer A:The model may perpetuate discriminatory service patterns without explicit discriminatory rules. This follows from the unresolved case facts. The preventive intervention is: Assess representativeness and unfair impact, document mitigations, and monitor outcomes after launch. The reason is: Ethical data use requires examining foreseeable unequal harm, not only technical predictive accuracy.Incorrect Answers B:A profitable or legally permitted data application can still be manipulative or socially harmful. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: The model may perpetuate discriminatory service patterns without explicit discriminatory rules. C:Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: The model may perpetuate discriminatory service patterns without explicit discriminatory rules. D:Legal consent wording does not automatically make every secondary use ethically justified. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: The model may perpetuate discriminatory service patterns without explicit discriminatory rules.
Question 145A government agency launches a governance committee without staff time or budget for remediation commitments. If this weakness continues, what is the most directly associated business or data risk? Repeated decisions may have no effect on actual data risks Policies may exist on paper while actual systems follow conflicting behavior Unresolved ownership disputes may leave conflicting customer data in production Excessive centralization can drive ungoverned shadow spreadsheets and workarounds ExplanationCorrect Answer A:Repeated decisions may have no effect on actual data risks. This follows from the unresolved case facts. The preventive intervention is: Align decision authority with funded execution capacity and accountable delivery owners. The reason is: Governance resolutions create value only when supported by operational resources and implementation oversight.Incorrect Answers B:Governance authority needs an execution feedback loop from policy decision to operational compliance. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Repeated decisions may have no effect on actual data risks. C:Data governance is the exercise of authority and control over data-management decisions rather than a committee title alone. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Repeated decisions may have no effect on actual data risks. D:Governance authority can be distributed within common policies while retaining enterprise oversight. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Repeated decisions may have no effect on actual data risks.
Question 146A manufacturing firm discovers unusual mass exports from its product design repository but has no data-specific incident response plan. A reviewer proposes: Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation. Which data-management principle best supports that choice? Data security needs preparedness for incidents affecting confidentiality, integrity, and availability Production confidentiality requirements continue when sensitive data is copied into development and testing Security and privacy controls should reduce unnecessary exposure at data exchange boundaries Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies ExplanationCorrect Answer A:Data security needs preparedness for incidents affecting confidentiality, integrity, and availability. This is why the recommended action fits the given facts: A manufacturing firm discovers unusual mass exports from its product design repository but has no data-specific incident response plan. Verification would show: A simulation detects abnormal exports and records containment decisions plus preserved evidence.Incorrect Answers B:Production confidentiality requirements continue when sensitive data is copied into development and testing. This does not establish the proposed intervention. The governing principle here is: Data security needs preparedness for incidents affecting confidentiality, integrity, and availability. Apply it by: Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation. C:Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. This does not establish the proposed intervention. The governing principle here is: Data security needs preparedness for incidents affecting confidentiality, integrity, and availability. Apply it by: Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation. D:Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. This does not establish the proposed intervention. The governing principle here is: Data security needs preparedness for incidents affecting confidentiality, integrity, and availability. Apply it by: Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation.
Question 147A transportation platform patches its database engine in production without validating driver compatibility or rollback procedures. After the proposed change—Test patches against dependent applications and use a governed backup and rollback plan—which observation best verifies that this specific weakness has been addressed? A disaster exercise records end-to-end service availability within the approved RTO Preproduction integration tests pass and a rollback rehearsal meets service targets A load replay shows lower deadlock rates without incorrect partial writes A timed restore recovers a deleted record from an earlier valid point while replicas remain synchronized ExplanationCorrect Answer B:Preproduction integration tests pass and a rollback rehearsal meets service targets. This is specific evidence for the intervention: Test patches against dependent applications and use a governed backup and rollback plan. The underlying principle is: Database operations must control changes that can affect service compatibility and recoverability.Incorrect Answers A:RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Preproduction integration tests pass and a rollback rehearsal meets service targets. C:Concurrent database operations can block or deadlock when transaction lock order conflicts. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Preproduction integration tests pass and a rollback rehearsal meets service targets. D:Replication can faithfully copy corruption or deletion; it is not a substitute for recoverable backups. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Preproduction integration tests pass and a rollback rehearsal meets service targets.
Question 148A lending company publishes a 'customer risk' data product without recording the model version or feature calculation dates. After the proposed change—Capture reproducibility metadata for feature definitions, models, and data snapshots—which observation best verifies that this specific weakness has been addressed? A historical risk value can be regenerated using its recorded model and feature lineage An auditor reconstructs the definition in effect when last year's report was produced A regulatory-change audit links revised definitions, approvers, and downstream notification dates Catalog links continue to resolve a dataset after renaming with its prior names retained ExplanationCorrect Answer A:A historical risk value can be regenerated using its recorded model and feature lineage. This is specific evidence for the intervention: Capture reproducibility metadata for feature definitions, models, and data snapshots. The underlying principle is: Data product provenance includes the versions and inputs that produced a given result.Incorrect Answers B:Metadata changes can alter interpretation of historical datasets and must be auditable. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A historical risk value can be regenerated using its recorded model and feature lineage. C:Metadata governance supports accountability by recording who changed meanings and when. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A historical risk value can be regenerated using its recorded model and feature lineage. D:Metadata identity must persist across renames and versions to preserve references. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A historical risk value can be regenerated using its recorded model and feature lineage.
Question 149A hospitality chain has inconsistent hotel identifiers between booking, property, and loyalty platforms. Which data-management action most directly corrects the identified problem? Implement tracked master-data distribution with acknowledgments and reconciliation Apply governed identity change review with evidence and separate approval for high-impact attributes Assign authoritative property identifiers and distribute controlled mappings to consuming applications Reconcile identifiers using source namespace, attributes, and steward-approved crosswalks ExplanationCorrect Answer C:Assign authoritative property identifiers and distribute controlled mappings to consuming applications. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: A governed master identifier supports consistent entity references across transactional contexts. Practical verification is: The same property joins correctly across reservations, loyalty, and financial systems.Incorrect Answers A:Creating a golden record does not ensure that consuming applications have adopted the correct value. That is relevant to a different intervention. For the stated situation, the required action is: Assign authoritative property identifiers and distribute controlled mappings to consuming applications. The governing reason is: A governed master identifier supports consistent entity references across transactional contexts. B:Master-data updates can alter who a counterparty is, not just a descriptive field. That is relevant to a different intervention. For the stated situation, the required action is: Assign authoritative property identifiers and distribute controlled mappings to consuming applications. The governing reason is: A governed master identifier supports consistent entity references across transactional contexts. D:Master identifiers are only unique within their defined domain and namespace unless governed otherwise. That is relevant to a different intervention. For the stated situation, the required action is: Assign authoritative property identifiers and distribute controlled mappings to consuming applications. The governing reason is: A governed master identifier supports consistent entity references across transactional contexts.
Question 150A regional hospital plans database maintenance without testing failover application connections or transaction replay. If this weakness continues, what is the most directly associated business or data risk? Customers may see a payment as missing even though it was just committed A nominally redundant database may still cause a prolonged service outage Unnecessary infrastructure spending may leave the query bottleneck unresolved A technically valid backup can still leave critical care services unavailable too long ExplanationCorrect Answer B:A nominally redundant database may still cause a prolonged service outage. This follows from the unresolved case facts. The preventive intervention is: Exercise planned failover and verify connection, transaction, and data consistency behaviors. The reason is: High availability requires functioning application and data recovery paths, not merely a standby server.Incorrect Answers A:Availability and consistency design choices must match the guarantees consumers require. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A nominally redundant database may still cause a prolonged service outage. C:Database performance depends on access paths and workload patterns as well as hardware resources. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A nominally redundant database may still cause a prolonged service outage. D:RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A nominally redundant database may still cause a prolonged service outage.