Question 620A consumer-products company mandates central approval of every low-risk reference code update, creating months of delay. If this weakness continues, what is the most directly associated business or data risk? Generic rules may be ignored because they do not address real work Excessive centralization can drive ungoverned shadow spreadsheets and workarounds Temporary waivers can become uncontrolled permanent exposure paths Unresolved ownership disputes may leave conflicting customer data in production ExplanationCorrect Answer B:Excessive centralization can drive ungoverned shadow spreadsheets and workarounds. This follows from the unresolved case facts. The preventive intervention is: Use a federated governance model with enterprise guardrails and delegated domain decisions. The reason is: Governance authority can be distributed within common policies while retaining enterprise oversight.Incorrect Answers A: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: Excessive centralization can drive ungoverned shadow spreadsheets and workarounds. C: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: Excessive centralization can drive ungoverned shadow spreadsheets and workarounds. 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: Excessive centralization can drive ungoverned shadow spreadsheets and workarounds.
Question 621A CRM publishes changes to an analytics API without informing consumers of field removals. Which data-management action most directly corrects the identified problem? Enforce versioned interface contracts, schema validation, and explicit error quarantine Introduce timeouts, bounded retries, circuit-breaker behavior, and safe fallback decisions Introduce interface change governance with compatibility windows and consumer notification Design consumers for at-least-once delivery using deduplication or safe state transitions ExplanationCorrect Answer C:Introduce interface change governance with compatibility windows and consumer notification. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Data integration is a managed service relationship with version and backward-compatibility obligations. Practical verification is: Contract tests run against supported versions and consumer teams acknowledge retirement dates.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: Introduce interface change governance with compatibility windows and consumer notification. The governing reason is: Data integration is a managed service relationship with version and backward-compatibility obligations. B:Integration design must manage availability coupling and failure propagation between services. That is relevant to a different intervention. For the stated situation, the required action is: Introduce interface change governance with compatibility windows and consumer notification. The governing reason is: Data integration is a managed service relationship with version and backward-compatibility obligations. D:A message broker's reliable delivery does not guarantee exactly-once business effects by itself. That is relevant to a different intervention. For the stated situation, the required action is: Introduce interface change governance with compatibility windows and consumer notification. The governing reason is: Data integration is a managed service relationship with version and backward-compatibility obligations.
Question 622A manufacturing BI team preaggregates sales by quarter but analysts need to examine daily price promotions. Which data-management action most directly corrects the identified problem? Apply approved row-level or column-level controls and test permitted report access Use appropriate dimensional structures, preaggregation, partitions, or incremental materialization based on query plans Define the fact grain precisely and test relationship cardinality before aggregating measures Design aggregate tables with drill-through to the supported detail grain ExplanationCorrect Answer D:Design aggregate tables with drill-through to the supported detail grain. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Aggregations accelerate queries but must preserve required analytical granularity. Practical verification is: Quarterly figures reconcile with daily transactions and detail drill-through functions correctly.Incorrect Answers A:Analytical delivery must preserve data security constraints across semantic layers and reports. That is relevant to a different intervention. For the stated situation, the required action is: Design aggregate tables with drill-through to the supported detail grain. The governing reason is: Aggregations accelerate queries but must preserve required analytical granularity. B:Warehouse performance depends on physical design matched to analytical workload and query patterns. That is relevant to a different intervention. For the stated situation, the required action is: Design aggregate tables with drill-through to the supported detail grain. The governing reason is: Aggregations accelerate queries but must preserve required analytical granularity. C:Dimensional modeling depends on one declared event or snapshot grain for each fact row. That is relevant to a different intervention. For the stated situation, the required action is: Design aggregate tables with drill-through to the supported detail grain. The governing reason is: Aggregations accelerate queries but must preserve required analytical granularity.
Question 623A finance team replaces monthly batch extracts with streaming updates but fails to assess dependent reconciliations and cutoff controls. After the proposed change—Evaluate transition impacts on downstream reporting cadence, controls, and reconciliation semantics—which observation best verifies that this specific weakness has been addressed? Architecture mappings reconcile customer identifiers across the three systems and shared reports The transition plan traces each policy and claim feed to a current owner and target destination Parallel-run evidence reconciles reporting periods, late entries, and settlement totals An independent client consumes test exports and a documented exit path retrieves critical data ExplanationCorrect Answer C:Parallel-run evidence reconciles reporting periods, late entries, and settlement totals. This is specific evidence for the intervention: Evaluate transition impacts on downstream reporting cadence, controls, and reconciliation semantics. The underlying principle is: Architecture changes must preserve required business capabilities and observable data behavior across consumers.Incorrect Answers A:Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Parallel-run evidence reconciles reporting periods, late entries, and settlement totals. B: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: Parallel-run evidence reconciles reporting periods, late entries, and settlement totals. D:Architecture standards should reduce unnecessary technology lock-in and enable reliable information exchange. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Parallel-run evidence reconciles reporting periods, late entries, and settlement totals.
Question 624A global insurer publishes a central country-code table but does not maintain retired codes or effective dates. A reviewer proposes: Version reference data with validity periods and controlled code retirement. 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 Reference values change over time; consumers need the version applicable to their business event Master attributes must reflect business meaning; one entity may legitimately have multiple related attributes ExplanationCorrect Answer C:Reference values change over time; consumers need the version applicable to their business event. This is why the recommended action fits the given facts: A global insurer publishes a central country-code table but does not maintain retired codes or effective dates. Verification would show: Historical policy tests interpret country codes using the correct effective dates.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 values change over time; consumers need the version applicable to their business event. Apply it by: Version reference data with validity periods and controlled code retirement. B:Reference data standardizes permitted categories and interpretation across business processes. This does not establish the proposed intervention. The governing principle here is: Reference values change over time; consumers need the version applicable to their business event. Apply it by: Version reference data with validity periods and controlled code retirement. D: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: Reference values change over time; consumers need the version applicable to their business event. Apply it by: Version reference data with validity periods and controlled code retirement.
Question 625A manufacturer discovers disk usage is growing unpredictably because a log table has no archive or capacity forecast. After the proposed change—Monitor growth, apply lifecycle storage tiers, and plan capacity ahead of exhaustion—which observation best verifies that this specific weakness has been addressed? Forecast reports and retention tests maintain approved free-space headroom Sample archived records can be retrieved within agreed service times and costs Measured query latency improves after a justified index or query change Preproduction integration tests pass and a rollback rehearsal meets service targets ExplanationCorrect Answer A:Forecast reports and retention tests maintain approved free-space headroom. This is specific evidence for the intervention: Monitor growth, apply lifecycle storage tiers, and plan capacity ahead of exhaustion. The underlying principle is: Storage operations includes capacity forecasting and data lifecycle placement, not only adding disks after failure.Incorrect Answers B:Storage tiers trade access speed and cost; decisions should follow information lifecycle requirements. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Forecast reports and retention tests maintain approved free-space headroom. 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: Forecast reports and retention tests maintain approved free-space headroom. D:Database operations must control changes that can affect service compatibility and recoverability. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Forecast reports and retention tests maintain approved free-space headroom.
Question 626A marketplace treats a nightly copy from its catalog to the recommendation platform as a live consistent view. After the proposed change—Set documented freshness service levels and monitor replication lag against consumer needs—which observation best verifies that this specific weakness has been addressed? A replay test leaves one shipment lifecycle and a recorded duplicate suppression event Lag alerts and sample source-target comparisons meet approved freshness thresholds Contract tests run against supported versions and consumer teams acknowledge retirement dates A tested crosswalk matches verified identities and flags uncertain name collisions ExplanationCorrect Answer B:Lag alerts and sample source-target comparisons meet approved freshness thresholds. This is specific evidence for the intervention: Set documented freshness service levels and monitor replication lag against consumer needs. The underlying principle is: Replication creates a copy with measurable latency and does not automatically provide real-time consistency.Incorrect Answers A:A message broker's reliable delivery does not guarantee exactly-once business effects by itself. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Lag alerts and sample source-target comparisons meet approved freshness thresholds. C:Data integration is a managed service relationship with version and backward-compatibility obligations. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Lag alerts and sample source-target comparisons meet approved freshness thresholds. D:Data joining needs controlled entity resolution when operational identifiers differ or are ambiguous. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Lag alerts and sample source-target comparisons meet approved freshness thresholds.
Question 627A risk-analytics program cannot tell whether a data definition or its owner changed after a regulatory update. A reviewer proposes: Maintain an auditable metadata change log with ownership, approval, and effective-date history. Which data-management principle best supports that choice? Metadata changes can alter interpretation of historical datasets and must be auditable Metadata supports change impact when it links source fields to downstream consumers Administrative metadata clarifies accountability and operational responsibilities for each asset Metadata governance supports accountability by recording who changed meanings and when ExplanationCorrect Answer D:Metadata governance supports accountability by recording who changed meanings and when. This is why the recommended action fits the given facts: A risk-analytics program cannot tell whether a data definition or its owner changed after a regulatory update. Verification would show: A regulatory-change audit links revised definitions, approvers, and downstream notification dates.Incorrect Answers A:Metadata changes can alter interpretation of historical datasets and must be auditable. This does not establish the proposed intervention. The governing principle here is: Metadata governance supports accountability by recording who changed meanings and when. Apply it by: Maintain an auditable metadata change log with ownership, approval, and effective-date history. B:Metadata supports change impact when it links source fields to downstream consumers. This does not establish the proposed intervention. The governing principle here is: Metadata governance supports accountability by recording who changed meanings and when. Apply it by: Maintain an auditable metadata change log with ownership, approval, and effective-date history. C:Administrative metadata clarifies accountability and operational responsibilities for each asset. This does not establish the proposed intervention. The governing principle here is: Metadata governance supports accountability by recording who changed meanings and when. Apply it by: Maintain an auditable metadata change log with ownership, approval, and effective-date history.
Question 628A shared patient identity service uses one global identifier but never records when source hospital identifiers are merged or separated. A reviewer proposes: Model identity relationships and provenance explicitly and maintain reversible crosswalk decisions. Which data-management principle best supports that choice? Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems Conceptual, logical, and physical representations answer different architecture and modeling questions Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them ExplanationCorrect Answer A:Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key. This is why the recommended action fits the given facts: A shared patient identity service uses one global identifier but never records when source hospital identifiers are merged or separated. Verification would show: Reconciliation tests trace merges and splits back to source records without losing history.Incorrect Answers B:Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. This does not establish the proposed intervention. The governing principle here is: Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key. Apply it by: Model identity relationships and provenance explicitly and maintain reversible crosswalk decisions. C:Conceptual, logical, and physical representations answer different architecture and modeling questions. This does not establish the proposed intervention. The governing principle here is: Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key. Apply it by: Model identity relationships and provenance explicitly and maintain reversible crosswalk decisions. D:Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them. This does not establish the proposed intervention. The governing principle here is: Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key. Apply it by: Model identity relationships and provenance explicitly and maintain reversible crosswalk decisions.
Question 629A nonprofit logs every database query indefinitely in a shared analytics bucket containing personal identifiers. After the proposed change—Limit audit-log access, retention, and sensitive content while keeping required security evidence—which observation best verifies that this specific weakness has been addressed? Audit sampling meets investigation needs with restricted readers and controlled retention Tampering attempts are blocked or detected and audit provenance is independently verifiable A new identifier field triggers classification, permissions, and export policy review Expired items are removed from active and backup handling under approved documented schedules ExplanationCorrect Answer A:Audit sampling meets investigation needs with restricted readers and controlled retention. This is specific evidence for the intervention: Limit audit-log access, retention, and sensitive content while keeping required security evidence. The underlying principle is: Security monitoring itself can create new repositories of sensitive information that need protection.Incorrect Answers B:An audit trail must have integrity and accountability to support investigation and oversight. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Audit sampling meets investigation needs with restricted readers and controlled retention. C:Security classification should reflect current information content and potential harm. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Audit sampling meets investigation needs with restricted readers and controlled retention. D:Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Audit sampling meets investigation needs with restricted readers and controlled retention.
Question 630An airport's data-quality rule accepts every flight with an aircraft identifier even when that identifier does not exist in the fleet registry. If this weakness continues, what is the most directly associated business or data risk? Quality dashboards can accumulate warnings without improving real data Operational reports may refer to aircraft that do not exist Teams may make decisions from apparently conflicting metrics without knowing why Critical financial-crime gaps may be invisible behind healthy enterprise averages ExplanationCorrect Answer B:Operational reports may refer to aircraft that do not exist. This follows from the unresolved case facts. The preventive intervention is: Add referential integrity and approved-master cross-reference checks. The reason is: Integrity concerns relationships and constraints among related data, not just value formatting.Incorrect Answers A:Data-quality measurement only helps when linked to accountable decisions and corrective action. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Operational reports may refer to aircraft that do not exist. C: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: Operational reports may refer to aircraft that do not exist. D:Aggregate quality scores can hide concentrated risks that matter to specific controls. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Operational reports may refer to aircraft that do not exist.