CDMP DMF Practice Test 47
Question 460
The data management team encounters this situation: A database service is slow but monitoring records only whether its process is up. Which intervention BEST addresses the actual problem?
- Evaluate query plans and appropriate indexes while considering write and storage overhead.
- Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
- Add performance monitoring for query latency, locks, throughput and resource saturation.
- Monitor growth, plan capacity headroom and tune storage before outage.
Explanation
Correct Answer
C:Add performance monitoring for query latency, locks, throughput and resource saturation. Database availability alone does not establish acceptable operational performance. Evidence to obtain: Alerts identify bottlenecks and response resolves tested workload degradation.
Incorrect Answers
A:Evaluate query plans and appropriate indexes while considering write and storage overhead. This response fits a separate situation (A report scans millions of rows although its date filter is selective and frequent.), but does not resolve the stated case. The targeted response is: Add performance monitoring for query latency, locks, throughput and resource saturation.
B:Plan compatibility tests, backup, failover or maintenance strategy and rollback verification. This response fits a separate situation (A security patch must be applied to a data store with a strict availability commitment.), but does not resolve the stated case. The targeted response is: Add performance monitoring for query latency, locks, throughput and resource saturation.
D:Monitor growth, plan capacity headroom and tune storage before outage. This response fits a separate situation (A database approaches disk exhaustion during a seasonal reporting surge.), but does not resolve the stated case. The targeted response is: Add performance monitoring for query latency, locks, throughput and resource saturation.
Question 461
Before changing procedures, the team investigates: A catalog tool identifies data owners but cannot force them to decide disputed definitions. Which review or test MOST directly locates the relevant failure?
- Inspect roadmap dependencies, funding, adoption measures and change readiness.
- Sample defects for root-cause evidence, risk acceptance and post-fix monitoring.
- Evaluate trained steward issue submissions against a documented handling standard.
- Check that catalog ownership links to actual issue decisions and approved definitions.
Explanation
Correct Answer
D:Check that catalog ownership links to actual issue decisions and approved definitions. This test checks the relevant business and technical failure rather than assuming its cause. Technology enables governance but cannot replace business authority and decisions. Expected control result: Tool records link approved decisions to datasets, issues and accountable people.
Incorrect Answers
A:Inspect roadmap dependencies, funding, adoption measures and change readiness. This check would investigate another issue (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not the immediate case. The direct diagnostic is: Check that catalog ownership links to actual issue decisions and approved definitions.
B:Sample defects for root-cause evidence, risk acceptance and post-fix monitoring. This check would investigate another issue (Data-quality defects recur because workers close tickets without addressing causes.), not the immediate case. The direct diagnostic is: Check that catalog ownership links to actual issue decisions and approved definitions.
C:Evaluate trained steward issue submissions against a documented handling standard. This check would investigate another issue (New business stewards do not understand how to document definitions or resolve data defects.), not the immediate case. The direct diagnostic is: Check that catalog ownership links to actual issue decisions and approved definitions.
Question 462
Which statement best describes the governing idea behind the response to this case: A business requests a temporary deviation from a sensitive data retention standard.
- Governed exceptions prevent informal departures from becoming permanent invisible risk.
- Governance effectiveness is measured by outcomes rather than meeting frequency.
- Governance includes enabling informed use of data, not merely producing datasets.
- Maturity is an evidence-based view of institutionalized practices, not aspirational claims.
Explanation
Correct Answer
A:Governed exceptions prevent informal departures from becoming permanent invisible risk. This concept explains the reason for the proposed control. Appropriate intervention: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
Incorrect Answers
B:Governance effectiveness is measured by outcomes rather than meeting frequency. This is a defensible principle in another context (Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.), not the most relevant rationale here. For the stated issue: Governed exceptions prevent informal departures from becoming permanent invisible risk.
C:This is a defensible principle in another context (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the most relevant rationale here. For the stated issue: Governed exceptions prevent informal departures from becoming permanent invisible risk.
D:Maturity is an evidence-based view of institutionalized practices, not aspirational claims. This is a defensible principle in another context (A consultant rates governance mature from interview opinions without supporting operational evidence.), not the most relevant rationale here. For the stated issue: Governed exceptions prevent informal departures from becoming permanent invisible risk.
Question 463
A business owner identifies this issue: A dataset is copied into three systems and each team claims another group owns quality. What is the MOST appropriate data management response?
- Define authoritative source and attribute-level ownership for producers and consumers.
- Identify critical data elements according to material reporting, operational and risk impact.
- Integrate governance decisions and stewardship workflows with technology support.
- Provide role-based training and supervised examples matched to assigned stewardship duties.
Explanation
Correct Answer
A:Define authoritative source and attribute-level ownership for producers and consumers. Data accountability must remain clear when information crosses system boundaries. Evidence to obtain: The ownership matrix identifies decision rights and contractual handoffs for each critical field.
Incorrect Answers
B:Identify critical data elements according to material reporting, operational and risk impact.
C:Integrate governance decisions and stewardship workflows with technology support. This response fits a separate situation (A catalog tool identifies data owners but cannot force them to decide disputed definitions.), but does not resolve the stated case. The targeted response is: Define authoritative source and attribute-level ownership for producers and consumers.
D:Provide role-based training and supervised examples matched to assigned stewardship duties. This response fits a separate situation (New business stewards do not understand how to document definitions or resolve data defects.), but does not resolve the stated case. The targeted response is: Define authoritative source and attribute-level ownership for producers and consumers.
Question 464
A reviewer asks for proof of improvement: A dataset is copied into three systems and each team claims another group owns quality. Which result MOST convincingly demonstrates that the control works?
- Local issues are resolved within authority and enterprise conflicts have a clear escalation route.
- Milestones show ownership uptake and validated quality/control improvements.
- An approved definition, accountable owner and escalation path resolve cross-team disagreements.
- The ownership matrix identifies decision rights and contractual handoffs for each critical field.
Explanation
Correct Answer
D:It tests the action: Define authoritative source and attribute-level ownership for producers and consumers.
Incorrect Answers
A:Local issues are resolved within authority and enterprise conflicts have a clear escalation route. This would verify a different control (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the one in the question. The required evidence is: The ownership matrix identifies decision rights and contractual handoffs for each critical field.
B:Milestones show ownership uptake and validated quality/control improvements. This would verify a different control (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not the one in the question. The required evidence is: The ownership matrix identifies decision rights and contractual handoffs for each critical field.
C:An approved definition, accountable owner and escalation path resolve cross-team disagreements. This would verify a different control (Two departments disagree about the authoritative definition of an active customer and neither can decide.), not the one in the question. The required evidence is: The ownership matrix identifies decision rights and contractual handoffs for each critical field.
Question 465
An accountable team must correct this problem and prove results. Select TWO sound statements: A backup contains confidential employee salaries and is stored without encryption controls.
- Verification: Stored backups are unreadable without authorized key access and restores succeed.
- Action: Encrypt backup data using approved keys with controlled key access and recovery procedures.
- Action: Apply governed masking or synthetic data that preserves testing requirements without exposing identities.
- Verification: A test export captures actor, dataset, time and authorized action in immutable evidence.
- Shortcut: Assume encryption without managed keys automatically solves all backup security issues.
Explanation
Correct Answers
A:Verification: Stored backups are unreadable without authorized key access and restores succeed. The observed result demonstrates whether the correction operates as intended. Encryption at rest reduces exposure of stored sensitive information but requires key governance.
B:Action: Encrypt backup data using approved keys with controlled key access and recovery procedures. The proposed intervention targets the reported issue. Encryption at rest reduces exposure of stored sensitive information but requires key governance.
Incorrect Answers
C:This intervention is for a different scenario (Test developers need representative orders but a test export includes real customer identity numbers.), not the one stated.
D:Verification: A test export captures actor, dataset, time and authorized action in immutable evidence. This evidence is for a separate context (Privileged database exports are possible but no one records who initiated them.), not this case. The valid outcome is: Stored backups are unreadable without authorized key access and restores succeed.
E:Shortcut: Assume encryption without managed keys automatically solves all backup security issues. This shortcut is not a sound remediation. Encryption at rest reduces exposure of stored sensitive information but requires key governance. The appropriate action is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
Question 466
A data analyst must confirm the cause of this issue: A catalog lists every dataset but half of its owners and descriptions are outdated. Which check provides the strongest diagnostic evidence?
- Test semantic queries, metric totals and join validity against sample facts.
- Compare catalog schemas with actual source files and pipeline expectations.
- Sample owner contacts, definitions, update dates and verified accuracy.
- Audit current systems against catalog lifecycle labels and successor links.
Explanation
Correct Answer
C:Sample owner contacts, definitions, update dates and verified accuracy. This test checks the relevant business and technical failure rather than assuming its cause. Metadata quality is a governable data-quality problem with measurable dimensions. Expected control result: Quality metrics identify stale records and verified repairs improve trust.
Incorrect Answers
A:Test semantic queries, metric totals and join validity against sample facts. This check would investigate another issue (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not the immediate case. The direct diagnostic is: Sample owner contacts, definitions, update dates and verified accuracy.
B:Compare catalog schemas with actual source files and pipeline expectations. This check would investigate another issue (A data engineering team cannot determine the format and schema of a nightly inbound file.), not the immediate case. The direct diagnostic is: Sample owner contacts, definitions, update dates and verified accuracy.
D:Audit current systems against catalog lifecycle labels and successor links. This check would investigate another issue (A retired system's catalog entries remain marked active, misleading new project teams.), not the immediate case. The direct diagnostic is: Sample owner contacts, definitions, update dates and verified accuracy.
Question 467
In reviewing this data risk, select the LEAST defensible practice: A BI analyst receives administrator access to production customer tables for simple reporting.
- Respect active legal holds before scheduling record disposition.
- Use a database superuser account for every analyst because approval is easier.
- Check that the proposed procedure has an identified operator and approval path.
- Monitor control outcomes after deployment rather than relying only on design intent.
Explanation
Correct Answer
B:Use a database superuser account for every analyst because approval is easier. Least privilege provides only the access required for an authorized purpose. A sound response instead: Grant narrow read access to approved views instead of broad administrative rights.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Grant narrow read access to approved views instead of broad administrative rights.
C:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Grant narrow read access to approved views instead of broad administrative rights.
D:Monitor control outcomes after deployment rather than relying only on design intent. Operations need evidence that a planned control actually works. The case-specific response is: Grant narrow read access to approved views instead of broad administrative rights.
Question 468
The data management team encounters this situation: Project teams repeatedly pick conflicting data integration styles for identical business needs. Which intervention BEST addresses the actual problem?
- Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
- Create agreed architecture principles and review exceptions through a decision process.
- Use a federated architecture with governed metadata and lawful cross-border access patterns.
- Agree enterprise-level business concepts and relationships before mapping physical application schemas.
Explanation
Correct Answer
B:Create agreed architecture principles and review exceptions through a decision process. Architecture principles make cross-project decisions consistent without prohibiting justified exceptions. Evidence to obtain: Decision records show when a common pattern is followed and why exceptions are justified.
Incorrect Answers
A:This response fits a separate situation (A regulatory metric cannot be reconciled to the systems that initially captured its values.), but does not resolve the stated case.
C:Use a federated architecture with governed metadata and lawful cross-border access patterns. This response fits a separate situation (A multinational has legal requirements to keep certain data local while enabling group analytics.), but does not resolve the stated case. The targeted response is: Create agreed architecture principles and review exceptions through a decision process.
D:Agree enterprise-level business concepts and relationships before mapping physical application schemas. This response fits a separate situation (Two departments use the term account for unrelated concepts and merge records incorrectly.), but does not resolve the stated case. The targeted response is: Create agreed architecture principles and review exceptions through a decision process.
Question 469
A data management auditor evaluates this situation: High-impact reconciliation defects are buried among hundreds of cosmetic warnings. Which observable finding supports successful remediation?
- Every accepted line references a valid invoice or has an owned exception.
- Critical defects receive timely escalation, correction and verifiable closure.
- Equivalent datasets are evaluated against the same approved country-code version.
- Invalid dates are blocked at entry and legitimate exceptions are traceable.
Explanation
Correct Answer
B:It tests the action: Risk-rank defects by business impact, assign owners and track remediation.
Incorrect Answers
A:Every accepted line references a valid invoice or has an owned exception. This would verify a different control (An invoice line appears without an invoice header after a partial load.), not the one in the question. The required evidence is: Critical defects receive timely escalation, correction and verifiable closure.
C:Equivalent datasets are evaluated against the same approved country-code version. This would verify a different control (Different pipelines enforce different allowable values for the same governed country field.), not the one in the question. The required evidence is: Critical defects receive timely escalation, correction and verifiable closure.
D:Invalid dates are blocked at entry and legitimate exceptions are traceable. This would verify a different control (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), not the one in the question. The required evidence is: Critical defects receive timely escalation, correction and verifiable closure.
Question 470
A data steward examines this condition: A BI analyst receives administrator access to production customer tables for simple reporting. What concept best justifies the corrective approach?
- Security controls should reflect classification and sensitivity, not storage location alone.
- Data security incidents require containment, evidence and accountable escalation.
- Least privilege provides only the access required for an authorized purpose.
- Row-level controls enforce instance-specific access beyond coarse table grants.
Explanation
Correct Answer
C:Least privilege provides only the access required for an authorized purpose. This concept explains the reason for the proposed control. Appropriate intervention: Grant narrow read access to approved views instead of broad administrative rights.
Incorrect Answers
A:This is a defensible principle in another context (A developer stores payment account numbers in a general-purpose dataset tagged public.), not the most relevant rationale here.
B:Data security incidents require containment, evidence and accountable escalation. This is a defensible principle in another context (An unauthorized service account downloads a large restricted dataset overnight.), not the most relevant rationale here. For the stated issue: Least privilege provides only the access required for an authorized purpose.
D:Row-level controls enforce instance-specific access beyond coarse table grants. This is a defensible principle in another context (Regional sales managers can query all customer records despite regional authorization rules.), not the most relevant rationale here. For the stated issue: Least privilege provides only the access required for an authorized purpose.