Question 260An online marketplace sets a four-hour backup schedule without verifying its maximum acceptable order-loss window. 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 The organization may discover during an incident that its backups are unusable The organization may lose more recent orders than business leaders accepted A logical deletion may propagate to every replica and erase the only live copy ExplanationCorrect Answer C:The organization may lose more recent orders than business leaders accepted. This follows from the unresolved case facts. The preventive intervention is: Define recovery-point objectives from business impact and align backup or log-capture frequency. The reason is: RPO describes tolerated data loss in time and is distinct from how long restoration takes.Incorrect Answers A:RTO concerns elapsed service restoration time and includes dependencies beyond the file restore. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: The organization may lose more recent orders than business leaders accepted. B: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: The organization may lose more recent orders than business leaders accepted. D:Replication can faithfully copy corruption or deletion; it is not a substitute for recoverable backups. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: The organization may lose more recent orders than business leaders accepted.
Question 261An airline deletes a wrongly merged passenger identity with no way to recover its source relationships. A reviewer proposes: Provide controlled unmerge procedures with provenance and dependent-record impact analysis. Which data-management principle best supports that choice? Master records are consolidated views that still require traceable source lineage and decision history Master-data consolidation should be reversible when merge decisions are corrected Creating a golden record does not ensure that consuming applications have adopted the correct value Master-data updates can alter who a counterparty is, not just a descriptive field ExplanationCorrect Answer B:Master-data consolidation should be reversible when merge decisions are corrected. This is why the recommended action fits the given facts: An airline deletes a wrongly merged passenger identity with no way to recover its source relationships. Verification would show: An unmerge rehearsal restores distinct identities and maintains correct booking links.Incorrect Answers A:Master records are consolidated views that still require traceable source lineage and decision history. This does not establish the proposed intervention. The governing principle here is: Master-data consolidation should be reversible when merge decisions are corrected. Apply it by: Provide controlled unmerge procedures with provenance and dependent-record impact analysis. C:Creating a golden record does not ensure that consuming applications have adopted the correct value. This does not establish the proposed intervention. The governing principle here is: Master-data consolidation should be reversible when merge decisions are corrected. Apply it by: Provide controlled unmerge procedures with provenance and dependent-record impact analysis. D: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: Master-data consolidation should be reversible when merge decisions are corrected. Apply it by: Provide controlled unmerge procedures with provenance and dependent-record impact analysis.
Question 262An insurer stores many policyholders and many policies in one table with repeated combinations and no bridge entity. A reviewer proposes: Model the many-to-many relationship with an associative entity and defined business attributes. Which data-management principle best supports that choice? Many-to-many relationships usually require an explicit association in relational implementation Relational models should make changing cardinality and time-dependent associations explicit Recursive relationships require business rules to prevent impossible self-referential structures Foreign keys express relationships and prevent references to nonexistent parents where enforced ExplanationCorrect Answer A:Many-to-many relationships usually require an explicit association in relational implementation. This is why the recommended action fits the given facts: An insurer stores many policyholders and many policies in one table with repeated combinations and no bridge entity. Verification would show: Queries correctly represent policyholder roles and dates for shared policies.Incorrect Answers B:Relational models should make changing cardinality and time-dependent associations explicit. This does not establish the proposed intervention. The governing principle here is: Many-to-many relationships usually require an explicit association in relational implementation. Apply it by: Model the many-to-many relationship with an associative entity and defined business attributes. C:Recursive relationships require business rules to prevent impossible self-referential structures. This does not establish the proposed intervention. The governing principle here is: Many-to-many relationships usually require an explicit association in relational implementation. Apply it by: Model the many-to-many relationship with an associative entity and defined business attributes. D:Foreign keys express relationships and prevent references to nonexistent parents where enforced. This does not establish the proposed intervention. The governing principle here is: Many-to-many relationships usually require an explicit association in relational implementation. Apply it by: Model the many-to-many relationship with an associative entity and defined business attributes.
Question 263A lending company publishes a 'customer risk' data product without recording the model version or feature calculation dates. Which data-management action most directly corrects the identified problem? Version metadata and retain effective dates, reviewer, and change history Maintain an auditable metadata change log with ownership, approval, and effective-date history Capture reproducibility metadata for feature definitions, models, and data snapshots Assign stable asset identifiers and maintain version and alias metadata ExplanationCorrect Answer C:Capture reproducibility metadata for feature definitions, models, and data snapshots. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Data product provenance includes the versions and inputs that produced a given result. Practical verification is: A historical risk value can be regenerated using its recorded model and feature lineage.Incorrect Answers A:Metadata changes can alter interpretation of historical datasets and must be auditable. That is relevant to a different intervention. For the stated situation, the required action is: Capture reproducibility metadata for feature definitions, models, and data snapshots. The governing reason is: Data product provenance includes the versions and inputs that produced a given result. B:Metadata governance supports accountability by recording who changed meanings and when. That is relevant to a different intervention. For the stated situation, the required action is: Capture reproducibility metadata for feature definitions, models, and data snapshots. The governing reason is: Data product provenance includes the versions and inputs that produced a given result. D:Metadata identity must persist across renames and versions to preserve references. That is relevant to a different intervention. For the stated situation, the required action is: Capture reproducibility metadata for feature definitions, models, and data snapshots. The governing reason is: Data product provenance includes the versions and inputs that produced a given result.
Question 264A logistics platform receives all shipments but 15 percent of delivery timestamps are blank during partner outages. After the proposed change—Monitor attribute and event completeness by source, time, and criticality—which observation best verifies that this specific weakness has been addressed? Source-specific completeness rates expose the failing partner and improve after remediation Sampled addresses are confirmed against current trusted records and correction histories Decision-time tests show the latest relevant status within an approved freshness threshold An alert fires on a controlled surge in malformed email values and corrective actions are tracked ExplanationCorrect Answer A:Source-specific completeness rates expose the failing partner and improve after remediation. This is specific evidence for the intervention: Monitor attribute and event completeness by source, time, and criticality. The underlying principle is: Completeness describes the presence of required data, not its correctness or timely arrival.Incorrect Answers B:Completeness measures presence while accuracy measures correspondence to real-world facts. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Source-specific completeness rates expose the failing partner and improve after remediation. C:Currency concerns whether data is sufficiently up to date for a purpose and may differ from delivery punctuality alone. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Source-specific completeness rates expose the failing partner and improve after remediation. D:Quality performance changes over time as sources and processes evolve. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Source-specific completeness rates expose the failing partner and improve after remediation.
Question 265An accounts team publishes confidential contract documents into an enterprise search index with no access filtering. A reviewer proposes: Propagate source access controls into search and index permissions and validate user entitlements. Which data-management principle best supports that choice? Unmanaged collaboration channels create custody gaps when employees leave or access changes Document digitization converts representation but does not itself establish information accuracy Digital preservation requires maintaining significant properties and context, not merely changing file formats Findability should not bypass information classification and need-to-know access rules ExplanationCorrect Answer D:Findability should not bypass information classification and need-to-know access rules. This is why the recommended action fits the given facts: An accounts team publishes confidential contract documents into an enterprise search index with no access filtering. Verification would show: Restricted users cannot see protected titles, snippets, or document contents in search results.Incorrect Answers A:Unmanaged collaboration channels create custody gaps when employees leave or access changes. This does not establish the proposed intervention. The governing principle here is: Findability should not bypass information classification and need-to-know access rules. Apply it by: Propagate source access controls into search and index permissions and validate user entitlements. B:Document digitization converts representation but does not itself establish information accuracy. This does not establish the proposed intervention. The governing principle here is: Findability should not bypass information classification and need-to-know access rules. Apply it by: Propagate source access controls into search and index permissions and validate user entitlements. C:Digital preservation requires maintaining significant properties and context, not merely changing file formats. This does not establish the proposed intervention. The governing principle here is: Findability should not bypass information classification and need-to-know access rules. Apply it by: Propagate source access controls into search and index permissions and validate user entitlements.
Question 266A cloud catalog stores descriptions from many systems but labels stale source attributes as current. 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 choose a technically available field with the wrong business meaning Users may implement integrations based on outdated schemas Consumers may be unaware that a supposedly current dataset failed to refresh ExplanationCorrect Answer C:Users may implement integrations based on outdated schemas. This follows from the unresolved case facts. The preventive intervention is: Add metadata freshness measures and owner alerts for failed harvesting processes. The reason is: Metadata quality has timeliness and accuracy requirements like the underlying data.Incorrect Answers A:Metadata about security and permitted use must survive harvesting and downstream catalog distribution. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Users may implement integrations based on outdated schemas. B:Business metadata expresses meaning while technical metadata describes structures and implementation. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Users may implement integrations based on outdated schemas. D:Operational metadata describes how data processes run and behave rather than only what fields exist. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Users may implement integrations based on outdated schemas.
Question 267A warehouse has frequent deadlocks after a new batch process starts updating rows in inconsistent order. After the proposed change—Analyze transaction locking and order updates consistently with appropriate isolation—which observation best verifies that this specific weakness has been addressed? Preproduction integration tests pass and a rollback rehearsal meets service targets A load replay shows lower deadlock rates without incorrect partial writes A test transaction is confirmed from a consistent view within the approved guarantee A failover drill keeps critical workflows within approved loss and outage limits ExplanationCorrect Answer B:A load replay shows lower deadlock rates without incorrect partial writes. This is specific evidence for the intervention: Analyze transaction locking and order updates consistently with appropriate isolation. The underlying principle is: Concurrent database operations can block or deadlock when transaction lock order conflicts.Incorrect Answers A: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: A load replay shows lower deadlock rates without incorrect partial writes. C:Availability and consistency design choices must match the guarantees consumers require. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A load replay shows lower deadlock rates without incorrect partial writes. D:High availability requires functioning application and data recovery paths, not merely a standby server. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A load replay shows lower deadlock rates without incorrect partial writes.
Question 268A manufacturing firm discovers unusual mass exports from its product design repository but has no data-specific incident response plan. After the proposed change—Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation—which observation best verifies that this specific weakness has been addressed? Sample nonproduction records lack recoverable direct identifiers and access reviews pass The vendor receives only approved aggregates and controlled queries cannot reveal individual rows Expired items are removed from active and backup handling under approved documented schedules A simulation detects abnormal exports and records containment decisions plus preserved evidence ExplanationCorrect Answer D:A simulation detects abnormal exports and records containment decisions plus preserved evidence. This is specific evidence for the intervention: Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation. The underlying principle is: Data security needs preparedness for incidents affecting confidentiality, integrity, and availability.Incorrect Answers A:Production confidentiality requirements continue when sensitive data is copied into development and testing. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A simulation detects abnormal exports and records containment decisions plus preserved evidence. B:Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A simulation detects abnormal exports and records containment decisions plus preserved evidence. C: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: A simulation detects abnormal exports and records containment decisions plus preserved evidence.
Question 269A legal team receives an e-discovery request but cannot establish which chat messages were retained, held, or deleted. Which data-management action most directly corrects the identified problem? Maintain defensible records inventories, custody logs, and controlled discovery exports Suspend relevant disposition under the authorized legal hold and maintain hold scope tracking Define a validated digitization and records-disposition procedure for source and electronic copies Move enterprise records into governed repositories with role-based access and lifecycle ownership ExplanationCorrect Answer A:Maintain defensible records inventories, custody logs, and controlled discovery exports. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence. Practical verification is: A tested export reconciles selected custodians and periods to retention and hold logs.Incorrect Answers B:Authorized legal holds can override routine records disposal for in-scope material. That is relevant to a different intervention. For the stated situation, the required action is: Maintain defensible records inventories, custody logs, and controlled discovery exports. The governing reason is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence. C:Electronic records conversion needs a policy for authentic copies and lawful original handling. That is relevant to a different intervention. For the stated situation, the required action is: Maintain defensible records inventories, custody logs, and controlled discovery exports. The governing reason is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence. D:Unmanaged collaboration channels create custody gaps when employees leave or access changes. That is relevant to a different intervention. For the stated situation, the required action is: Maintain defensible records inventories, custody logs, and controlled discovery exports. The governing reason is: Discovery depends on records authenticity, provenance, completeness, and disposition evidence.
Question 270A shipping database permits negative package weights because a numeric column has no domain constraint. Which data-management action most directly corrects the identified problem? Define and enforce a stable primary or candidate key for enrollment records Model supertype and subtype entities with appropriate constraints for type-specific attributes Choose suitable types and domain constraints reflecting valid business quantities Model and validate hierarchy constraints, including cycles and allowed depth ExplanationCorrect Answer C:Choose suitable types and domain constraints reflecting valid business quantities. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Data types and constraints should enforce basic attribute meaning at the data boundary. Practical verification is: Invalid negative weights fail validation while legitimate corrected measurements are stored.Incorrect Answers A:Entity identity requires keys that uniquely identify each logical record. That is relevant to a different intervention. For the stated situation, the required action is: Choose suitable types and domain constraints reflecting valid business quantities. The governing reason is: Data types and constraints should enforce basic attribute meaning at the data boundary. B:Specialization captures shared identity while preserving subtype-specific rules. That is relevant to a different intervention. For the stated situation, the required action is: Choose suitable types and domain constraints reflecting valid business quantities. The governing reason is: Data types and constraints should enforce basic attribute meaning at the data boundary. D: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: Choose suitable types and domain constraints reflecting valid business quantities. The governing reason is: Data types and constraints should enforce basic attribute meaning at the data boundary.