Question 100A regional insurer stores sensitive claim attachments for years after their approved business and legal retention periods. Which data-management action most directly corrects the identified problem? Limit audit-log access, retention, and sensitive content while keeping required security evidence Separate encryption keys from protected data and manage key access, rotation, and storage securely Minimize shared fields and define approved purposes and recipient restrictions Enforce secure retention and defensible destruction according to classification and holds ExplanationCorrect Answer D:Enforce secure retention and defensible destruction according to classification and holds. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. Practical verification is: Expired items are removed from active and backup handling under approved documented schedules.Incorrect Answers A:Security monitoring itself can create new repositories of sensitive information that need protection. That is relevant to a different intervention. For the stated situation, the required action is: Enforce secure retention and defensible destruction according to classification and holds. The governing reason is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. B:Encryption does not reduce exposure when unauthorized users can access the effective key. That is relevant to a different intervention. For the stated situation, the required action is: Enforce secure retention and defensible destruction according to classification and holds. The governing reason is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. C:Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. That is relevant to a different intervention. For the stated situation, the required action is: Enforce secure retention and defensible destruction according to classification and holds. The governing reason is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies.
Question 101A financial institution tracks one enterprise data-quality percentage that masks a severe defect in a small sanctions dataset. A reviewer proposes: Segment quality measures by source, domain, and criticality instead of averaging away important failures. Which data-management principle best supports that choice? Data quality must be evaluated against a shared business definition and intended use 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 Data-quality measurement only helps when linked to accountable decisions and corrective action ExplanationCorrect Answer C:Aggregate quality scores can hide concentrated risks that matter to specific controls. This is why the recommended action fits the given facts: A financial institution tracks one enterprise data-quality percentage that masks a severe defect in a small sanctions dataset. Verification would show: Drill-down dashboards expose the sanctions defect even when overall quality is high.Incorrect Answers A:Data quality must be evaluated against a shared business definition and intended use. This does not establish the proposed intervention. The governing principle here is: Aggregate quality scores can hide concentrated risks that matter to specific controls. Apply it by: Segment quality measures by source, domain, and criticality instead of averaging away important failures. B:Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. This does not establish the proposed intervention. The governing principle here is: Aggregate quality scores can hide concentrated risks that matter to specific controls. Apply it by: Segment quality measures by source, domain, and criticality instead of averaging away important failures. D: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: Aggregate quality scores can hide concentrated risks that matter to specific controls. Apply it by: Segment quality measures by source, domain, and criticality instead of averaging away important failures.
Question 102A manufacturer asks a vendor to guarantee 100 percent accurate product descriptions despite changing specifications and multilingual suppliers. If this weakness continues, what is the most directly associated business or data risk? High-impact billing errors may go unresolved behind low-risk cleanup work An unenforceable quality promise may leave defects disputed and unmanaged Blanket rejection may interrupt operations unnecessarily or hide root causes Data defects can return unnoticed after the initial cleanup ExplanationCorrect Answer B:An unenforceable quality promise may leave defects disputed and unmanaged. This follows from the unresolved case facts. The preventive intervention is: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. The reason is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims.Incorrect Answers A: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: An unenforceable quality promise may leave defects disputed and unmanaged. C:Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: An unenforceable quality promise may leave defects disputed and unmanaged. D:Quality performance changes over time as sources and processes evolve. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: An unenforceable quality promise may leave defects disputed and unmanaged.
Question 103A financial service uses an eventually consistent read replica for a transaction confirmation that requires immediate read-after-write behavior. A reviewer proposes: Choose a consistency model appropriate to the transaction and document replica lag limitations. Which data-management principle best supports that choice? High availability requires functioning application and data recovery paths, not merely a standby server Concurrent database operations can block or deadlock when transaction lock order conflicts Availability and consistency design choices must match the guarantees consumers require Replication can faithfully copy corruption or deletion; it is not a substitute for recoverable backups ExplanationCorrect Answer C:Availability and consistency design choices must match the guarantees consumers require. This is why the recommended action fits the given facts: A financial service uses an eventually consistent read replica for a transaction confirmation that requires immediate read-after-write behavior. Verification would show: A test transaction is confirmed from a consistent view within the approved guarantee.Incorrect Answers A:High availability requires functioning application and data recovery paths, not merely a standby server. This does not establish the proposed intervention. The governing principle here is: Availability and consistency design choices must match the guarantees consumers require. Apply it by: Choose a consistency model appropriate to the transaction and document replica lag limitations. B:Concurrent database operations can block or deadlock when transaction lock order conflicts. This does not establish the proposed intervention. The governing principle here is: Availability and consistency design choices must match the guarantees consumers require. Apply it by: Choose a consistency model appropriate to the transaction and document replica lag limitations. D:Replication can faithfully copy corruption or deletion; it is not a substitute for recoverable backups. This does not establish the proposed intervention. The governing principle here is: Availability and consistency design choices must match the guarantees consumers require. Apply it by: Choose a consistency model appropriate to the transaction and document replica lag limitations.
Question 104A bank reports a data table is certified but no one records the certification criteria, reviewer, or review date. If this weakness continues, what is the most directly associated business or data risk? A stale badge can mislead consumers into trusting unverified datasets Old metrics may be reinterpreted under today's incompatible definition The organization may be unable to explain how reported data definitions evolved Cataloging may leak protected asset details to a wider audience ExplanationCorrect Answer A:A stale badge can mislead consumers into trusting unverified datasets. This follows from the unresolved case facts. The preventive intervention is: Publish certification metadata with decision rules, evidence, approver, and validity period. The reason is: Trust labels are meaningful only when supported by explicit governance and auditable qualification.Incorrect Answers B:Metadata changes can alter interpretation of historical datasets and must be auditable. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A stale badge can mislead consumers into trusting unverified datasets. C:Metadata governance supports accountability by recording who changed meanings and when. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A stale badge can mislead consumers into trusting unverified datasets. D:Metadata about security and permitted use must survive harvesting and downstream catalog distribution. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A stale badge can mislead consumers into trusting unverified datasets.
Question 105A bank exposes a new customer API before specifying attribute definitions, permissible nulls, and ownership of breaking changes. If this weakness continues, what is the most directly associated business or data risk? Contradictory customer identities can spread through analytics and operational decisions Unannounced changes can break dependent fraud, servicing, and reporting systems Unknown upstream dependencies can interrupt claims or policy processing during migration Critical operational feeds may be missed by resilience and ownership planning ExplanationCorrect Answer B:Unannounced changes can break dependent fraud, servicing, and reporting systems. This follows from the unresolved case facts. The preventive intervention is: Publish a versioned data contract with semantic definitions, quality rules, and change governance. The reason is: Interfaces are data products whose meaning and compatibility require coordinated lifecycle management.Incorrect Answers A:Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Unannounced changes can break dependent fraud, servicing, and reporting systems. C:Transition architecture requires a credible current state to identify change impact and migration constraints. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Unannounced changes can break dependent fraud, servicing, and reporting systems. D:Data-flow architecture makes movement and dependencies visible for operational and governance design. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Unannounced changes can break dependent fraud, servicing, and reporting systems.
Question 106A hospital's data team starts a patient database by writing SQL tables without agreeing what constitutes an encounter. After the proposed change—Build a conceptual data model with business stakeholders before finalizing logical structures—which observation best verifies that this specific weakness has been addressed? Benchmark queries and integrity tests justify selected indexes without changing logical meaning Test addresses from multiple countries are preserved without fabricated states or truncated postal codes Stakeholders approve encounter definitions before logical attributes and physical tables are created Hierarchy tests reject cycles and return consistent account rollups ExplanationCorrect Answer C:Stakeholders approve encounter definitions before logical attributes and physical tables are created. This is specific evidence for the intervention: Build a conceptual data model with business stakeholders before finalizing logical structures. The underlying principle is: Conceptual modeling captures agreed business entities and relationships independent of storage technology.Incorrect Answers A:Physical optimization should support validated business structure and observed workload needs. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Stakeholders approve encounter definitions before logical attributes and physical tables are created. B:Conceptual business data should not be constrained by one region's physical conventions. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Stakeholders approve encounter definitions before logical attributes and physical tables are created. D:Recursive relationships require business rules to prevent impossible self-referential structures. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Stakeholders approve encounter definitions before logical attributes and physical tables are created.
Question 107A museum moves archival databases to cheap storage but never confirms that retrieval times meet public research obligations. Which data-management action most directly corrects the identified problem? Monitor growth, apply lifecycle storage tiers, and plan capacity ahead of exhaustion Inspect workload plans, selectivity, indexes, and statistics before changing capacity Define recovery-point objectives from business impact and align backup or log-capture frequency Set tiering policies from access frequency, retention, and retrieval service levels ExplanationCorrect Answer D:Set tiering policies from access frequency, retention, and retrieval service levels. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Storage tiers trade access speed and cost; decisions should follow information lifecycle requirements. Practical verification is: Sample archived records can be retrieved within agreed service times and costs.Incorrect Answers A:Storage operations includes capacity forecasting and data lifecycle placement, not only adding disks after failure. That is relevant to a different intervention. For the stated situation, the required action is: Set tiering policies from access frequency, retention, and retrieval service levels. The governing reason is: Storage tiers trade access speed and cost; decisions should follow information lifecycle requirements. B:Database performance depends on access paths and workload patterns as well as hardware resources. That is relevant to a different intervention. For the stated situation, the required action is: Set tiering policies from access frequency, retention, and retrieval service levels. The governing reason is: Storage tiers trade access speed and cost; decisions should follow information lifecycle requirements. C: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: Set tiering policies from access frequency, retention, and retrieval service levels. The governing reason is: Storage tiers trade access speed and cost; decisions should follow information lifecycle requirements.
Question 108A product platform deletes customers physically when they close accounts without evaluating dependent order-history obligations. Which data-management action most directly corrects the identified problem? Model entity lifecycle and retention/deletion behavior explicitly rather than assuming cascading deletes Represent tax-code relationships and applicable effective periods explicitly Model and validate hierarchy constraints, including cycles and allowed depth Model the many-to-many relationship with an associative entity and defined business attributes ExplanationCorrect Answer A:Model entity lifecycle and retention/deletion behavior explicitly rather than assuming cascading deletes. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Deletion semantics depend on business rules, relationships, and retention duties. Practical verification is: Closed accounts lose access appropriately while required order evidence remains referentially consistent.Incorrect Answers B:Meaningful relational models include temporal reference constraints when business rules change over time. That is relevant to a different intervention. For the stated situation, the required action is: Model entity lifecycle and retention/deletion behavior explicitly rather than assuming cascading deletes. The governing reason is: Deletion semantics depend on business rules, relationships, and retention duties. C:Recursive relationships require business rules to prevent impossible self-referential structures. That is relevant to a different intervention. For the stated situation, the required action is: Model entity lifecycle and retention/deletion behavior explicitly rather than assuming cascading deletes. The governing reason is: Deletion semantics depend on business rules, relationships, and retention duties. D:Many-to-many relationships usually require an explicit association in relational implementation. That is relevant to a different intervention. For the stated situation, the required action is: Model entity lifecycle and retention/deletion behavior explicitly rather than assuming cascading deletes. The governing reason is: Deletion semantics depend on business rules, relationships, and retention duties.
Question 109A logistics platform receives all shipments but 15 percent of delivery timestamps are blank during partner outages. A reviewer proposes: Monitor attribute and event completeness by source, time, and criticality. Which data-management principle best supports that choice? Completeness describes the presence of required data, not its correctness or timely arrival Completeness measures presence while accuracy measures correspondence to real-world facts Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone Quality performance changes over time as sources and processes evolve ExplanationCorrect Answer A:Completeness describes the presence of required data, not its correctness or timely arrival. This is why the recommended action fits the given facts: A logistics platform receives all shipments but 15 percent of delivery timestamps are blank during partner outages. Verification would show: Source-specific completeness rates expose the failing partner and improve after remediation.Incorrect Answers B:Completeness measures presence while accuracy measures correspondence to real-world facts. This does not establish the proposed intervention. The governing principle here is: Completeness describes the presence of required data, not its correctness or timely arrival. Apply it by: Monitor attribute and event completeness by source, time, and criticality. C:Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone. This does not establish the proposed intervention. The governing principle here is: Completeness describes the presence of required data, not its correctness or timely arrival. Apply it by: Monitor attribute and event completeness by source, time, and criticality. D:Quality performance changes over time as sources and processes evolve. This does not establish the proposed intervention. The governing principle here is: Completeness describes the presence of required data, not its correctness or timely arrival. Apply it by: Monitor attribute and event completeness by source, time, and criticality.
Question 110A school system supplies student behavior data to a vendor's model after removing names but leaves persistent identifiers easily linked to class registers. A reviewer proposes: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards. Which data-management principle best supports that choice? Ethical data use requires examining foreseeable unequal harm, not only technical predictive accuracy Ethical obligations continue where apparently anonymized records can reasonably be linked back to children A profitable or legally permitted data application can still be manipulative or socially harmful Legal consent wording does not automatically make every secondary use ethically justified ExplanationCorrect Answer B:Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. This is why the recommended action fits the given facts: A school system supplies student behavior data to a vendor's model after removing names but leaves persistent identifiers easily linked to class registers. Verification would show: A challenge test documents linkability reduction and enforceable vendor restrictions.Incorrect Answers A:Ethical data use requires examining foreseeable unequal harm, not only technical predictive accuracy. This does not establish the proposed intervention. The governing principle here is: Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. Apply it by: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards. C:A profitable or legally permitted data application can still be manipulative or socially harmful. This does not establish the proposed intervention. The governing principle here is: Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. Apply it by: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards. D:Legal consent wording does not automatically make every secondary use ethically justified. This does not establish the proposed intervention. The governing principle here is: Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. Apply it by: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards.