Question 600A legal team receives an e-discovery request but cannot establish which chat messages were retained, held, or deleted. A reviewer proposes: Maintain defensible records inventories, custody logs, and controlled discovery exports. Which data-management principle best supports that choice? Authorized legal holds can override routine records disposal for in-scope material Electronic records conversion needs a policy for authentic copies and lawful original handling Unmanaged collaboration channels create custody gaps when employees leave or access changes Discovery depends on records authenticity, provenance, completeness, and disposition evidence ExplanationCorrect Answer D:Discovery depends on records authenticity, provenance, completeness, and disposition evidence. This is why the recommended action fits the given facts: A legal team receives an e-discovery request but cannot establish which chat messages were retained, held, or deleted. Verification would show: A tested export reconciles selected custodians and periods to retention and hold logs.Incorrect Answers A:Authorized legal holds can override routine records disposal for in-scope material. This does not establish the proposed intervention. The governing principle here is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence. Apply it by: Maintain defensible records inventories, custody logs, and controlled discovery exports. B:Electronic records conversion needs a policy for authentic copies and lawful original handling. This does not establish the proposed intervention. The governing principle here is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence. Apply it by: Maintain defensible records inventories, custody logs, and controlled discovery exports. C:Unmanaged collaboration channels create custody gaps when employees leave or access changes. This does not establish the proposed intervention. The governing principle here is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence. Apply it by: Maintain defensible records inventories, custody logs, and controlled discovery exports.
Question 601A hospital's data team starts a patient database by writing SQL tables without agreeing what constitutes an encounter. A reviewer proposes: Build a conceptual data model with business stakeholders before finalizing logical structures. Which data-management principle best supports that choice? Conceptual modeling captures agreed business entities and relationships independent of storage technology Physical optimization should support validated business structure and observed workload needs Conceptual business data should not be constrained by one region's physical conventions Recursive relationships require business rules to prevent impossible self-referential structures ExplanationCorrect Answer A:Conceptual modeling captures agreed business entities and relationships independent of storage technology. This is why the recommended action fits the given facts: A hospital's data team starts a patient database by writing SQL tables without agreeing what constitutes an encounter. Verification would show: Stakeholders approve encounter definitions before logical attributes and physical tables are created.Incorrect Answers B:Physical optimization should support validated business structure and observed workload needs. This does not establish the proposed intervention. The governing principle here is: Conceptual modeling captures agreed business entities and relationships independent of storage technology. Apply it by: Build a conceptual data model with business stakeholders before finalizing logical structures. C:Conceptual business data should not be constrained by one region's physical conventions. This does not establish the proposed intervention. The governing principle here is: Conceptual modeling captures agreed business entities and relationships independent of storage technology. Apply it by: Build a conceptual data model with business stakeholders before finalizing logical structures. D:Recursive relationships require business rules to prevent impossible self-referential structures. This does not establish the proposed intervention. The governing principle here is: Conceptual modeling captures agreed business entities and relationships independent of storage technology. Apply it by: Build a conceptual data model with business stakeholders before finalizing logical structures.
Question 602A retailer relies on a schema registry but has no record of who should approve changes to product attributes. A reviewer proposes: Record data owner, steward, custodian, and change authority within metadata. Which data-management principle best supports that choice? Metadata governance supports accountability by recording who changed meanings and when Metadata identity must persist across renames and versions to preserve references Administrative metadata clarifies accountability and operational responsibilities for each asset Metadata changes can alter interpretation of historical datasets and must be auditable ExplanationCorrect Answer C:Administrative metadata clarifies accountability and operational responsibilities for each asset. This is why the recommended action fits the given facts: A retailer relies on a schema registry but has no record of who should approve changes to product attributes. Verification would show: An attribute change request routes automatically to the correct accountable approver.Incorrect Answers A:Metadata governance supports accountability by recording who changed meanings and when. This does not establish the proposed intervention. The governing principle here is: Administrative metadata clarifies accountability and operational responsibilities for each asset. Apply it by: Record data owner, steward, custodian, and change authority within metadata. B:Metadata identity must persist across renames and versions to preserve references. This does not establish the proposed intervention. The governing principle here is: Administrative metadata clarifies accountability and operational responsibilities for each asset. Apply it by: Record data owner, steward, custodian, and change authority within metadata. D:Metadata changes can alter interpretation of historical datasets and must be auditable. This does not establish the proposed intervention. The governing principle here is: Administrative metadata clarifies accountability and operational responsibilities for each asset. Apply it by: Record data owner, steward, custodian, and change authority within metadata.
Question 603A university runs disconnected governance, quality, and modeling projects without a shared roadmap or prioritization process. If this weakness continues, what is the most directly associated business or data risk? Reliable infrastructure can still deliver inconsistent information to clinicians and planners An expensive tool may be populated without improving any decision process Separate initiatives can produce incompatible definitions and redundant control work Unresolved ownership disputes may leave conflicting customer data in production ExplanationCorrect Answer C:Separate initiatives can produce incompatible definitions and redundant control work. This follows from the unresolved case facts. The preventive intervention is: Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities. The reason 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. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Separate initiatives can produce incompatible definitions and redundant control work. B:Business-driven data management establishes requirements and success measures before selecting supporting technology. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Separate initiatives can produce incompatible definitions and redundant control work. D: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: Separate initiatives can produce incompatible definitions and redundant control work.
Question 604A regional retailer produces product sales dashboards with different totals because one source counts returned orders and the other excludes them. A reviewer proposes: Define measurement semantics and reconciliation rules before asserting data quality failure. Which data-management principle best supports that choice? Data-quality measurement only helps when linked to accountable decisions and corrective action Aggregate quality scores can hide concentrated risks that matter to specific controls Quality monitoring frequency should reflect when an issue can cause material harm Data quality must be evaluated against a shared business definition and intended use ExplanationCorrect Answer D:Data quality must be evaluated against a shared business definition and intended use. This is why the recommended action fits the given facts: A regional retailer produces product sales dashboards with different totals because one source counts returned orders and the other excludes them. Verification would show: Documented test cases reproduce the same approved net-sales definition in both outputs.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 must be evaluated against a shared business definition and intended use. Apply it by: Define measurement semantics and reconciliation rules before asserting data quality failure. B: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 must be evaluated against a shared business definition and intended use. Apply it by: Define measurement semantics and reconciliation rules before asserting data quality failure. C:Quality monitoring frequency should reflect when an issue can cause material harm. This does not establish the proposed intervention. The governing principle here is: Data quality must be evaluated against a shared business definition and intended use. Apply it by: Define measurement semantics and reconciliation rules before asserting data quality failure.
Question 605A clinic uses free-text provider identifiers in multiple tables with inconsistent casing and whitespace. After the proposed change—Apply naming standards, domain definitions, and consistent key usage across the schema—which observation best verifies that this specific weakness has been addressed? Queries can join each order to its individual items without string parsing Plan change history reconstructs the active plan at each invoice event Foreign-key and code-format tests reconcile provider references without manual cleanup Stakeholders approve encounter definitions before logical attributes and physical tables are created ExplanationCorrect Answer C:Foreign-key and code-format tests reconcile provider references without manual cleanup. This is specific evidence for the intervention: Apply naming standards, domain definitions, and consistent key usage across the schema. The underlying principle is: Modeling standards improve consistency and make relationships unambiguous across implementations.Incorrect Answers A: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: Foreign-key and code-format tests reconcile provider references without manual cleanup. 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: Foreign-key and code-format tests reconcile provider references without manual cleanup. D:Conceptual modeling captures agreed business entities and relationships independent of storage technology. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Foreign-key and code-format tests reconcile provider references without manual cleanup.
Question 606A retailer's sales, loyalty, and returns platforms each define a different customer key and produce incompatible enterprise measures. If this weakness continues, what is the most directly associated business or data risk? Contradictory customer identities can spread through analytics and operational decisions Performance metrics may be wrong when delayed data is treated as on-time events Unannounced changes can break dependent fraud, servicing, and reporting systems A mistaken merge can contaminate clinical information across institutions ExplanationCorrect Answer A:Contradictory customer identities can spread through analytics and operational decisions. This follows from the unresolved case facts. The preventive intervention is: Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces. The reason is: Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems.Incorrect Answers B:Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Contradictory customer identities can spread through analytics and operational decisions. C:Interfaces are data products whose meaning and compatibility require coordinated lifecycle management. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Contradictory customer identities can spread through analytics and operational decisions. D:Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Contradictory customer identities can spread through analytics and operational decisions.
Question 607An airline's warehouse receives personally identifiable loyalty data that analysts copy freely into workbooks. A reviewer proposes: Provide controlled certified datasets, masking, and governed self-service distribution. Which data-management principle best supports that choice? Business-intelligence access needs stewardship and proportionate security even when data are curated Self-service analytics needs consistent metric meaning and approved reuse, not just dataset access Warehouse ETL or ELT processes should validate inputs before declaring data fit for analysis Analytical loading must preserve business event dates even when data arrives after the processing window ExplanationCorrect Answer A:Business-intelligence access needs stewardship and proportionate security even when data are curated. This is why the recommended action fits the given facts: An airline's warehouse receives personally identifiable loyalty data that analysts copy freely into workbooks. Verification would show: Authorized analysts can answer business questions without exporting unnecessary direct identifiers.Incorrect Answers B:Self-service analytics needs consistent metric meaning and approved reuse, not just dataset access. This does not establish the proposed intervention. The governing principle here is: Business-intelligence access needs stewardship and proportionate security even when data are curated. Apply it by: Provide controlled certified datasets, masking, and governed self-service distribution. C:Warehouse ETL or ELT processes should validate inputs before declaring data fit for analysis. This does not establish the proposed intervention. The governing principle here is: Business-intelligence access needs stewardship and proportionate security even when data are curated. Apply it by: Provide controlled certified datasets, masking, and governed self-service distribution. D:Analytical loading must preserve business event dates even when data arrives after the processing window. This does not establish the proposed intervention. The governing principle here is: Business-intelligence access needs stewardship and proportionate security even when data are curated. Apply it by: Provide controlled certified datasets, masking, and governed self-service distribution.
Question 608A healthcare network treats privacy, AI, and data ethics committees as separate bodies with inconsistent review decisions. A reviewer proposes: Define formal governance touchpoints, referral criteria, and a reconciled policy hierarchy. Which data-management principle best supports that choice? Related governance functions must coordinate decision rights where data-use risks cross disciplines Decision rights must provide a way to resolve conflicts that exceed individual domain authority Data governance is the exercise of authority and control over data-management decisions rather than a committee title alone A governance operating model should be proportional to organizational context and information value ExplanationCorrect Answer A:Related governance functions must coordinate decision rights where data-use risks cross disciplines. This is why the recommended action fits the given facts: A healthcare network treats privacy, AI, and data ethics committees as separate bodies with inconsistent review decisions. Verification would show: A cross-cutting AI data proposal receives one traceable set of compatible conditions.Incorrect Answers B:Decision rights must provide a way to resolve conflicts that exceed individual domain authority. This does not establish the proposed intervention. The governing principle here is: Related governance functions must coordinate decision rights where data-use risks cross disciplines. Apply it by: Define formal governance touchpoints, referral criteria, and a reconciled policy hierarchy. C:Data governance is the exercise of authority and control over data-management decisions rather than a committee title alone. This does not establish the proposed intervention. The governing principle here is: Related governance functions must coordinate decision rights where data-use risks cross disciplines. Apply it by: Define formal governance touchpoints, referral criteria, and a reconciled policy hierarchy. D:A governance operating model should be proportional to organizational context and information value. This does not establish the proposed intervention. The governing principle here is: Related governance functions must coordinate decision rights where data-use risks cross disciplines. Apply it by: Define formal governance touchpoints, referral criteria, and a reconciled policy hierarchy.
Question 609An online store's data quality team reports a hundred failed rules but no business user knows what action to take. If this weakness continues, what is the most directly associated business or data risk? Teams may make decisions from apparently conflicting metrics without knowing why Blanket rejection may interrupt operations unnecessarily or hide root causes Operational reports may refer to aircraft that do not exist Quality dashboards can accumulate warnings without improving real data ExplanationCorrect Answer D:Quality dashboards can accumulate warnings without improving real data. This follows from the unresolved case facts. The preventive intervention is: Assign each rule a business owner, alert severity, remediation workflow, and acceptance criteria. The reason is: Data-quality measurement only helps when linked to accountable decisions and corrective action.Incorrect Answers A:Data quality must be evaluated against a shared business definition and intended use. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Quality dashboards can accumulate warnings without improving real data. B: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: Quality dashboards can accumulate warnings without improving real data. C:Integrity concerns relationships and constraints among related data, not just value formatting. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Quality dashboards can accumulate warnings without improving real data.
Question 610A regional hospital plans database maintenance without testing failover application connections or transaction replay. After the proposed change—Exercise planned failover and verify connection, transaction, and data consistency behaviors—which observation best verifies that this specific weakness has been addressed? A test transaction is confirmed from a consistent view within the approved guarantee A failover drill keeps critical workflows within approved loss and outage limits Measured query latency improves after a justified index or query change A disaster exercise records end-to-end service availability within the approved RTO ExplanationCorrect Answer B:A failover drill keeps critical workflows within approved loss and outage limits. This is specific evidence for the intervention: Exercise planned failover and verify connection, transaction, and data consistency behaviors. The underlying principle 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. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A failover drill keeps critical workflows within approved loss and outage limits. C:Database performance depends on access paths and workload patterns as well as hardware resources. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A failover drill keeps critical workflows within approved loss and outage limits. D: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: A failover drill keeps critical workflows within approved loss and outage limits.