Question 340A hospital labels every analyst a data steward but no one performs dictionary reviews, issue triage, or definition stewardship. After the proposed change—Specify steward duties, capacity, workflows, and measures for the clinical data domain—which observation best verifies that this specific weakness has been addressed? Steward task queues show accepted definitions, investigated issues, and overdue escalations The contract, RACI, and supplier assurance reviews show ongoing internal oversight Ticket histories show accountable decisions, root-cause fixes, and prevention checks Board reports identify risk owners, significant breaches, and tracked remediation decisions ExplanationCorrect Answer A:Steward task queues show accepted definitions, investigated issues, and overdue escalations. This is specific evidence for the intervention: Specify steward duties, capacity, workflows, and measures for the clinical data domain. The underlying principle is: Stewardship requires assigned ongoing activities and accountability rather than an honorary designation.Incorrect Answers B:Delegating processing or custody does not remove the organization's accountability for its information. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Steward task queues show accepted definitions, investigated issues, and overdue escalations. C:Issue management needs joint business-technical ownership aligned with the cause of the data problem. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Steward task queues show accepted definitions, investigated issues, and overdue escalations. D:Data risk is an enterprise business accountability rather than exclusively an IT operational issue. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Steward task queues show accepted definitions, investigated issues, and overdue escalations.
Question 341A distributor's supplier master allows tax identifiers to be changed without verifying the legal entity relationship. After the proposed change—Apply governed identity change review with evidence and separate approval for high-impact attributes—which observation best verifies that this specific weakness has been addressed? A reviewed sample preserves distinct package sizes while merging genuine duplicates The master profile retains both address types and produces correct notices in test cases Tests retrieve the appropriate legal and billing parent for the same customer High-impact identity changes show verified documentation and approval audit trails ExplanationCorrect Answer D:High-impact identity changes show verified documentation and approval audit trails. This is specific evidence for the intervention: Apply governed identity change review with evidence and separate approval for high-impact attributes. The underlying principle is: Master-data updates can alter who a counterparty is, not just a descriptive field.Incorrect Answers A:Master-data matching must reflect the real-world entity granularity needed by the business. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: High-impact identity changes show verified documentation and approval audit trails. B:Master attributes must reflect business meaning; one entity may legitimately have multiple related attributes. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: High-impact identity changes show verified documentation and approval audit trails. C:Master-data relationships depend on business purpose and should not collapse distinct hierarchy semantics. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: High-impact identity changes show verified documentation and approval audit trails.
Question 342A public-health agency shares CSV files across partners without clarifying whether blank values mean absent, withheld, or not applicable. Which data-management action most directly corrects the identified problem? Enforce versioned interface contracts, schema validation, and explicit error quarantine Define shared semantic mappings and exchange validation for missing-value categories Define and validate conversion rules, reference rates, and monetary reconciliation controls Publish a typed interface contract with unambiguous time zone and date formats ExplanationCorrect Answer B:Define shared semantic mappings and exchange validation for missing-value categories. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Common file formats do not establish interoperable meaning unless data conventions are agreed. Practical verification is: Partner validation confirms distinct null reasons survive round-trip exchange.Incorrect Answers A:Interoperability depends on agreements about data structure and meaning, not merely transport success. That is relevant to a different intervention. For the stated situation, the required action is: Define shared semantic mappings and exchange validation for missing-value categories. The governing reason is: Common file formats do not establish interoperable meaning unless data conventions are agreed. C:Data movement across systems can change values unless transformations and reference context are controlled. That is relevant to a different intervention. For the stated situation, the required action is: Define shared semantic mappings and exchange validation for missing-value categories. The governing reason is: Common file formats do not establish interoperable meaning unless data conventions are agreed. D:Interoperability requires consistent semantics and explicit data types across heterogeneous systems. That is relevant to a different intervention. For the stated situation, the required action is: Define shared semantic mappings and exchange validation for missing-value categories. The governing reason is: Common file formats do not establish interoperable meaning unless data conventions are agreed.
Question 343A pharmaceutical supplier uses an ungoverned free-text unit-of-measure field for medication quantities. A reviewer proposes: Publish approved reference units, conversion rules, and validation at entry points. Which data-management principle best supports that choice? Reference data is a controlled dependency whose changes affect many consuming systems Reference data standardizes permitted categories and interpretation across business processes Master-data updates can alter who a counterparty is, not just a descriptive field Reference-data consistency is essential when quantities are interpreted across systems ExplanationCorrect Answer D:Reference-data consistency is essential when quantities are interpreted across systems. This is why the recommended action fits the given facts: A pharmaceutical supplier uses an ungoverned free-text unit-of-measure field for medication quantities. Verification would show: Sample transactions reject ambiguous units and reconcile standardized quantities.Incorrect Answers A:Reference data is a controlled dependency whose changes affect many consuming systems. This does not establish the proposed intervention. The governing principle here is: Reference-data consistency is essential when quantities are interpreted across systems. Apply it by: Publish approved reference units, conversion rules, and validation at entry points. B:Reference data standardizes permitted categories and interpretation across business processes. This does not establish the proposed intervention. The governing principle here is: Reference-data consistency is essential when quantities are interpreted across systems. Apply it by: Publish approved reference units, conversion rules, and validation at entry points. C:Master-data updates can alter who a counterparty is, not just a descriptive field. This does not establish the proposed intervention. The governing principle here is: Reference-data consistency is essential when quantities are interpreted across systems. Apply it by: Publish approved reference units, conversion rules, and validation at entry points.
Question 344A manufacturer asks a vendor to guarantee 100 percent accurate product descriptions despite changing specifications and multilingual suppliers. A reviewer proposes: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. Which data-management principle best supports that choice? Quality tolerances should reflect consequences and fitness for business purpose Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally Quality performance changes over time as sources and processes evolve Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims ExplanationCorrect Answer D:Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. This is why the recommended action fits the given facts: A manufacturer asks a vendor to guarantee 100 percent accurate product descriptions despite changing specifications and multilingual suppliers. Verification would show: A signed SLA specifies accuracy sampling, currency, exception tolerance, and corrective deadlines.Incorrect Answers A:Quality tolerances should reflect consequences and fitness for business purpose. This does not establish the proposed intervention. The governing principle here is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. Apply it by: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. 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: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. Apply it by: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. C:Quality performance changes over time as sources and processes evolve. This does not establish the proposed intervention. The governing principle here is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. Apply it by: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities.
Question 345An analytics engineer uses a star schema's fact table as the canonical operational system for editing customer addresses. A reviewer proposes: Separate transactional write models from dimensional analytical representations. Which data-management principle best supports that choice? Normalization reduces update anomalies when attributes belong to different entities Repeating values in one field impede first normal form and reliable relational operations Dimensional models optimize analytical measurement and are not automatically authoritative transaction stores Relational models should make changing cardinality and time-dependent associations explicit ExplanationCorrect Answer C:Dimensional models optimize analytical measurement and are not automatically authoritative transaction stores. This is why the recommended action fits the given facts: An analytics engineer uses a star schema's fact table as the canonical operational system for editing customer addresses. Verification would show: Address edits occur in the operational master and flow to analytics through approved integration.Incorrect Answers A:Normalization reduces update anomalies when attributes belong to different entities. This does not establish the proposed intervention. The governing principle here is: Dimensional models optimize analytical measurement and are not automatically authoritative transaction stores. Apply it by: Separate transactional write models from dimensional analytical representations. 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: Dimensional models optimize analytical measurement and are not automatically authoritative transaction stores. Apply it by: Separate transactional write models from dimensional analytical representations. D:Relational models should make changing cardinality and time-dependent associations explicit. This does not establish the proposed intervention. The governing principle here is: Dimensional models optimize analytical measurement and are not automatically authoritative transaction stores. Apply it by: Separate transactional write models from dimensional analytical representations.
Question 346An online marketplace uses a transaction fact table to represent current stock rather than a balance snapshot. A reviewer proposes: Choose a fact type appropriate to event flows versus measured states. Which data-management principle best supports that choice? Snapshot facts represent measured state at defined intervals and cannot be casually mixed with transactions Transactional facts and snapshot facts represent fundamentally different observation grains Dimensional modeling depends on one declared event or snapshot grain for each fact row Analytical loading must preserve business event dates even when data arrives after the processing window ExplanationCorrect Answer B:Transactional facts and snapshot facts represent fundamentally different observation grains. This is why the recommended action fits the given facts: An online marketplace uses a transaction fact table to represent current stock rather than a balance snapshot. Verification would show: Current inventory can be reconstructed or directly observed according to a documented snapshot policy.Incorrect Answers A:Snapshot facts represent measured state at defined intervals and cannot be casually mixed with transactions. This does not establish the proposed intervention. The governing principle here is: Transactional facts and snapshot facts represent fundamentally different observation grains. Apply it by: Choose a fact type appropriate to event flows versus measured states. C:Dimensional modeling depends on one declared event or snapshot grain for each fact row. This does not establish the proposed intervention. The governing principle here is: Transactional facts and snapshot facts represent fundamentally different observation grains. Apply it by: Choose a fact type appropriate to event flows versus measured states. 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: Transactional facts and snapshot facts represent fundamentally different observation grains. Apply it by: Choose a fact type appropriate to event flows versus measured states.
Question 347A bank keeps a product code in a loan table without a relationship constraint to the approved product catalog. After the proposed change—Model the product relationship and implement suitable referential integrity—which observation best verifies that this specific weakness has been addressed? Invalid product codes fail validation and valid loans join to existing product records Hierarchy tests reject cycles and return consistent account rollups Queries correctly represent policyholder roles and dates for shared policies Queries can join each order to its individual items without string parsing ExplanationCorrect Answer A:Invalid product codes fail validation and valid loans join to existing product records. This is specific evidence for the intervention: Model the product relationship and implement suitable referential integrity. The underlying principle is: Foreign keys express relationships and prevent references to nonexistent parents where enforced.Incorrect Answers B: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: Invalid product codes fail validation and valid loans join to existing product records. C:Many-to-many relationships usually require an explicit association in relational implementation. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Invalid product codes fail validation and valid loans join to existing product records. D: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: Invalid product codes fail validation and valid loans join to existing product records.
Question 348A healthcare network treats privacy, AI, and data ethics committees as separate bodies with inconsistent review decisions. If this weakness continues, what is the most directly associated business or data risk? Consensus paralysis can prevent standardization of shared institutional information Unresolved ownership disputes may leave conflicting customer data in production Projects can exploit gaps or conflicting approvals across oversight bodies Generic rules may be ignored because they do not address real work ExplanationCorrect Answer C:Projects can exploit gaps or conflicting approvals across oversight bodies. This follows from the unresolved case facts. The preventive intervention is: Define formal governance touchpoints, referral criteria, and a reconciled policy hierarchy. The reason is: Related governance functions must coordinate decision rights where data-use risks cross disciplines.Incorrect Answers A:Decision rights must provide a way to resolve conflicts that exceed individual domain authority. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Projects can exploit gaps or conflicting approvals across oversight bodies. B: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: Projects can exploit gaps or conflicting approvals across oversight bodies. D:A governance operating model should be proportional to organizational context and information value. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Projects can exploit gaps or conflicting approvals across oversight bodies.
Question 349An insurer stores many policyholders and many policies in one table with repeated combinations and no bridge entity. Which data-management action most directly corrects the identified problem? Model the many-to-many relationship with an associative entity and defined business attributes Represent contract-plan relationships with explicit validity periods and constraints Model and validate hierarchy constraints, including cycles and allowed depth Model the product relationship and implement suitable referential integrity ExplanationCorrect Answer A:Model the many-to-many relationship with an associative entity and defined business attributes. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Many-to-many relationships usually require an explicit association in relational implementation. Practical verification is: Queries correctly represent policyholder roles and dates for shared policies.Incorrect Answers B:Relational models should make changing cardinality and time-dependent associations explicit. That is relevant to a different intervention. For the stated situation, the required action is: Model the many-to-many relationship with an associative entity and defined business attributes. The governing reason is: Many-to-many relationships usually require an explicit association in relational implementation. 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 the many-to-many relationship with an associative entity and defined business attributes. The governing reason is: Many-to-many relationships usually require an explicit association in relational implementation. D:Foreign keys express relationships and prevent references to nonexistent parents where enforced. That is relevant to a different intervention. For the stated situation, the required action is: Model the many-to-many relationship with an associative entity and defined business attributes. The governing reason is: Many-to-many relationships usually require an explicit association in relational implementation.
Question 350A financial institution's metadata crawler collects access labels from a source but discards those labels during index publication. If this weakness continues, what is the most directly associated business or data risk? Cataloging may leak protected asset details to a wider audience Users may implement integrations based on outdated schemas A small source change may silently break many reports Catalog consumers may export identifiable customer data under an obsolete public label ExplanationCorrect Answer A:Cataloging may leak protected asset details to a wider audience. This follows from the unresolved case facts. The preventive intervention is: Propagate sensitivity classifications and authorized-use metadata to catalog search. The reason is: Metadata about security and permitted use must survive harvesting and downstream catalog distribution.Incorrect Answers B:Metadata quality has timeliness and accuracy requirements like the underlying data. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Cataloging may leak protected asset details to a wider audience. C:Metadata supports change impact when it links source fields to downstream consumers. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Cataloging may leak protected asset details to a wider audience. D:Classification metadata must reflect actual data content and sensitivity rather than static initial labels. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Cataloging may leak protected asset details to a wider audience.