Question 170A finance team exports identifiable payroll records to a test environment where contractor accounts have unrestricted access. Which data-management action most directly corrects the identified problem? Test access-control changes against approved entitlements before release and monitor privileged changes Apply role-based least privilege and purpose-aligned authorization to sensitive patient data Use approved data masking or synthetic substitutes and restrict nonproduction access Define response playbooks for suspected data exfiltration including containment, evidence, and stakeholder escalation ExplanationCorrect Answer C:Use approved data masking or synthetic substitutes and restrict nonproduction access. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Production confidentiality requirements continue when sensitive data is copied into development and testing. Practical verification is: Sample nonproduction records lack recoverable direct identifiers and access reviews pass.Incorrect Answers A:Authorization changes can unintentionally expand the reach of sensitive data. That is relevant to a different intervention. For the stated situation, the required action is: Use approved data masking or synthetic substitutes and restrict nonproduction access. The governing reason is: Production confidentiality requirements continue when sensitive data is copied into development and testing. B: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: Use approved data masking or synthetic substitutes and restrict nonproduction access. The governing reason is: Production confidentiality requirements continue when sensitive data is copied into development and testing. D:Data security needs preparedness for incidents affecting confidentiality, integrity, and availability. That is relevant to a different intervention. For the stated situation, the required action is: Use approved data masking or synthetic substitutes and restrict nonproduction access. The governing reason is: Production confidentiality requirements continue when sensitive data is copied into development and testing.
Question 171A manufacturer changes an ERP material-code definition without knowing which dashboards use it. Which data-management action most directly corrects the identified problem? Enrich metadata with criticality, business capabilities, and accountable use cases Propagate sensitivity classifications and authorized-use metadata to catalog search Use metadata lineage and dependency impact analysis before releasing the change Publish accessible governed metadata with links to implementation artifacts ExplanationCorrect Answer C:Use metadata lineage and dependency impact analysis before releasing the change. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Metadata supports change impact when it links source fields to downstream consumers. Practical verification is: An impact report lists affected dashboards, interfaces, and data owners before cutover.Incorrect Answers A:Metadata supports prioritization when technical assets can be connected to business impact. That is relevant to a different intervention. For the stated situation, the required action is: Use metadata lineage and dependency impact analysis before releasing the change. The governing reason is: Metadata supports change impact when it links source fields to downstream consumers. B:Metadata about security and permitted use must survive harvesting and downstream catalog distribution. That is relevant to a different intervention. For the stated situation, the required action is: Use metadata lineage and dependency impact analysis before releasing the change. The governing reason is: Metadata supports change impact when it links source fields to downstream consumers. D:Metadata should serve business and technical consumers without requiring direct source-system access. That is relevant to a different intervention. For the stated situation, the required action is: Use metadata lineage and dependency impact analysis before releasing the change. The governing reason is: Metadata supports change impact when it links source fields to downstream consumers.
Question 172A university governance council never adjudicates conflicts because each department has an informal veto over shared definitions. Which data-management action most directly corrects the identified problem? Approve a governance charter specifying enterprise decision rights, domain ownership, and escalation Define escalation and tie-breaking authority for cross-domain data decisions Define formal governance touchpoints, referral criteria, and a reconciled policy hierarchy Establish implementation assurance with exception reporting and post-decision validation ExplanationCorrect Answer B:Define escalation and tie-breaking authority for cross-domain data decisions. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Decision rights must provide a way to resolve conflicts that exceed individual domain authority. Practical verification is: A sample dispute results in an accountable decision and a documented appeal route.Incorrect Answers A:Data governance is the exercise of authority and control over data-management decisions rather than a committee title alone. That is relevant to a different intervention. For the stated situation, the required action is: Define escalation and tie-breaking authority for cross-domain data decisions. The governing reason is: Decision rights must provide a way to resolve conflicts that exceed individual domain authority. C:Related governance functions must coordinate decision rights where data-use risks cross disciplines. That is relevant to a different intervention. For the stated situation, the required action is: Define escalation and tie-breaking authority for cross-domain data decisions. The governing reason is: Decision rights must provide a way to resolve conflicts that exceed individual domain authority. D:Governance authority needs an execution feedback loop from policy decision to operational compliance. That is relevant to a different intervention. For the stated situation, the required action is: Define escalation and tie-breaking authority for cross-domain data decisions. The governing reason is: Decision rights must provide a way to resolve conflicts that exceed individual domain authority.
Question 173A sensor platform calculates delivery times from message arrival order although mobile devices buffer events during connectivity gaps. Which data-management action most directly corrects the identified problem? Apply data classification, cataloging, lifecycle controls, and stewardship to the raw event lake Diagnose partition skew and redesign distribution or aggregation for the uneven key pattern Use event time, late-arrival handling, and documented watermark policies when aggregating streams Limit collection and retention, pseudonymize identifiers where appropriate, and govern permitted uses ExplanationCorrect Answer C:Use event time, late-arrival handling, and documented watermark policies when aggregating streams. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Processing time can differ from the time a business event occurred, particularly for delayed distributed data. Practical verification is: A replay containing late messages produces the expected time windows and documented corrections.Incorrect Answers A:A scalable lake is not exempt from metadata and governance; unmanaged ingestion can create an unusable data swamp. That is relevant to a different intervention. For the stated situation, the required action is: Use event time, late-arrival handling, and documented watermark policies when aggregating streams. The governing reason is: Processing time can differ from the time a business event occurred, particularly for delayed distributed data. B:Distributed processing performance depends on balanced partitions and appropriate data shuffling, not just total cluster size. That is relevant to a different intervention. For the stated situation, the required action is: Use event time, late-arrival handling, and documented watermark policies when aggregating streams. The governing reason is: Processing time can differ from the time a business event occurred, particularly for delayed distributed data. D:Scale and analytical potential do not displace purpose limitation and protection of identifiable information. That is relevant to a different intervention. For the stated situation, the required action is: Use event time, late-arrival handling, and documented watermark policies when aggregating streams. The governing reason is: Processing time can differ from the time a business event occurred, particularly for delayed distributed data.
Question 174A university runs disconnected governance, quality, and modeling projects without a shared roadmap or prioritization process. Which data-management action most directly corrects the identified problem? Connect data-management activities to defined clinical information outcomes and accountable roles Identify business goals and data pain points before choosing the catalog and its implementation sequence Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities Define measurable information outcomes and review benefits after delivery with business stakeholders ExplanationCorrect Answer C:Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Related data-management disciplines need an integrated operating plan so their outputs reinforce one another. Practical verification is: A single portfolio shows linked deliverables, owners, dependencies, milestone acceptance, and resources.Incorrect Answers A:Data management is an end-to-end discipline that supports data value, usability, protection, and lifecycle decisions rather than only system availability. That is relevant to a different intervention. For the stated situation, the required action is: Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities. The governing reason is: Related data-management disciplines need an integrated operating plan so their outputs reinforce one another. B:Business-driven data management establishes requirements and success measures before selecting supporting technology. That is relevant to a different intervention. For the stated situation, the required action is: Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities. The governing reason is: Related data-management disciplines need an integrated operating plan so their outputs reinforce one another. D:Data-management performance includes realized information value and outcomes, not just project task completion. That is relevant to a different intervention. For the stated situation, the required action is: Create a coordinated data-management roadmap with ownership, dependencies, and funded priorities. The governing reason is: Related data-management disciplines need an integrated operating plan so their outputs reinforce one another.
Question 175A retailer's self-service BI catalog shows five fields all named 'net revenue' with different calculation rules. If this weakness continues, what is the most directly associated business or data risk? Personal travel histories may spread through unmanaged analytical extracts Conflicting churn metrics can undermine decisions and accountability Trend charts may show artificial growth or decline caused only by changing semantics Teams may present incompatible revenue figures under the same label ExplanationCorrect Answer D:Teams may present incompatible revenue figures under the same label. This follows from the unresolved case facts. The preventive intervention is: Establish a governed semantic definition and designate authoritative measures. The reason is: Self-service analytics needs consistent metric meaning and approved reuse, not just dataset access.Incorrect Answers A:Business-intelligence access needs stewardship and proportionate security even when data are curated. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Teams may present incompatible revenue figures under the same label. B:Different analytical products need shared definitions for measures intended to be compared. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Teams may present incompatible revenue figures under the same label. C:Metrics governance is needed when analytical meaning changes over time. That does not describe the principal exposure from the stated failure. The direct avoidable risk is: Teams may present incompatible revenue figures under the same label.
Question 176A manufacturer discards thousands of supplier records when a mandatory field is blank instead of assessing business impact. Which data-management action most directly corrects the identified problem? Classify quality exceptions by severity and route them through proportionate remediation workflows Assign each rule a business owner, alert severity, remediation workflow, and acceptance criteria Set quality thresholds based on critical data elements, use cases, and quantified impact Segment quality measures by source, domain, and criticality instead of averaging away important failures ExplanationCorrect Answer A:Classify quality exceptions by severity and route them through proportionate remediation workflows. This intervention addresses the scenario rather than a neighboring data concern. The governing concept is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. Practical verification is: Exception queues preserve recoverable records and prioritize defects affecting purchase orders.Incorrect Answers B:Data-quality measurement only helps when linked to accountable decisions and corrective action. That is relevant to a different intervention. For the stated situation, the required action is: Classify quality exceptions by severity and route them through proportionate remediation workflows. The governing reason is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. C: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: Classify quality exceptions by severity and route them through proportionate remediation workflows. The governing reason is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally. D:Aggregate quality scores can hide concentrated risks that matter to specific controls. That is relevant to a different intervention. For the stated situation, the required action is: Classify quality exceptions by severity and route them through proportionate remediation workflows. The governing reason is: Data quality management balances fitness for purpose, consequence, and cost rather than demanding zero defects universally.
Question 177A distributor sends supplier bank details through an unencrypted integration endpoint inside a supposedly trusted corporate network. After the proposed change—Protect sensitive data in transit with authenticated encryption and validated endpoint identities—which observation best verifies that this specific weakness has been addressed? Key-access audits and a compromise drill demonstrate independent protection of secret material Sample nonproduction records lack recoverable direct identifiers and access reviews pass Integration tests reject plaintext connections and verify peer certificates Negative-access tests deny unauthorized exports and privileged changes appear in the audit log ExplanationCorrect Answer C:Integration tests reject plaintext connections and verify peer certificates. This is specific evidence for the intervention: Protect sensitive data in transit with authenticated encryption and validated endpoint identities. The underlying principle is: Internal network placement does not eliminate interception or impersonation risk.Incorrect Answers A:Encryption does not reduce exposure when unauthorized users can access the effective key. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Integration tests reject plaintext connections and verify peer certificates. B: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: Integration tests reject plaintext connections and verify peer certificates. D:Authorization changes can unintentionally expand the reach of sensitive data. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Integration tests reject plaintext connections and verify peer certificates.
Question 178A bank decommissions retired employee accounts but fails to remove the service tokens they created. After the proposed change—Inventory, revoke, and rotate credentials associated with departed identities—which observation best verifies that this specific weakness has been addressed? Sample nonproduction records lack recoverable direct identifiers and access reviews pass Token inventory shows revoked credentials cannot read protected data after offboarding Integration tests reject plaintext connections and verify peer certificates An authorization test denies unrelated patient attributes while allowing approved aggregate reporting ExplanationCorrect Answer B:Token inventory shows revoked credentials cannot read protected data after offboarding. This is specific evidence for the intervention: Inventory, revoke, and rotate credentials associated with departed identities. The underlying principle is: Identity lifecycle controls must include nonhuman credentials and delegated access pathways.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: Token inventory shows revoked credentials cannot read protected data after offboarding. C:Internal network placement does not eliminate interception or impersonation risk. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Token inventory shows revoked credentials cannot read protected data after offboarding. D:Access rights should reflect approved duties and data sensitivity rather than broad team membership. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: Token inventory shows revoked credentials cannot read protected data after offboarding.
Question 179A conglomerate's data owners approve new sensitive-data sharing through informal messages without any purpose or recipient controls. After the proposed change—Establish documented data-sharing approvals, purpose limitations, recipient conditions, and auditability—which observation best verifies that this specific weakness has been addressed? The responsibility matrix separates approved consent rules from database access and backup duties A sample exchange has a signed purpose, recipient permissions, retention terms, and logged access Ticket histories show accountable decisions, root-cause fixes, and prevention checks Each exception has a rationale, named approver, expiry, controls, and a review outcome ExplanationCorrect Answer B:A sample exchange has a signed purpose, recipient permissions, retention terms, and logged access. This is specific evidence for the intervention: Establish documented data-sharing approvals, purpose limitations, recipient conditions, and auditability. The underlying principle is: Data access decisions require accountable authorization and appropriate use restrictions beyond technical connectivity.Incorrect Answers A:A data owner makes business decisions while a data custodian implements technical safeguards and operations. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A sample exchange has a signed purpose, recipient permissions, retention terms, and logged access. C:Issue management needs joint business-technical ownership aligned with the cause of the data problem. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A sample exchange has a signed purpose, recipient permissions, retention terms, and logged access. D:Policy exceptions need documented risk decisions and periodic review to avoid silently defeating enterprise standards. This relates to a separate check and does not verify the specified repair. The relevant acceptance evidence is: A sample exchange has a signed purpose, recipient permissions, retention terms, and logged access.
Question 180A retailer tries to infer lineage solely from matching column names, creating false relationships between unrelated sales fields. A reviewer proposes: Validate inferred lineage against executed transformations and owner-reviewed mappings. Which data-management principle best supports that choice? Lineage records data movement and transformation dependencies needed for trust and auditability Name similarity is not sufficient proof that values share provenance or meaning A technical column name alone rarely conveys the semantics needed for correct reuse Lineage accuracy declines when documentation is detached from actual implementation ExplanationCorrect Answer B:Name similarity is not sufficient proof that values share provenance or meaning. This is why the recommended action fits the given facts: A retailer tries to infer lineage solely from matching column names, creating false relationships between unrelated sales fields. Verification would show: Sample dependencies match actual queries or pipelines and unsupported inferred edges are rejected.Incorrect Answers A:Lineage records data movement and transformation dependencies needed for trust and auditability. This does not establish the proposed intervention. The governing principle here is: Name similarity is not sufficient proof that values share provenance or meaning. Apply it by: Validate inferred lineage against executed transformations and owner-reviewed mappings. C:A technical column name alone rarely conveys the semantics needed for correct reuse. This does not establish the proposed intervention. The governing principle here is: Name similarity is not sufficient proof that values share provenance or meaning. Apply it by: Validate inferred lineage against executed transformations and owner-reviewed mappings. D:Lineage accuracy declines when documentation is detached from actual implementation. This does not establish the proposed intervention. The governing principle here is: Name similarity is not sufficient proof that values share provenance or meaning. Apply it by: Validate inferred lineage against executed transformations and owner-reviewed mappings.