Question 60A monthly inventory report mixes beginning-of-month balances with end-of-month quantities in one fact table. If this weakness continues, what is the most directly associated business or data risk? Analytics may mistake historical stock movements for current quantity on hand Revenue dashboards may systematically overstate sales Operational credit decisions may rely on material outdated information Inventory trends may reflect differing measurement dates instead of actual changes ExplanationCorrect Answer D:Inventory trends may reflect differing measurement dates instead of actual changes. This follows from the unresolved case facts. The preventive intervention is: Use an explicit periodic snapshot grain and consistent observation dates. The reason is: Snapshot facts represent measured state at defined intervals and cannot be casually mixed with transactions.Incorrect Answers A:Transactional facts and snapshot facts represent fundamentally different observation grains. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Inventory trends may reflect differing measurement dates instead of actual changes. B:Dimensional modeling depends on one declared event or snapshot grain for each fact row. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Inventory trends may reflect differing measurement dates instead of actual changes. C:A warehouse optimized for periodic reporting may not satisfy operational real-time use cases. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Inventory trends may reflect differing measurement dates instead of actual changes.
Question 61A retailer's loyalty and e-commerce systems create duplicate customer records with different phone formatting. Which data-management action most directly corrects the identified problem? Implement standardized identity matching, steward review, and controlled golden-record creation Implement tracked master-data distribution with acknowledgments and reconciliation Define business identity rules that include product variant, pack size, and commercial attributes Create attribute-specific survivorship rules based on source authority, recency, and clinical validation ExplanationCorrect Answer A:Implement standardized identity matching, steward review, and controlled golden-record creation. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Master data management reconciles business entities across systems rather than simply copying records. Practical verification is: A reviewed sample shows legitimate merges and retained source provenance.Incorrect Answers B:Creating a golden record does not ensure that consuming applications have adopted the correct value. That is relevant to a different intervention. For the stated situation, the required action is: Implement standardized identity matching, steward review, and controlled golden-record creation. The governing reason is: Master data management reconciles business entities across systems rather than simply copying records. C:Master-data matching must reflect the real-world entity granularity needed by the business. That is relevant to a different intervention. For the stated situation, the required action is: Implement standardized identity matching, steward review, and controlled golden-record creation. The governing reason is: Master data management reconciles business entities across systems rather than simply copying records. D:Golden-record survivorship should reflect the reliability and meaning of each attribute, not one universal timestamp rule. That is relevant to a different intervention. For the stated situation, the required action is: Implement standardized identity matching, steward review, and controlled golden-record creation. The governing reason is: Master data management reconciles business entities across systems rather than simply copying records.
Question 62A hospital creates a data mart for each new team without shared modeling standards or lineage. Which data-management action most directly corrects the identified problem? Create conformed dimension definitions and controlled mapping across analytical domains Design late-arriving fact handling with controlled period adjustments and auditability Define governed business measures and semantic transformations before dashboard consumption Design marts against conformed enterprise definitions and trace their upstream dependencies ExplanationCorrect Answer D:Design marts against conformed enterprise definitions and trace their upstream dependencies. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Data marts should serve focused needs without creating irreconcilable information silos. Practical verification is: Common measures reconcile across department marts and source lineage is recorded.Incorrect Answers A:Conformed dimensions make measures comparable across subject-area marts using shared business meaning. That is relevant to a different intervention. For the stated situation, the required action is: Design marts against conformed enterprise definitions and trace their upstream dependencies. The governing reason is: Data marts should serve focused needs without creating irreconcilable information silos. B:Analytical loading must preserve business event dates even when data arrives after the processing window. That is relevant to a different intervention. For the stated situation, the required action is: Design marts against conformed enterprise definitions and trace their upstream dependencies. The governing reason is: Data marts should serve focused needs without creating irreconcilable information silos. C:A semantic layer separates raw events from consistently defined business metrics. That is relevant to a different intervention. For the stated situation, the required action is: Design marts against conformed enterprise definitions and trace their upstream dependencies. The governing reason is: Data marts should serve focused needs without creating irreconcilable information silos.
Question 63A financial model allows one invoice line to reference an arbitrary tax category with no effective-date context. After the proposed change—Represent tax-code relationships and applicable effective periods explicitly—which observation best verifies that this specific weakness has been addressed? Plan change history reconstructs the active plan at each invoice event Historical invoice replays select the tax category valid for the transaction date Historical invoices calculate using rates effective on the invoice dates Hierarchy tests reject cycles and return consistent account rollups ExplanationCorrect Answer B:Historical invoice replays select the tax category valid for the transaction date. This is specific evidence for the intervention: Represent tax-code relationships and applicable effective periods explicitly. The underlying principle is: Meaningful relational models include temporal reference constraints when business rules change over time.Incorrect Answers A: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: Historical invoice replays select the tax category valid for the transaction date. C: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: Historical invoice replays select the tax category valid for the transaction date. 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: Historical invoice replays select the tax category valid for the transaction date.
Question 64A media agency uses employee personal drives for corporate content even though teams require controlled collaboration and exit processes. After the proposed change—Move enterprise records into governed repositories with role-based access and lifecycle ownership—which observation best verifies that this specific weakness has been addressed? A departing employee's materials remain available through authorized shared ownership after offboarding Restricted users cannot see protected titles, snippets, or document contents in search results A tested export reconciles selected custodians and periods to retention and hold logs Users can identify the current approved revision and audit prior approvals and changes ExplanationCorrect Answer A:A departing employee's materials remain available through authorized shared ownership after offboarding. This is specific evidence for the intervention: Move enterprise records into governed repositories with role-based access and lifecycle ownership. The underlying principle is: Unmanaged collaboration channels create custody gaps when employees leave or access changes.Incorrect Answers B:Findability should not bypass information classification and need-to-know access rules. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A departing employee's materials remain available through authorized shared ownership after offboarding. C:Discovery depends on records authenticity, provenance, completeness, and disposition evidence. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A departing employee's materials remain available through authorized shared ownership after offboarding. D:Content management must distinguish authoritative controlled records from working drafts. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A departing employee's materials remain available through authorized shared ownership after offboarding.
Question 65A hospital restores a backup successfully but requires two days before applications can use the database again. If this weakness continues, what is the most directly associated business or data risk? A technically valid backup can still leave critical care services unavailable too long An engine upgrade may make critical applications unable to connect The organization may lose more recent orders than business leaders accepted The organization may discover during an incident that its backups are unusable ExplanationCorrect Answer A:A technically valid backup can still leave critical care services unavailable too long. This follows from the unresolved case facts. The preventive intervention is: Test and optimize the full recovery process against an approved recovery-time objective. The reason is: RTO concerns elapsed service restoration time and includes dependencies beyond the file restore.Incorrect Answers B:Database operations must control changes that can affect service compatibility and recoverability. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A technically valid backup can still leave critical care services unavailable too long. C:RPO describes tolerated data loss in time and is distinct from how long restoration takes. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A technically valid backup can still leave critical care services unavailable too long. D:Backup completion is not evidence that a usable recovery can be executed. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A technically valid backup can still leave critical care services unavailable too long.
Question 66A conglomerate's data owners approve new sensitive-data sharing through informal messages without any purpose or recipient controls. A reviewer proposes: Establish documented data-sharing approvals, purpose limitations, recipient conditions, and auditability. Which data-management principle best supports that choice? Data access decisions require accountable authorization and appropriate use restrictions beyond technical connectivity A data owner makes business decisions while a data custodian implements technical safeguards and operations Issue management needs joint business-technical ownership aligned with the cause of the data problem Policy exceptions need documented risk decisions and periodic review to avoid silently defeating enterprise standards ExplanationCorrect Answer A:Data access decisions require accountable authorization and appropriate use restrictions beyond technical connectivity. This is why the recommended action fits the given facts: A conglomerate's data owners approve new sensitive-data sharing through informal messages without any purpose or recipient controls. Verification would show: A sample exchange has a signed purpose, recipient permissions, retention terms, and logged access.Incorrect Answers B:A data owner makes business decisions while a data custodian implements technical safeguards and operations. This does not establish the proposed intervention. The governing principle here is: Data access decisions require accountable authorization and appropriate use restrictions beyond technical connectivity. Apply it by: Establish documented data-sharing approvals, purpose limitations, recipient conditions, and auditability. C:Issue management needs joint business-technical ownership aligned with the cause of the data problem. This does not establish the proposed intervention. The governing principle here is: Data access decisions require accountable authorization and appropriate use restrictions beyond technical connectivity. Apply it by: Establish documented data-sharing approvals, purpose limitations, recipient conditions, and auditability. D:Policy exceptions need documented risk decisions and periodic review to avoid silently defeating enterprise standards. This does not establish the proposed intervention. The governing principle here is: Data access decisions require accountable authorization and appropriate use restrictions beyond technical connectivity. Apply it by: Establish documented data-sharing approvals, purpose limitations, recipient conditions, and auditability.
Question 67A pharmacy chain maintains a data policy inventory but has no process to assess changes to definitions requested by new applications. If this weakness continues, what is the most directly associated business or data risk? Unannounced changes can break regulatory extracts and consumer interpretations Temporary waivers can become uncontrolled permanent exposure paths One local optimization may silently corrupt other teams' operations Misinterpreted terms can distort loss reserving and management reporting ExplanationCorrect Answer A:Unannounced changes can break regulatory extracts and consumer interpretations. This follows from the unresolved case facts. The preventive intervention is: Implement controlled policy and definition change requests with stakeholder impact analysis. The reason is: Governed information standards are versioned products that require managed change and communication.Incorrect Answers B:Policy exceptions need documented risk decisions and periodic review to avoid silently defeating enterprise standards. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Unannounced changes can break regulatory extracts and consumer interpretations. C:Shared data assets have multiple stakeholders whose requirements must be considered together. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Unannounced changes can break regulatory extracts and consumer interpretations. D:A business glossary should resolve semantic ambiguity rather than assume identical labels imply identical meaning. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Unannounced changes can break regulatory extracts and consumer interpretations.
Question 68An airport's data-quality rule accepts every flight with an aircraft identifier even when that identifier does not exist in the fleet registry. Which data-management action most directly corrects the identified problem? Assign each rule a business owner, alert severity, remediation workflow, and acceptance criteria Add referential integrity and approved-master cross-reference checks Define measurement semantics and reconciliation rules before asserting data quality failure Segment quality measures by source, domain, and criticality instead of averaging away important failures ExplanationCorrect Answer B:Add referential integrity and approved-master cross-reference checks. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Integrity concerns relationships and constraints among related data, not just value formatting. Practical verification is: Invalid aircraft references trigger traceable exceptions and valid flights reconcile to the fleet master.Incorrect Answers A:Data-quality measurement only helps when linked to accountable decisions and corrective action. That is relevant to a different intervention. For the stated situation, the required action is: Add referential integrity and approved-master cross-reference checks. The governing reason is: Integrity concerns relationships and constraints among related data, not just value formatting. C:Data quality must be evaluated against a shared business definition and intended use. That is relevant to a different intervention. For the stated situation, the required action is: Add referential integrity and approved-master cross-reference checks. The governing reason is: Integrity concerns relationships and constraints among related data, not just value formatting. D:Aggregate quality scores can hide concentrated risks that matter to specific controls. That is relevant to a different intervention. For the stated situation, the required action is: Add referential integrity and approved-master cross-reference checks. The governing reason is: Integrity concerns relationships and constraints among related data, not just value formatting.
Question 69A retail company allows a vendor to download entire customer datasets when the vendor needs only aggregated campaign counts. A reviewer proposes: Minimize shared fields and define approved purposes and recipient restrictions. Which data-management principle best supports that choice? Encryption does not reduce exposure when unauthorized users can access the effective key Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies Security classification should reflect current information content and potential harm Security and privacy controls should reduce unnecessary exposure at data exchange boundaries ExplanationCorrect Answer D:Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. This is why the recommended action fits the given facts: A retail company allows a vendor to download entire customer datasets when the vendor needs only aggregated campaign counts. Verification would show: The vendor receives only approved aggregates and controlled queries cannot reveal individual rows.Incorrect Answers A:Encryption does not reduce exposure when unauthorized users can access the effective key. This does not establish the proposed intervention. The governing principle here is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. Apply it by: Minimize shared fields and define approved purposes and recipient restrictions. B:Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. This does not establish the proposed intervention. The governing principle here is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. Apply it by: Minimize shared fields and define approved purposes and recipient restrictions. C:Security classification should reflect current information content and potential harm. This does not establish the proposed intervention. The governing principle here is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. Apply it by: Minimize shared fields and define approved purposes and recipient restrictions.
Question 70A city transit program specifies a new data platform without showing which routes carry live tap-on and ticketing events. After the proposed change—Document data flows, transformations, handoffs, and consumers in the current and proposed architecture—which observation best verifies that this specific weakness has been addressed? The transition plan traces each policy and claim feed to a current owner and target destination Reviewed diagrams show source-to-consumer paths, transformation checkpoints, and failure boundaries An end-to-end reference design shows contract ownership, lineage, and recovery for each layer Sample cross-border shipments preserve event-time, observation-time, and correction histories ExplanationCorrect Answer B:Reviewed diagrams show source-to-consumer paths, transformation checkpoints, and failure boundaries. This is specific evidence for the intervention: Document data flows, transformations, handoffs, and consumers in the current and proposed architecture. The underlying principle is: Data-flow architecture makes movement and dependencies visible for operational and governance design.Incorrect Answers A:Transition architecture requires a credible current state to identify change impact and migration constraints. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Reviewed diagrams show source-to-consumer paths, transformation checkpoints, and failure boundaries. C:Architecture separates concerns so capture, transformation, and consumption can evolve without uncontrolled coupling. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Reviewed diagrams show source-to-consumer paths, transformation checkpoints, and failure boundaries. D:Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Reviewed diagrams show source-to-consumer paths, transformation checkpoints, and failure boundaries.