Question 160An online lending platform changes authorization roles without testing whether analysts gained permission to export identity documents. A reviewer proposes: Test access-control changes against approved entitlements before release and monitor privileged changes. Which data-management principle best supports that choice? Production confidentiality requirements continue when sensitive data is copied into development and testing Authorization changes can unintentionally expand the reach of sensitive data Access rights should reflect approved duties and data sensitivity rather than broad team membership Internal network placement does not eliminate interception or impersonation risk ExplanationCorrect Answer B:Authorization changes can unintentionally expand the reach of sensitive data. This is why the recommended action fits the given facts: An online lending platform changes authorization roles without testing whether analysts gained permission to export identity documents. Verification would show: Negative-access tests deny unauthorized exports and privileged changes appear in the audit log.Incorrect Answers A: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: Authorization changes can unintentionally expand the reach of sensitive data. Apply it by: Test access-control changes against approved entitlements before release and monitor privileged changes. C:Access rights should reflect approved duties and data sensitivity rather than broad team membership. This does not establish the proposed intervention. The governing principle here is: Authorization changes can unintentionally expand the reach of sensitive data. Apply it by: Test access-control changes against approved entitlements before release and monitor privileged changes. D:Internal network placement does not eliminate interception or impersonation risk. This does not establish the proposed intervention. The governing principle here is: Authorization changes can unintentionally expand the reach of sensitive data. Apply it by: Test access-control changes against approved entitlements before release and monitor privileged changes.
Question 161A distributor's supplier master allows tax identifiers to be changed without verifying the legal entity relationship. A reviewer proposes: Apply governed identity change review with evidence and separate approval for high-impact attributes. Which data-management principle best supports that choice? Master-data matching must reflect the real-world entity granularity needed by the business Master attributes must reflect business meaning; one entity may legitimately have multiple related attributes Master-data updates can alter who a counterparty is, not just a descriptive field Master-data consolidation should be reversible when merge decisions are corrected ExplanationCorrect Answer C:Master-data updates can alter who a counterparty is, not just a descriptive field. This is why the recommended action fits the given facts: A distributor's supplier master allows tax identifiers to be changed without verifying the legal entity relationship. Verification would show: High-impact identity changes show verified documentation and approval audit trails.Incorrect Answers A:Master-data matching must reflect the real-world entity granularity needed by the business. This does not establish the proposed intervention. The governing principle here is: Master-data updates can alter who a counterparty is, not just a descriptive field. Apply it by: Apply governed identity change review with evidence and separate approval for high-impact attributes. B:Master attributes must reflect business meaning; one entity may legitimately have multiple related attributes. This does not establish the proposed intervention. The governing principle here is: Master-data updates can alter who a counterparty is, not just a descriptive field. Apply it by: Apply governed identity change review with evidence and separate approval for high-impact attributes. D:Master-data consolidation should be reversible when merge decisions are corrected. This does not establish the proposed intervention. The governing principle here is: Master-data updates can alter who a counterparty is, not just a descriptive field. Apply it by: Apply governed identity change review with evidence and separate approval for high-impact attributes.
Question 162A retail database shows slow product lookups and an engineer proposes buying more storage without examining query plans. Which data-management action most directly corrects the identified problem? Exercise planned failover and verify connection, transaction, and data consistency behaviors Monitor growth, apply lifecycle storage tiers, and plan capacity ahead of exhaustion Set tiering policies from access frequency, retention, and retrieval service levels Inspect workload plans, selectivity, indexes, and statistics before changing capacity ExplanationCorrect Answer D:Inspect workload plans, selectivity, indexes, and statistics before changing capacity. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Database performance depends on access paths and workload patterns as well as hardware resources. Practical verification is: Measured query latency improves after a justified index or query change.Incorrect Answers A:High availability requires functioning application and data recovery paths, not merely a standby server. That is relevant to a different intervention. For the stated situation, the required action is: Inspect workload plans, selectivity, indexes, and statistics before changing capacity. The governing reason is: Database performance depends on access paths and workload patterns as well as hardware resources. B: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: Inspect workload plans, selectivity, indexes, and statistics before changing capacity. The governing reason is: Database performance depends on access paths and workload patterns as well as hardware resources. C:Storage tiers trade access speed and cost; decisions should follow information lifecycle requirements. That is relevant to a different intervention. For the stated situation, the required action is: Inspect workload plans, selectivity, indexes, and statistics before changing capacity. The governing reason is: Database performance depends on access paths and workload patterns as well as hardware resources.
Question 163A retailer designs a single address field even though an order may have billing, shipping, and pickup locations. After the proposed change—Model separate address roles and their cardinality relative to orders—which observation best verifies that this specific weakness has been addressed? Test orders hold distinct billing, shipping, and pickup addresses without overwriting Plan change history reconstructs the active plan at each invoice event Queries can join each order to its individual items without string parsing Historical invoices calculate using rates effective on the invoice dates ExplanationCorrect Answer A:Test orders hold distinct billing, shipping, and pickup addresses without overwriting. This is specific evidence for the intervention: Model separate address roles and their cardinality relative to orders. The underlying principle is: Cardinality and business roles determine the relationships needed to represent reality.Incorrect Answers B:Relational models should make changing cardinality and time-dependent associations explicit. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Test orders hold distinct billing, shipping, and pickup addresses without overwriting. C:Repeating values in one field impede first normal form and reliable relational operations. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Test orders hold distinct billing, shipping, and pickup addresses without overwriting. D:Temporal data modeling preserves historically applicable facts rather than only current states. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Test orders hold distinct billing, shipping, and pickup addresses without overwriting.
Question 164A data platform treats a one-time 99 percent email validity result as proof that no ongoing monitoring is needed. After the proposed change—Create continuous quality monitoring with thresholds, trends, and accountable alerts—which observation best verifies that this specific weakness has been addressed? Daily checks detect missing claim attributes before approval cutoffs An alert fires on a controlled surge in malformed email values and corrective actions are tracked Source-specific completeness rates expose the failing partner and improve after remediation Meter-ID validation has stricter thresholds and higher escalation priority than cosmetic labels ExplanationCorrect Answer B:An alert fires on a controlled surge in malformed email values and corrective actions are tracked. This is specific evidence for the intervention: Create continuous quality monitoring with thresholds, trends, and accountable alerts. The underlying principle is: Quality performance changes over time as sources and processes evolve.Incorrect Answers A: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: An alert fires on a controlled surge in malformed email values and corrective actions are tracked. C: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: An alert fires on a controlled surge in malformed email values and corrective actions are tracked. D:Quality tolerances should reflect consequences and fitness for business purpose. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: An alert fires on a controlled surge in malformed email values and corrective actions are tracked.
Question 165A regional hospital plans database maintenance without testing failover application connections or transaction replay. Which data-management action most directly corrects the identified problem? Exercise planned failover and verify connection, transaction, and data consistency behaviors Choose a consistency model appropriate to the transaction and document replica lag limitations Inspect workload plans, selectivity, indexes, and statistics before changing capacity Test and optimize the full recovery process against an approved recovery-time objective ExplanationCorrect Answer A:Exercise planned failover and verify connection, transaction, and data consistency behaviors. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: High availability requires functioning application and data recovery paths, not merely a standby server. Practical verification is: A failover drill keeps critical workflows within approved loss and outage limits.Incorrect Answers B:Availability and consistency design choices must match the guarantees consumers require. That is relevant to a different intervention. For the stated situation, the required action is: Exercise planned failover and verify connection, transaction, and data consistency behaviors. The governing reason is: High availability requires functioning application and data recovery paths, not merely a standby server. C: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: Exercise planned failover and verify connection, transaction, and data consistency behaviors. The governing reason is: High availability requires functioning application and data recovery paths, not merely a standby server. D:RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. That is relevant to a different intervention. For the stated situation, the required action is: Exercise planned failover and verify connection, transaction, and data consistency behaviors. The governing reason is: High availability requires functioning application and data recovery paths, not merely a standby server.
Question 166A regional hospital measures its data team solely by database uptime even though clinical reports use conflicting definitions of patient visits. A reviewer proposes: Connect data-management activities to defined clinical information outcomes and accountable roles. Which data-management principle best supports that choice? Data-management performance includes realized information value and outcomes, not just project task completion Related data-management disciplines need an integrated operating plan so their outputs reinforce one another Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability Stewardship requires assigned ongoing activities and accountability rather than an honorary designation ExplanationCorrect Answer C:Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability. This is why the recommended action fits the given facts: A regional hospital measures its data team solely by database uptime even though clinical reports use conflicting definitions of patient visits. Verification would show: A documented operating plan links visit definitions, accountable teams, quality measures, and clinical report acceptance tests.Incorrect Answers A:Data-management performance includes realized information value and outcomes, not just project task completion. This does not establish the proposed intervention. The governing principle here is: Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability. Apply it by: Connect data-management activities to defined clinical information outcomes and accountable roles. B:Related data-management disciplines need an integrated operating plan so their outputs reinforce one another. This does not establish the proposed intervention. The governing principle here is: Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability. Apply it by: Connect data-management activities to defined clinical information outcomes and accountable roles. D:Stewardship requires assigned ongoing activities and accountability rather than an honorary designation. This does not establish the proposed intervention. The governing principle here is: Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability. Apply it by: Connect data-management activities to defined clinical information outcomes and accountable roles.
Question 167A manufacturer represents all equipment types in one table but ignores attributes that apply only to hazardous machinery. A reviewer proposes: Model supertype and subtype entities with appropriate constraints for type-specific attributes. Which data-management principle best supports that choice? Specialization captures shared identity while preserving subtype-specific rules Data types and constraints should enforce basic attribute meaning at the data boundary Entity granularity must match how many real-world instances can occur for each parent Normalization reduces update anomalies when attributes belong to different entities ExplanationCorrect Answer A:Specialization captures shared identity while preserving subtype-specific rules. This is why the recommended action fits the given facts: A manufacturer represents all equipment types in one table but ignores attributes that apply only to hazardous machinery. Verification would show: The model validates hazardous-machine inspections without forcing irrelevant fields on ordinary equipment.Incorrect Answers B:Data types and constraints should enforce basic attribute meaning at the data boundary. This does not establish the proposed intervention. The governing principle here is: Specialization captures shared identity while preserving subtype-specific rules. Apply it by: Model supertype and subtype entities with appropriate constraints for type-specific attributes. C:Entity granularity must match how many real-world instances can occur for each parent. This does not establish the proposed intervention. The governing principle here is: Specialization captures shared identity while preserving subtype-specific rules. Apply it by: Model supertype and subtype entities with appropriate constraints for type-specific attributes. D:Normalization reduces update anomalies when attributes belong to different entities. This does not establish the proposed intervention. The governing principle here is: Specialization captures shared identity while preserving subtype-specific rules. Apply it by: Model supertype and subtype entities with appropriate constraints for type-specific attributes.
Question 168A university keeps dictionary definitions inside source-code comments inaccessible to research and governance teams. 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 Use metadata lineage and dependency impact analysis before releasing the change Version metadata and retain effective dates, reviewer, and change history ExplanationCorrect Answer B:Publish accessible governed metadata with links to implementation artifacts. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Metadata should serve business and technical consumers without requiring direct source-system access. Practical verification is: Authorized researchers find reviewed definitions and underlying implementation references in one catalog.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: Publish accessible governed metadata with links to implementation artifacts. The governing reason is: Metadata should serve business and technical consumers without requiring direct source-system access. C:Metadata supports change impact when it links source fields to downstream consumers. That is relevant to a different intervention. For the stated situation, the required action is: Publish accessible governed metadata with links to implementation artifacts. The governing reason is: Metadata should serve business and technical consumers without requiring direct source-system access. D:Metadata changes can alter interpretation of historical datasets and must be auditable. That is relevant to a different intervention. For the stated situation, the required action is: Publish accessible governed metadata with links to implementation artifacts. The governing reason is: Metadata should serve business and technical consumers without requiring direct source-system access.
Question 169An e-commerce platform discovers a catalog dataset tagged public even though it now contains customer email addresses. If this weakness continues, what is the most directly associated business or data risk? Catalog consumers may export identifiable customer data under an obsolete public label Cataloging may leak protected asset details to a wider audience References and lineage can break when display labels are treated as unique identifiers Schema changes may occur without business signoff or informed downstream users ExplanationCorrect Answer A:Catalog consumers may export identifiable customer data under an obsolete public label. This follows from the unresolved case facts. The preventive intervention is: Implement metadata classification checks and event-driven reassessment on schema changes. The reason is: Classification metadata must reflect actual data content and sensitivity rather than static initial labels.Incorrect Answers B: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: Catalog consumers may export identifiable customer data under an obsolete public label. C:Metadata identity must persist across renames and versions to preserve references. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Catalog consumers may export identifiable customer data under an obsolete public label. D:Administrative metadata clarifies accountability and operational responsibilities for each asset. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Catalog consumers may export identifiable customer data under an obsolete public label.
Question 170A finance team exports identifiable payroll records to a test environment where contractor accounts have unrestricted access. Which data-management action most directly corrects the identified problem? Test access-control changes against approved entitlements before release and monitor privileged changes Apply role-based least privilege and purpose-aligned authorization to sensitive patient data Use approved data masking or synthetic substitutes and restrict nonproduction access Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation ExplanationCorrect Answer C:Use approved data masking or synthetic substitutes and restrict nonproduction access. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Production confidentiality requirements continue when sensitive data is copied into development and testing. Practical verification is: Sample nonproduction records lack recoverable direct identifiers and access reviews pass.Incorrect Answers A:Authorization changes can unintentionally expand the reach of sensitive data. That is relevant to a different intervention. For the stated situation, the required action is: Use approved data masking or synthetic substitutes and restrict nonproduction access. The governing reason is: Production confidentiality requirements continue when sensitive data is copied into development and testing. B:Access rights should reflect approved duties and data sensitivity rather than broad team membership. That is relevant to a different intervention. For the stated situation, the required action is: Use approved data masking or synthetic substitutes and restrict nonproduction access. The governing reason is: Production confidentiality requirements continue when sensitive data is copied into development and testing. D:Data security needs preparedness for incidents affecting confidentiality, integrity, and availability. That is relevant to a different intervention. For the stated situation, the required action is: Use approved data masking or synthetic substitutes and restrict nonproduction access. The governing reason is: Production confidentiality requirements continue when sensitive data is copied into development and testing.