Question 660A museum attaches arbitrary keywords to digital collections and cannot retrieve all photographs of the same historical period. A reviewer proposes: Use a controlled taxonomy or thesaurus with synonym management and consistent tagging. Which data-management principle best supports that choice? Classification metadata must reflect actual data content and sensitivity rather than static initial labels Metadata changes can alter interpretation of historical datasets and must be auditable Controlled vocabularies improve retrieval and classification when uncontrolled keywords diverge Trust labels are meaningful only when supported by explicit governance and auditable qualification ExplanationCorrect Answer C:Controlled vocabularies improve retrieval and classification when uncontrolled keywords diverge. This is why the recommended action fits the given facts: A museum attaches arbitrary keywords to digital collections and cannot retrieve all photographs of the same historical period. Verification would show: Searches using approved terms and synonyms return expected archival objects.Incorrect Answers A:Classification metadata must reflect actual data content and sensitivity rather than static initial labels. This does not establish the proposed intervention. The governing principle here is: Controlled vocabularies improve retrieval and classification when uncontrolled keywords diverge. Apply it by: Use a controlled taxonomy or thesaurus with synonym management and consistent tagging. B:Metadata changes can alter interpretation of historical datasets and must be auditable. This does not establish the proposed intervention. The governing principle here is: Controlled vocabularies improve retrieval and classification when uncontrolled keywords diverge. Apply it by: Use a controlled taxonomy or thesaurus with synonym management and consistent tagging. D:Trust labels are meaningful only when supported by explicit governance and auditable qualification. This does not establish the proposed intervention. The governing principle here is: Controlled vocabularies improve retrieval and classification when uncontrolled keywords diverge. Apply it by: Use a controlled taxonomy or thesaurus with synonym management and consistent tagging.
Question 661A transportation platform patches its database engine in production without validating driver compatibility or rollback procedures. If this weakness continues, what is the most directly associated business or data risk? An engine upgrade may make critical applications unable to connect A technically valid backup can still leave critical care services unavailable too long Business transactions may repeatedly fail or retry unpredictably under load A logical deletion may propagate to every replica and erase the only live copy ExplanationCorrect Answer A:An engine upgrade may make critical applications unable to connect. This follows from the unresolved case facts. The preventive intervention is: Test patches against dependent applications and use a governed backup and rollback plan. The reason is: Database operations must control changes that can affect service compatibility and recoverability.Incorrect Answers B: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: An engine upgrade may make critical applications unable to connect. C:Concurrent database operations can block or deadlock when transaction lock order conflicts. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: An engine upgrade may make critical applications unable to connect. 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: An engine upgrade may make critical applications unable to connect.
Question 662A warehouse has frequent deadlocks after a new batch process starts updating rows in inconsistent order. If this weakness continues, what is the most directly associated business or data risk? An engine upgrade may make critical applications unable to connect Customers may see a payment as missing even though it was just committed A nominally redundant database may still cause a prolonged service outage Business transactions may repeatedly fail or retry unpredictably under load ExplanationCorrect Answer D:Business transactions may repeatedly fail or retry unpredictably under load. This follows from the unresolved case facts. The preventive intervention is: Analyze transaction locking and order updates consistently with appropriate isolation. The reason 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. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Business transactions may repeatedly fail or retry unpredictably under load. B:Availability and consistency design choices must match the guarantees consumers require. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Business transactions may repeatedly fail or retry unpredictably under load. C:High availability requires functioning application and data recovery paths, not merely a standby server. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Business transactions may repeatedly fail or retry unpredictably under load.
Question 663A retail schema stores each order with multiple comma-separated product identifiers in one column. A reviewer proposes: Normalize order-line relationships into separate rows and enforce appropriate keys. Which data-management principle best supports that choice? Normalization reduces update anomalies when attributes belong to different entities Cardinality and business roles determine the relationships needed to represent reality Repeating values in one field impede first normal form and reliable relational operations Modeling standards improve consistency and make relationships unambiguous across implementations ExplanationCorrect Answer C:Repeating values in one field impede first normal form and reliable relational operations. This is why the recommended action fits the given facts: A retail schema stores each order with multiple comma-separated product identifiers in one column. Verification would show: Queries can join each order to its individual items without string parsing.Incorrect Answers A:Normalization reduces update anomalies when attributes belong to different entities. This does not establish the proposed intervention. The governing principle here is: Repeating values in one field impede first normal form and reliable relational operations. Apply it by: Normalize order-line relationships into separate rows and enforce appropriate keys. B:Cardinality and business roles determine the relationships needed to represent reality. This does not establish the proposed intervention. The governing principle here is: Repeating values in one field impede first normal form and reliable relational operations. Apply it by: Normalize order-line relationships into separate rows and enforce appropriate keys. D:Modeling standards improve consistency and make relationships unambiguous across implementations. This does not establish the proposed intervention. The governing principle here is: Repeating values in one field impede first normal form and reliable relational operations. Apply it by: Normalize order-line relationships into separate rows and enforce appropriate keys.
Question 664A manufacturer asks a vendor to guarantee 100 percent accurate product descriptions despite changing specifications and multilingual suppliers. Which data-management action most directly corrects the identified problem? Set quality thresholds based on critical data elements, use cases, and quantified impact Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities Classify quality exceptions by severity and route them through proportionate remediation workflows Create continuous quality monitoring with thresholds, trends, and accountable alerts ExplanationCorrect Answer B:Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. Practical verification is: A signed SLA specifies accuracy sampling, currency, exception tolerance, and corrective deadlines.Incorrect Answers A:Quality tolerances should reflect consequences and fitness for business purpose. That is relevant to a different intervention. For the stated situation, the required action is: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. The governing reason is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. C:Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. That is relevant to a different intervention. For the stated situation, the required action is: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. The governing reason is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims. D:Quality performance changes over time as sources and processes evolve. That is relevant to a different intervention. For the stated situation, the required action is: Agree measurable, purpose-specific quality dimensions, tolerances, and control responsibilities. The governing reason is: Quality fitness for use is contextual and benefits from agreed realistic metrics rather than vague perfection claims.
Question 665A bank decommissions retired employee accounts but fails to remove the service tokens they created. Which data-management action most directly corrects the identified problem? Use approved data masking or synthetic substitutes and restrict nonproduction access Protect sensitive data in transit with authenticated encryption and validated endpoint identities Inventory, revoke, and rotate credentials associated with departed identities Apply role-based least privilege and purpose-aligned authorization to sensitive patient data ExplanationCorrect Answer C:Inventory, revoke, and rotate credentials associated with departed identities. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Identity lifecycle controls must include nonhuman credentials and delegated access pathways. Practical verification is: Token inventory shows revoked credentials cannot read protected data after offboarding.Incorrect Answers A:Production confidentiality requirements continue when sensitive data is copied into development and testing. That is relevant to a different intervention. For the stated situation, the required action is: Inventory, revoke, and rotate credentials associated with departed identities. The governing reason is: Identity lifecycle controls must include nonhuman credentials and delegated access pathways. B:Internal network placement does not eliminate interception or impersonation risk. That is relevant to a different intervention. For the stated situation, the required action is: Inventory, revoke, and rotate credentials associated with departed identities. The governing reason is: Identity lifecycle controls must include nonhuman credentials and delegated access pathways. D:Access rights should reflect approved duties and data sensitivity rather than broad team membership. That is relevant to a different intervention. For the stated situation, the required action is: Inventory, revoke, and rotate credentials associated with departed identities. The governing reason is: Identity lifecycle controls must include nonhuman credentials and delegated access pathways.
Question 666An insurer prepares a target-state analytics diagram but omits which legacy applications create policy and claims data. After the proposed change—Inventory current information producers, consumers, interfaces, and dependencies before finalizing the target state—which observation best verifies that this specific weakness has been addressed? Reviewed diagrams show source-to-consumer paths, transformation checkpoints, and failure boundaries The transition plan traces each policy and claim feed to a current owner and target destination Design approval links each target service to assessed data classification, residency, and recovery tests A glossary and interface mapping demonstrate when two source status codes convey the same meaning ExplanationCorrect Answer B:The transition plan traces each policy and claim feed to a current owner and target destination. This is specific evidence for the intervention: Inventory current information producers, consumers, interfaces, and dependencies before finalizing the target state. The underlying principle is: Transition architecture requires a credible current state to identify change impact and migration constraints.Incorrect Answers A:Data-flow architecture makes movement and dependencies visible for operational and governance design. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: The transition plan traces each policy and claim feed to a current owner and target destination. C:Nonfunctional information requirements are architecture constraints, not optional post-deployment checks. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: The transition plan traces each policy and claim feed to a current owner and target destination. D:A canonical enterprise definition must distinguish business meaning from different implementation representations. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: The transition plan traces each policy and claim feed to a current owner and target destination.
Question 667A retailer's sales, loyalty, and returns platforms each define a different customer key and produce incompatible enterprise measures. Which data-management action most directly corrects the identified problem? Define clear event and effective-time semantics in the canonical architecture Publish a versioned data contract with semantic definitions, quality rules, and change governance Model identity relationships and provenance explicitly and maintain reversible crosswalk decisions Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces ExplanationCorrect Answer D:Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. Practical verification is: Architecture mappings reconcile customer identifiers across the three systems and shared reports.Incorrect Answers A:Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them. That is relevant to a different intervention. For the stated situation, the required action is: Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces. The governing reason is: Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. B:Interfaces are data products whose meaning and compatibility require coordinated lifecycle management. That is relevant to a different intervention. For the stated situation, the required action is: Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces. The governing reason is: Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. C:Enterprise identity architecture needs traceable identity resolution rather than assuming one unchanging source key. That is relevant to a different intervention. For the stated situation, the required action is: Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces. The governing reason is: Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems.
Question 668A regional insurer stores sensitive claim attachments for years after their approved business and legal retention periods. A reviewer proposes: Enforce secure retention and defensible destruction according to classification and holds. Which data-management principle best supports that choice? Security monitoring itself can create new repositories of sensitive information that need protection 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 and privacy controls should reduce unnecessary exposure at data exchange boundaries ExplanationCorrect Answer C:Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. This is why the recommended action fits the given facts: A regional insurer stores sensitive claim attachments for years after their approved business and legal retention periods. Verification would show: Expired items are removed from active and backup handling under approved documented schedules.Incorrect Answers A:Security monitoring itself can create new repositories of sensitive information that need protection. This does not establish the proposed intervention. The governing principle here is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. Apply it by: Enforce secure retention and defensible destruction according to classification and holds. B: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 covers data throughout its lifecycle, including controlled disposition of unnecessary copies. Apply it by: Enforce secure retention and defensible destruction according to classification and holds. D:Security and privacy controls should reduce unnecessary exposure at data exchange boundaries. This does not establish the proposed intervention. The governing principle here is: Security covers data throughout its lifecycle, including controlled disposition of unnecessary copies. Apply it by: Enforce secure retention and defensible destruction according to classification and holds.
Question 669Two subsidiaries disagree whether account status means a legal relationship state or a system workflow state. Which data-management action most directly corrects the identified problem? Establish enterprise entity definitions, a canonical customer identifier strategy, and mapped system interfaces Define clear event and effective-time semantics in the canonical architecture Define the shared business concept while allowing explicit system-specific mappings and contexts Inventory current information producers, consumers, interfaces, and dependencies before finalizing the target state ExplanationCorrect Answer C:Define the shared business concept while allowing explicit system-specific mappings and contexts. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: A canonical enterprise definition must distinguish business meaning from different implementation representations. Practical verification is: A glossary and interface mapping demonstrate when two source status codes convey the same meaning.Incorrect Answers A:Data architecture describes how enterprise information assets and relationships fit across business capabilities and systems. That is relevant to a different intervention. For the stated situation, the required action is: Define the shared business concept while allowing explicit system-specific mappings and contexts. The governing reason is: A canonical enterprise definition must distinguish business meaning from different implementation representations. B:Temporal meaning must be explicit when distributed data describes when things happened versus when systems learned of them. That is relevant to a different intervention. For the stated situation, the required action is: Define the shared business concept while allowing explicit system-specific mappings and contexts. The governing reason is: A canonical enterprise definition must distinguish business meaning from different implementation representations. D:Transition architecture requires a credible current state to identify change impact and migration constraints. That is relevant to a different intervention. For the stated situation, the required action is: Define the shared business concept while allowing explicit system-specific mappings and contexts. The governing reason is: A canonical enterprise definition must distinguish business meaning from different implementation representations.
Question 670A retailer tries to infer lineage solely from matching column names, creating false relationships between unrelated sales fields. If this weakness continues, what is the most directly associated business or data risk? High-impact analytical conclusions may be impossible to validate or correct Analysts may misclassify customer service states from opaque codes Incorrect lineage may produce false impact warnings and conceal true dependencies Impact analysis may rely on obsolete relationships and miss affected consumers ExplanationCorrect Answer C:Incorrect lineage may produce false impact warnings and conceal true dependencies. This follows from the unresolved case facts. The preventive intervention is: Validate inferred lineage against executed transformations and owner-reviewed mappings. The reason 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. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Incorrect lineage may produce false impact warnings and conceal true dependencies. B:A technical column name alone rarely conveys the semantics needed for correct reuse. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Incorrect lineage may produce false impact warnings and conceal true dependencies. D:Lineage accuracy declines when documentation is detached from actual implementation. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Incorrect lineage may produce false impact warnings and conceal true dependencies.