Question 110A school system supplies student behavior data to a vendor's model after removing names but leaves persistent identifiers easily linked to class registers. A reviewer proposes: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards. Which data-management principle best supports that choice? Ethical data use requires examining foreseeable unequal harm, not only technical predictive accuracy Ethical obligations continue where apparently anonymized records can reasonably be linked back to children A profitable or legally permitted data application can still be manipulative or socially harmful Legal consent wording does not automatically make every secondary use ethically justified ExplanationCorrect Answer B:Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. This is why the recommended action fits the given facts: A school system supplies student behavior data to a vendor's model after removing names but leaves persistent identifiers easily linked to class registers. Verification would show: A challenge test documents linkability reduction and enforceable vendor restrictions.Incorrect Answers A:Ethical data use requires examining foreseeable unequal harm, not only technical predictive accuracy. This does not establish the proposed intervention. The governing principle here is: Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. Apply it by: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards. C:A profitable or legally permitted data application can still be manipulative or socially harmful. This does not establish the proposed intervention. The governing principle here is: Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. Apply it by: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards. D:Legal consent wording does not automatically make every secondary use ethically justified. This does not establish the proposed intervention. The governing principle here is: Ethical obligations continue where apparently anonymized records can reasonably be linked back to children. Apply it by: Evaluate re-identification and downstream harm, then minimize data and strengthen access safeguards.
Question 111A retail company allows a vendor to download entire customer datasets when the vendor needs only aggregated campaign counts. Which data-management action most directly corrects the identified problem? Separate encryption keys from protected data and manage key access, rotation, and storage securely Minimize shared fields and define approved purposes and recipient restrictions Enforce secure retention and defensible destruction according to classification and holds Reclassify datasets on material content changes and update handling controls accordingly ExplanationCorrect Answer B:Minimize shared fields and define approved purposes and recipient restrictions. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. Practical verification is: 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. That is relevant to a different intervention. For the stated situation, the required action is: Minimize shared fields and define approved purposes and recipient restrictions. The governing reason is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. C:Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. That is relevant to a different intervention. For the stated situation, the required action is: Minimize shared fields and define approved purposes and recipient restrictions. The governing reason is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. D:Security classification should reflect current information content and potential harm. That is relevant to a different intervention. For the stated situation, the required action is: Minimize shared fields and define approved purposes and recipient restrictions. The governing reason is: Security and privacy controls should reduce unnecessary exposure at data exchange boundaries.
Question 112A hospital overwrites a patient insurance category each month and cannot reproduce the category applied when a claim was processed. A reviewer proposes: Use an appropriate slowly changing dimension history with effective dates for analytical attributes. Which data-management principle best supports that choice? Late-arriving dimensions require explicit key-handling that preserves fact relationships Warehouse performance depends on physical design matched to analytical workload and query patterns Type 2 historical dimension tracking preserves earlier attribute states for time-correct analysis Transactional facts and snapshot facts represent fundamentally different observation grains ExplanationCorrect Answer C:Type 2 historical dimension tracking preserves earlier attribute states for time-correct analysis. This is why the recommended action fits the given facts: A hospital overwrites a patient insurance category each month and cannot reproduce the category applied when a claim was processed. Verification would show: Past claim queries select the insurance category valid on the claim date.Incorrect Answers A:Late-arriving dimensions require explicit key-handling that preserves fact relationships. This does not establish the proposed intervention. The governing principle here is: Type 2 historical dimension tracking preserves earlier attribute states for time-correct analysis. Apply it by: Use an appropriate slowly changing dimension history with effective dates for analytical attributes. B:Warehouse performance depends on physical design matched to analytical workload and query patterns. This does not establish the proposed intervention. The governing principle here is: Type 2 historical dimension tracking preserves earlier attribute states for time-correct analysis. Apply it by: Use an appropriate slowly changing dimension history with effective dates for analytical attributes. D:Transactional facts and snapshot facts represent fundamentally different observation grains. This does not establish the proposed intervention. The governing principle here is: Type 2 historical dimension tracking preserves earlier attribute states for time-correct analysis. Apply it by: Use an appropriate slowly changing dimension history with effective dates for analytical attributes.
Question 113An insurance company measures claim completeness only monthly, though daily operations depend on near-real-time approvals. A reviewer proposes: Set measurement cadence aligned to the data's use and operational decision window. Which data-management principle best supports that choice? Quality performance changes over time as sources and processes evolve Completeness measures presence while accuracy measures correspondence to real-world facts Quality monitoring frequency should reflect when an issue can cause material harm Quality tolerances should reflect consequences and fitness for business purpose ExplanationCorrect Answer C:Quality monitoring frequency should reflect when an issue can cause material harm. This is why the recommended action fits the given facts: An insurance company measures claim completeness only monthly, though daily operations depend on near-real-time approvals. Verification would show: Daily checks detect missing claim attributes before approval cutoffs.Incorrect Answers A:Quality performance changes over time as sources and processes evolve. This does not establish the proposed intervention. The governing principle here is: Quality monitoring frequency should reflect when an issue can cause material harm. Apply it by: Set measurement cadence aligned to the data's use and operational decision window. B:Completeness measures presence while accuracy measures correspondence to real-world facts. This does not establish the proposed intervention. The governing principle here is: Quality monitoring frequency should reflect when an issue can cause material harm. Apply it by: Set measurement cadence aligned to the data's use and operational decision window. D:Quality tolerances should reflect consequences and fitness for business purpose. This does not establish the proposed intervention. The governing principle here is: Quality monitoring frequency should reflect when an issue can cause material harm. Apply it by: Set measurement cadence aligned to the data's use and operational decision window.
Question 114An online marketplace uses a transaction fact table to represent current stock rather than a balance snapshot. After the proposed change—Choose a fact type appropriate to event flows versus measured states—which observation best verifies that this specific weakness has been addressed? Inventory balances are reproducible for each period and comparable across warehouses A sample order reconciles line totals without duplicating revenue after joins Late loan transactions appear in the appropriate reporting period with traceable adjustments Current inventory can be reconstructed or directly observed according to a documented snapshot policy ExplanationCorrect Answer D:Current inventory can be reconstructed or directly observed according to a documented snapshot policy. This is specific evidence for the intervention: Choose a fact type appropriate to event flows versus measured states. The underlying principle is: Transactional facts and snapshot facts represent fundamentally different observation grains.Incorrect Answers A:Snapshot facts represent measured state at defined intervals and cannot be casually mixed with transactions. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Current inventory can be reconstructed or directly observed according to a documented snapshot policy. 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: Current inventory can be reconstructed or directly observed according to a documented snapshot policy. C:Analytical loading must preserve business event dates even when data arrives after the processing window. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Current inventory can be reconstructed or directly observed according to a documented snapshot policy.
Question 115A wholesaler stores invoice scans for an indefinite period because no one translated legal and business obligations into record schedules. After the proposed change—Classify invoice records and apply approved retention schedules with documented exceptions—which observation best verifies that this specific weakness has been addressed? Disposal logs show held items preserved and a controlled process for releasing the hold The repository applies approved schedules and can show expiry, exceptions, and disposition decisions Scan quality, indexing, approval, and controlled paper disposition are evidenced by sample checks A tested export reconciles selected custodians and periods to retention and hold logs ExplanationCorrect Answer B:The repository applies approved schedules and can show expiry, exceptions, and disposition decisions. This is specific evidence for the intervention: Classify invoice records and apply approved retention schedules with documented exceptions. The underlying principle is: Records lifecycle management balances legitimate retention duties against unnecessary accumulation.Incorrect Answers A:Authorized legal holds can override routine records disposal for in-scope material. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: The repository applies approved schedules and can show expiry, exceptions, and disposition decisions. C:Electronic records conversion needs a policy for authentic copies and lawful original handling. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: The repository applies approved schedules and can show expiry, exceptions, and disposition decisions. D: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: The repository applies approved schedules and can show expiry, exceptions, and disposition decisions.
Question 116A regional hospital plans database maintenance without testing failover application connections or transaction replay. A reviewer proposes: Exercise planned failover and verify connection, transaction, and data consistency behaviors. Which data-management principle best supports that choice? Availability and consistency design choices must match the guarantees consumers require Database performance depends on access paths and workload patterns as well as hardware resources High availability requires functioning application and data recovery paths, not merely a standby server RTO concerns elapsed service restoration time and includes dependencies beyond the file restore ExplanationCorrect Answer C:High availability requires functioning application and data recovery paths, not merely a standby server. This is why the recommended action fits the given facts: A regional hospital plans database maintenance without testing failover application connections or transaction replay. Verification would show: A failover drill keeps critical workflows within approved loss and outage limits.Incorrect Answers A:Availability and consistency design choices must match the guarantees consumers require. This does not establish the proposed intervention. The governing principle here is: High availability requires functioning application and data recovery paths, not merely a standby server. Apply it by: Exercise planned failover and verify connection, transaction, and data consistency behaviors. B:Database performance depends on access paths and workload patterns as well as hardware resources. This does not establish the proposed intervention. The governing principle here is: High availability requires functioning application and data recovery paths, not merely a standby server. Apply it by: Exercise planned failover and verify connection, transaction, and data consistency behaviors. D:RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. This does not establish the proposed intervention. The governing principle here is: High availability requires functioning application and data recovery paths, not merely a standby server. Apply it by: Exercise planned failover and verify connection, transaction, and data consistency behaviors.
Question 117A retailer tries to infer lineage solely from matching column names, creating false relationships between unrelated sales fields. After the proposed change—Validate inferred lineage against executed transformations and owner-reviewed mappings—which observation best verifies that this specific weakness has been addressed? A reviewer traces the reported score through transformation versions to source lab fields A consumer resolves each status code to its approved business meaning and effective period Sample dependencies match actual queries or pipelines and unsupported inferred edges are rejected A deployment triggers refreshed lineage and sampled paths match real execution ExplanationCorrect Answer C:Sample dependencies match actual queries or pipelines and unsupported inferred edges are rejected. This is specific evidence for the intervention: Validate inferred lineage against executed transformations and owner-reviewed mappings. The underlying principle is: Name similarity is not sufficient proof that values share provenance or meaning.Incorrect Answers A:Lineage records data movement and transformation dependencies needed for trust and auditability. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sample dependencies match actual queries or pipelines and unsupported inferred edges are rejected. B:A technical column name alone rarely conveys the semantics needed for correct reuse. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sample dependencies match actual queries or pipelines and unsupported inferred edges are rejected. D:Lineage accuracy declines when documentation is detached from actual implementation. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Sample dependencies match actual queries or pipelines and unsupported inferred edges are rejected.
Question 118A bank's anomaly dashboard shows fewer invalid addresses after data cleansing but cannot distinguish corrected records from records silently excluded. After the proposed change—Track quality denominators, exclusion rules, and verified correction outcomes—which observation best verifies that this specific weakness has been addressed? Quality tests flag known placeholders and demonstrate improved usable contact coverage A labeled test set reports both erroneous merges and missed duplicates before deployment Exception queues preserve recoverable records and prioritize defects affecting purchase orders Reconciliation identifies source records, corrected entries, excluded items, and justified reasons ExplanationCorrect Answer D:Reconciliation identifies source records, corrected entries, excluded items, and justified reasons. This is specific evidence for the intervention: Track quality denominators, exclusion rules, and verified correction outcomes. The underlying principle is: Quality metrics require transparent populations and calculations so apparent improvements are meaningful.Incorrect Answers A:A nonblank value can still be semantically missing or invalid for its declared purpose. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Reconciliation identifies source records, corrected entries, excluded items, and justified reasons. B:Aggressive matching can create false positives that are distinct from ordinary duplicate misses. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Reconciliation identifies source records, corrected entries, excluded items, and justified reasons. C:Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Reconciliation identifies source records, corrected entries, excluded items, and justified reasons.
Question 119An accounts team publishes confidential contract documents into an enterprise search index with no access filtering. If this weakness continues, what is the most directly associated business or data risk? Important business information may disappear or remain exposed when personal access ends Search previews may disclose commercial terms to unauthorized staff Incorrect extracted values may silently drive credit decisions Seemingly successful conversion can destroy context essential for safe reuse ExplanationCorrect Answer B:Search previews may disclose commercial terms to unauthorized staff. This follows from the unresolved case facts. The preventive intervention is: Propagate source access controls into search and index permissions and validate user entitlements. The reason is: Findability should not bypass information classification and need-to-know access rules.Incorrect Answers A:Unmanaged collaboration channels create custody gaps when employees leave or access changes. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Search previews may disclose commercial terms to unauthorized staff. C:Document digitization converts representation but does not itself establish information accuracy. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Search previews may disclose commercial terms to unauthorized staff. D:Digital preservation requires maintaining significant properties and context, not merely changing file formats. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Search previews may disclose commercial terms to unauthorized staff.
Question 120A billing application records an account's current interest rate but cannot reproduce the rate applicable to a previous invoice. If this weakness continues, what is the most directly associated business or data risk? Recalculations may silently use current rates for past transactions Tax reports may reinterpret old invoices using current code definitions Orders may be dispatched to the wrong address when roles are collapsed Permissions and financial records may attach to the wrong entity ExplanationCorrect Answer A:Recalculations may silently use current rates for past transactions. This follows from the unresolved case facts. The preventive intervention is: Model effective-dated interest rates and separate valid-time from update-time where needed. The reason is: Temporal data modeling preserves historically applicable facts rather than only current states.Incorrect Answers B:Meaningful relational models include temporal reference constraints when business rules change over time. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Recalculations may silently use current rates for past transactions. C:Cardinality and business roles determine the relationships needed to represent reality. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Recalculations may silently use current rates for past transactions. D:Distinct business objects should not be collapsed merely because a workflow commonly links them. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Recalculations may silently use current rates for past transactions.