Question 310A bank's fraud model receives yesterday's account status while new closures are recorded continuously. If this weakness continues, what is the most directly associated business or data risk? Delivery performance reports may omit late shipments and exaggerate success Management reports can contradict audited financial records Fraud decisions may use obsolete account state and produce unsafe outcomes Operational reports may refer to aircraft that do not exist ExplanationCorrect Answer C:Fraud decisions may use obsolete account state and produce unsafe outcomes. This follows from the unresolved case facts. The preventive intervention is: Define freshness expectations and monitor data currency at decision time. The reason is: Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone.Incorrect Answers A:Completeness describes the presence of required data, not its correctness or timely arrival. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Fraud decisions may use obsolete account state and produce unsafe outcomes. B:Consistency evaluates agreement among related representations under defined semantics. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Fraud decisions may use obsolete account state and produce unsafe outcomes. D: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: Fraud decisions may use obsolete account state and produce unsafe outcomes.
Question 311A logistics company creates a data lake that accepts raw GPS events without ownership, metadata, or retention rules. After the proposed change—Apply data classification, cataloging, lifecycle controls, and stewardship to the raw event lake—which observation best verifies that this specific weakness has been addressed? Sample GPS sets have owners, interpretable schemas, sensitivity tags, and enforced retention policies A replay containing late messages produces the expected time windows and documented corrections Retention tests remove expired records and approved analyses function without unnecessary direct identifiers Forecast reports and retention tests maintain approved free-space headroom ExplanationCorrect Answer A:Sample GPS sets have owners, interpretable schemas, sensitivity tags, and enforced retention policies. This is specific evidence for the intervention: Apply data classification, cataloging, lifecycle controls, and stewardship to the raw event lake. The underlying principle is: A scalable lake is not exempt from metadata and governance; unmanaged ingestion can create an unusable data swamp.Incorrect Answers B:Processing time can differ from the time a business event occurred, particularly for delayed distributed data. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sample GPS sets have owners, interpretable schemas, sensitivity tags, and enforced retention policies. C:Scale and analytical potential do not displace purpose limitation and protection of identifiable information. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sample GPS sets have owners, interpretable schemas, sensitivity tags, and enforced retention policies. D:Storage operations includes capacity forecasting and data lifecycle placement, not only adding disks after failure. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sample GPS sets have owners, interpretable schemas, sensitivity tags, and enforced retention policies.
Question 312A university governance council never adjudicates conflicts because each department has an informal veto over shared definitions. If this weakness continues, what is the most directly associated business or data risk? Unresolved ownership disputes may leave conflicting customer data in production Projects can exploit gaps or conflicting approvals across oversight bodies Policies may exist on paper while actual systems follow conflicting behavior Consensus paralysis can prevent standardization of shared institutional information ExplanationCorrect Answer D:Consensus paralysis can prevent standardization of shared institutional information. This follows from the unresolved case facts. The preventive intervention is: Define escalation and tie-breaking authority for cross-domain data decisions. The reason is: Decision rights must provide a way to resolve conflicts that exceed individual domain authority.Incorrect Answers A: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: Consensus paralysis can prevent standardization of shared institutional information. B:Related governance functions must coordinate decision rights where data-use risks cross disciplines. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Consensus paralysis can prevent standardization of shared institutional information. C:Governance authority needs an execution feedback loop from policy decision to operational compliance. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Consensus paralysis can prevent standardization of shared institutional information.
Question 313A retailer trains a customer targeting model on historic promotions that excluded some neighborhoods without considering the effect on underserved groups. After the proposed change—Assess representativeness and unfair impact, document mitigations, and monitor outcomes after launch—which observation best verifies that this specific weakness has been addressed? Governance records show fairness scenarios, approved guardrails, and customer-impact monitoring Impact testing compares outcomes across relevant cohorts and tracks investigated disparities A challenge test documents linkability reduction and enforceable vendor restrictions A change record shows consulted users, approved definitions, effective dates, and downstream tests ExplanationCorrect Answer B:Impact testing compares outcomes across relevant cohorts and tracks investigated disparities. This is specific evidence for the intervention: Assess representativeness and unfair impact, document mitigations, and monitor outcomes after launch. The underlying principle is: Ethical data use requires examining foreseeable unequal harm, not only technical predictive accuracy.Incorrect Answers A:A profitable or legally permitted data application can still be manipulative or socially harmful. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Impact testing compares outcomes across relevant cohorts and tracks investigated disparities. C:Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Impact testing compares outcomes across relevant cohorts and tracks investigated disparities. D:Governed information standards are versioned products that require managed change and communication. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Impact testing compares outcomes across relevant cohorts and tracks investigated disparities.
Question 314A charity adds a required donor phone column to a shared table without testing historical records or downstream forms. If this weakness continues, what is the most directly associated business or data risk? A required attribute change can break applications or make legacy records invalid Premature index proliferation can slow writes and obscure underlying model defects Billing may apply an obsolete or contradictory subscription plan Item-level updates and reconciliation may become error-prone ExplanationCorrect Answer A:A required attribute change can break applications or make legacy records invalid. This follows from the unresolved case facts. The preventive intervention is: Manage model evolution with compatibility analysis, migrations, and contract testing. The reason is: Logical schema changes affect existing data and dependent applications beyond new DDL syntax.Incorrect Answers B:Physical optimization should support validated business structure and observed workload needs. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A required attribute change can break applications or make legacy records invalid. C:Relational models should make changing cardinality and time-dependent associations explicit. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A required attribute change can break applications or make legacy records invalid. D:Repeating values in one field impede first normal form and reliable relational operations. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: A required attribute change can break applications or make legacy records invalid.
Question 315A warehouse loads daily orders by appending all source rows without detecting changed or deleted transactions. Which data-management action most directly corrects the identified problem? Use a controlled incremental load or CDC process with reconciliation and deletion handling Define and validate conversion rules, reference rates, and monetary reconciliation controls Capture integration lineage, transformation logic, and execution version with each load Use idempotent identifiers and deduplication controls across retry boundaries ExplanationCorrect Answer A:Use a controlled incremental load or CDC process with reconciliation and deletion handling. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Incremental integration must represent inserts, updates, and deletes consistently to avoid stale target state. Practical verification is: Matched source-target counts and replayed changes reproduce the expected order balances.Incorrect Answers B: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: Use a controlled incremental load or CDC process with reconciliation and deletion handling. The governing reason is: Incremental integration must represent inserts, updates, and deletes consistently to avoid stale target state. C:Reproducibility requires traceability through data movements and transformations. That is relevant to a different intervention. For the stated situation, the required action is: Use a controlled incremental load or CDC process with reconciliation and deletion handling. The governing reason is: Incremental integration must represent inserts, updates, and deletes consistently to avoid stale target state. D:Distributed integration cannot assume a failed acknowledgment means an operation never occurred. That is relevant to a different intervention. For the stated situation, the required action is: Use a controlled incremental load or CDC process with reconciliation and deletion handling. The governing reason is: Incremental integration must represent inserts, updates, and deletes consistently to avoid stale target state.
Question 316A large retailer's product master merges different packaging sizes because the matching algorithm ignores unit quantity. Which data-management action most directly corrects the identified problem? Introduce confidence thresholds and human review for ambiguous identity matches Define business identity rules that include product variant, pack size, and commercial attributes Apply governed identity change review with evidence and separate approval for high-impact attributes Implement standardized identity matching, steward review, and controlled golden-record creation ExplanationCorrect Answer B:Define business identity rules that include product variant, pack size, and commercial attributes. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Master-data matching must reflect the real-world entity granularity needed by the business. Practical verification is: A reviewed sample preserves distinct package sizes while merging genuine duplicates.Incorrect Answers A:False-positive identity matches can be more harmful than leaving records separate pending investigation. That is relevant to a different intervention. For the stated situation, the required action is: Define business identity rules that include product variant, pack size, and commercial attributes. The governing reason is: Master-data matching must reflect the real-world entity granularity needed by the business. C:Master-data updates can alter who a counterparty is, not just a descriptive field. That is relevant to a different intervention. For the stated situation, the required action is: Define business identity rules that include product variant, pack size, and commercial attributes. The governing reason is: Master-data matching must reflect the real-world entity granularity needed by the business. D:Master data management reconciles business entities across systems rather than simply copying records. That is relevant to a different intervention. For the stated situation, the required action is: Define business identity rules that include product variant, pack size, and commercial attributes. The governing reason is: Master-data matching must reflect the real-world entity granularity needed by the business.
Question 317An airline's warehouse receives personally identifiable loyalty data that analysts copy freely into workbooks. Which data-management action most directly corrects the identified problem? Establish a governed semantic definition and designate authoritative measures Provide controlled certified datasets, masking, and governed self-service distribution Apply staging quality gates and deduplication ahead of publishing certified facts Design late-arriving fact handling with controlled period adjustments and auditability ExplanationCorrect Answer B:Provide controlled certified datasets, masking, and governed self-service distribution. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Business-intelligence access needs stewardship and proportionate security even when data are curated. Practical verification is: Authorized analysts can answer business questions without exporting unnecessary direct identifiers.Incorrect Answers A:Self-service analytics needs consistent metric meaning and approved reuse, not just dataset access. That is relevant to a different intervention. For the stated situation, the required action is: Provide controlled certified datasets, masking, and governed self-service distribution. The governing reason is: Business-intelligence access needs stewardship and proportionate security even when data are curated. C:Warehouse ETL or ELT processes should validate inputs before declaring data fit for analysis. That is relevant to a different intervention. For the stated situation, the required action is: Provide controlled certified datasets, masking, and governed self-service distribution. The governing reason is: Business-intelligence access needs stewardship and proportionate security even when data are curated. D: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: Provide controlled certified datasets, masking, and governed self-service distribution. The governing reason is: Business-intelligence access needs stewardship and proportionate security even when data are curated.
Question 318A payments warehouse has adequate storage but dashboard queries scan massive raw event tables for each refresh. After the proposed change—Use appropriate dimensional structures, preaggregation, partitions, or incremental materialization based on query plans—which observation best verifies that this specific weakness has been addressed? Quarterly figures reconcile with daily transactions and detail drill-through functions correctly A sample order reconciles line totals without duplicating revenue after joins Query plans and refresh times improve while detailed totals still reconcile Daily total paid claims agree with approved ledger figures within tolerances ExplanationCorrect Answer C:Query plans and refresh times improve while detailed totals still reconcile. This is specific evidence for the intervention: Use appropriate dimensional structures, preaggregation, partitions, or incremental materialization based on query plans. The underlying principle is: Warehouse performance depends on physical design matched to analytical workload and query patterns.Incorrect Answers A:Aggregations accelerate queries but must preserve required analytical granularity. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Query plans and refresh times improve while detailed totals still reconcile. B:Dimensional modeling depends on one declared event or snapshot grain for each fact row. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Query plans and refresh times improve while detailed totals still reconcile. D:Analytical trust requires evidence that transformed facts reconcile to authoritative business systems. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Query plans and refresh times improve while detailed totals still reconcile.
Question 319A logistics model stores all worldwide addresses as a fixed set of domestic state and ZIP fields. A reviewer proposes: Use a flexible address structure and validated country-specific components where required. Which data-management principle best supports that choice? Physical optimization should support validated business structure and observed workload needs Conceptual business data should not be constrained by one region's physical conventions Conceptual modeling captures agreed business entities and relationships independent of storage technology Cardinality and business roles determine the relationships needed to represent reality ExplanationCorrect Answer B:Conceptual business data should not be constrained by one region's physical conventions. This is why the recommended action fits the given facts: A logistics model stores all worldwide addresses as a fixed set of domestic state and ZIP fields. Verification would show: Test addresses from multiple countries are preserved without fabricated states or truncated postal codes.Incorrect Answers A:Physical optimization should support validated business structure and observed workload needs. This does not establish the proposed intervention. The governing principle here is: Conceptual business data should not be constrained by one region's physical conventions. Apply it by: Use a flexible address structure and validated country-specific components where required. C:Conceptual modeling captures agreed business entities and relationships independent of storage technology. This does not establish the proposed intervention. The governing principle here is: Conceptual business data should not be constrained by one region's physical conventions. Apply it by: Use a flexible address structure and validated country-specific components where required. D:Cardinality and business roles determine the relationships needed to represent reality. This does not establish the proposed intervention. The governing principle here is: Conceptual business data should not be constrained by one region's physical conventions. Apply it by: Use a flexible address structure and validated country-specific components where required.
Question 320A multinational logistics firm maps shipping events into its enterprise model without distinguishing delivery time from event-recording time. 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 Cross-company metrics and integrations can silently combine non-equivalent statuses Source changes can break numerous downstream reports simultaneously ExplanationCorrect Answer B:Performance metrics may be wrong when delayed data is treated as on-time events. This follows from the unresolved case facts. The preventive intervention is: Define clear event and effective-time semantics in the canonical architecture. The reason is: Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them.Incorrect Answers A:Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Performance metrics may be wrong when delayed data is treated as on-time events. C:A canonical enterprise definition must distinguish business meaning from different implementation representations. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Performance metrics may be wrong when delayed data is treated as on-time events. D:Architecture separates concerns so capture, transformation, and consumption can evolve without uncontrolled coupling. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Performance metrics may be wrong when delayed data is treated as on-time events.