CDMP DMF Practice Test 79
Question 780
Consider this organizational data problem: Privileged database exports are possible but no one records who initiated them. What action is most defensible?
- Classify sensitive fields and apply controls aligned to business and regulatory risk.
- Require authenticated encrypted transport using supported TLS configuration.
- Encrypt backup data using approved keys with controlled key access and recovery procedures.
- Enable protected access and export audit logs with appropriate retention and review.
Explanation
Correct Answer
D:Enable protected access and export audit logs with appropriate retention and review. Auditability complements prevention by making sensitive operations attributable. Evidence to obtain: A test export captures actor, dataset, time and authorized action in immutable evidence.
Incorrect Answers
A:Classify sensitive fields and apply controls aligned to business and regulatory risk. This response fits a separate situation (A developer stores payment account numbers in a general-purpose dataset tagged public.), but does not resolve the stated case. The targeted response is: Enable protected access and export audit logs with appropriate retention and review.
B:Require authenticated encrypted transport using supported TLS configuration. This response fits a separate situation (A service transfers customer attributes over unencrypted HTTP between data centers.), but does not resolve the stated case. The targeted response is: Enable protected access and export audit logs with appropriate retention and review.
C:Encrypt backup data using approved keys with controlled key access and recovery procedures. This response fits a separate situation (A backup contains confidential employee salaries and is stored without encryption controls.), but does not resolve the stated case. The targeted response is: Enable protected access and export audit logs with appropriate retention and review.
Question 781
A data steward examines this condition: Metadata lives in individual spreadsheets that differ on owners and field meanings. What concept best justifies the corrective approach?
- A metadata repository supports shared, managed descriptions across assets.
- A business glossary aligns organizational terminology and semantic context.
- Business metadata describes meaning, purpose, ownership and policy context.
- Metadata dependency mapping enables informed change management.
Explanation
Correct Answer
A:A metadata repository supports shared, managed descriptions across assets. This concept explains the reason for the proposed control. Appropriate intervention: Use a governed repository or catalog with stewardship workflows and controlled synchronization.
Incorrect Answers
B:A business glossary aligns organizational terminology and semantic context. This is a defensible principle in another context (A term called revenue means gross receipts in one team and net receipts in another.), not the most relevant rationale here. For the stated issue: A metadata repository supports shared, managed descriptions across assets.
C:Business metadata describes meaning, purpose, ownership and policy context. This is a defensible principle in another context (Analysts cannot tell whether customer_age means current age or age at first purchase.), not the most relevant rationale here. For the stated issue: A metadata repository supports shared, managed descriptions across assets.
D:Metadata dependency mapping enables informed change management. This is a defensible principle in another context (A team plans to remove a source column that feeds several dashboards and fraud rules.), not the most relevant rationale here. For the stated issue: A metadata repository supports shared, managed descriptions across assets.
Question 782
Consider this data-management scenario: One interface calls a field supplier_id while another calls it vendor_code with different identifier rules. Which underlying principle MOST directly explains the preferred response?
- Batch, messaging and service APIs meet different business service levels.
- CDC depends on correct change ordering and consumption state across failures.
- Data integration reliability requires observable completeness and repeatable recovery.
- Data interoperability requires shared semantics even when field names differ.
Explanation
Correct Answer
D:Data interoperability requires shared semantics even when field names differ. This concept explains the reason for the proposed control. Appropriate intervention: Define an agreed canonical mapping with meaning, transform ownership and validation.
Incorrect Answers
A:This is a defensible principle in another context (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the most relevant rationale here. For the stated issue: Data interoperability requires shared semantics even when field names differ.
B:CDC depends on correct change ordering and consumption state across failures. This is a defensible principle in another context (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the most relevant rationale here. For the stated issue: Data interoperability requires shared semantics even when field names differ.
C:Data integration reliability requires observable completeness and repeatable recovery. This is a defensible principle in another context (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the most relevant rationale here. For the stated issue: Data interoperability requires shared semantics even when field names differ.
Question 783
The data program reviews the following failure: A customer changes region but analysts need sales under the region valid at each transaction date. Which change should be prioritized?
- Model history with effective-dated dimension versions when historical attribution matters.
- Apply naming, glossary mapping and controlled definitions to important model elements.
- Declare a single fact grain and separate or aggregate measures consistently.
- Enforce appropriate referential integrity and define valid deletion behavior.
Explanation
Correct Answer
A:Model history with effective-dated dimension versions when historical attribution matters. Temporal modeling preserves time-dependent truth needed for historical analysis. Evidence to obtain: Historical sales continue to use the correct prior region while current records use the new one.
Incorrect Answers
B:Apply naming, glossary mapping and controlled definitions to important model elements. This response fits a separate situation (Teams use inconsistent definitions for status and state across logical models.), but does not resolve the stated case. The targeted response is: Model history with effective-dated dimension versions when historical attribution matters.
C:Declare a single fact grain and separate or aggregate measures consistently. This response fits a separate situation (A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures.), but does not resolve the stated case. The targeted response is: Model history with effective-dated dimension versions when historical attribution matters.
D:Enforce appropriate referential integrity and define valid deletion behavior. This response fits a separate situation (An order line references a product identifier that does not exist in the product table.), but does not resolve the stated case. The targeted response is: Model history with effective-dated dimension versions when historical attribution matters.
Question 784
Consider this organizational data problem: Two customer sources disagree about legal name after one verifies recent government ID. What action is most defensible?
- Assign a data owner and stewardship process for supplier master definitions and changes.
- Define survivorship rules that favor verified recent evidence with traceable provenance.
- Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
- Manage reference data as effective-dated versions with historical mapping support.
Explanation
Correct Answer
B:Define survivorship rules that favor verified recent evidence with traceable provenance. Golden-record construction applies business rules to conflicting source attributes. Evidence to obtain: The golden record uses the justified name and records competing values and sources.
Incorrect Answers
A:Assign a data owner and stewardship process for supplier master definitions and changes.
C:Validate hierarchy acyclicity, permitted parents and effective dates before publishing. This response fits a separate situation (A new organizational hierarchy update accidentally makes Division A the parent of itself through B.), but does not resolve the stated case. The targeted response is: Define survivorship rules that favor verified recent evidence with traceable provenance.
D:Manage reference data as effective-dated versions with historical mapping support. This response fits a separate situation (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), but does not resolve the stated case. The targeted response is: Define survivorship rules that favor verified recent evidence with traceable provenance.
Question 785
The data program reviews the following failure: Teams use inconsistent definitions for status and state across logical models. Which change should be prioritized?
- Model phone numbers as atomic repeating child records with appropriate identifiers.
- Model history with effective-dated dimension versions when historical attribution matters.
- Apply naming, glossary mapping and controlled definitions to important model elements.
- Declare a single fact grain and separate or aggregate measures consistently.
Explanation
Correct Answer
C:Apply naming, glossary mapping and controlled definitions to important model elements. Naming standards improve understandability but must reflect precise meanings. Evidence to obtain: Consumers distinguish business lifecycle state from technical processing status.
Incorrect Answers
A:Model phone numbers as atomic repeating child records with appropriate identifiers. This response fits a separate situation (A contact table stores three comma-separated telephone numbers in one column.), but does not resolve the stated case. The targeted response is: Apply naming, glossary mapping and controlled definitions to important model elements.
B:Model history with effective-dated dimension versions when historical attribution matters. This response fits a separate situation (A customer changes region but analysts need sales under the region valid at each transaction date.), but does not resolve the stated case. The targeted response is: Apply naming, glossary mapping and controlled definitions to important model elements.
D:Declare a single fact grain and separate or aggregate measures consistently. This response fits a separate situation (A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures.), but does not resolve the stated case. The targeted response is: Apply naming, glossary mapping and controlled definitions to important model elements.
Question 786
After addressing this problem, what evidence would justify closure? A fraud team receives transaction events forty minutes after its five-minute alert deadline.
- New records arrive with supplier IDs and recurrence drops after monitoring.
- The scorecard shows distinct dimension measures and decision-relevant targets.
- End-to-end event latency meets the defined threshold for relevant transactions.
- Critical defects receive timely escalation, correction and verifiable closure.
Explanation
Correct Answer
C:It tests the action: Measure freshness and repair event-delivery latency against business requirements.
Incorrect Answers
A:New records arrive with supplier IDs and recurrence drops after monitoring. This would verify a different control (An analyst manually fixes the same missing supplier IDs every week.), not the one in the question. The required evidence is: End-to-end event latency meets the defined threshold for relevant transactions.
B:The scorecard shows distinct dimension measures and decision-relevant targets. This would verify a different control (A postal address field is 100 percent complete but several entries are no longer current.), not the one in the question. The required evidence is: End-to-end event latency meets the defined threshold for relevant transactions.
D:Critical defects receive timely escalation, correction and verifiable closure. This would verify a different control (High-impact reconciliation defects are buried among hundreds of cosmetic warnings.), not the one in the question. The required evidence is: End-to-end event latency meets the defined threshold for relevant transactions.
Question 787
A data steward challenges an assumption in this case: A composite-key enrollment table repeats course title determined by course_id alone. Which verification should be performed first?
- Inspect missing-value rules and test calculations with unknown and genuine zero.
- Test change propagation, stale-data exposure and measured query performance.
- Inspect key dependencies, normalization and a department rename test.
- Check functional dependencies and update anomalies across enrollment data.
Explanation
Correct Answer
D:Check functional dependencies and update anomalies across enrollment data. This test checks the relevant business and technical failure rather than assuming its cause. Second normal form removes partial dependencies on composite candidate keys. Expected control result: Course title updates occur once and enrollment rows retain correct course links.
Incorrect Answers
A:Inspect missing-value rules and test calculations with unknown and genuine zero. This check would investigate another issue (A registration field is blank, but downstream calculations treat unknown age as zero.), not the immediate case. The direct diagnostic is: Check functional dependencies and update anomalies across enrollment data.
B:Test change propagation, stale-data exposure and measured query performance. This check would investigate another issue (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), not the immediate case. The direct diagnostic is: Check functional dependencies and update anomalies across enrollment data.
C:Inspect key dependencies, normalization and a department rename test. This check would investigate another issue (An employee table stores department name determined by department_id, causing inconsistent renames.), not the immediate case. The direct diagnostic is: Check functional dependencies and update anomalies across enrollment data.
Question 788
Consider this organizational data problem: New business stewards do not understand how to document definitions or resolve data defects. What action is most defensible?
- Provide role-based training and supervised examples matched to assigned stewardship duties.
- Translate principles into measurable standards, owner responsibilities and repeatable procedures.
- Separate accountable owner decisions from stewardship coordination and operational execution.
- Convene an authorized cross-functional council to make and escalate policy decisions.
Explanation
Correct Answer
A:Provide role-based training and supervised examples matched to assigned stewardship duties. Stewardship capability requires practice and accountability, not titles alone. Evidence to obtain: Completed exercises demonstrate consistent definition updates and issue routing.
Incorrect Answers
B:Translate principles into measurable standards, owner responsibilities and repeatable procedures. This response fits a separate situation (A company has a general policy promising accurate data but no operational validation thresholds.), but does not resolve the stated case. The targeted response is: Provide role-based training and supervised examples matched to assigned stewardship duties.
C:Separate accountable owner decisions from stewardship coordination and operational execution. This response fits a separate situation (A product data owner expects the data steward to set commercial policy unilaterally.), but does not resolve the stated case. The targeted response is: Provide role-based training and supervised examples matched to assigned stewardship duties.
D:Convene an authorized cross-functional council to make and escalate policy decisions. This response fits a separate situation (Customer and finance functions cannot agree on shared priority data rules.), but does not resolve the stated case. The targeted response is: Provide role-based training and supervised examples matched to assigned stewardship duties.
Question 789
Consider this data-management scenario: A file-transfer integration includes confidential customer attributes in an unsecured staging bucket. Which underlying principle MOST directly explains the preferred response?
- Batch, messaging and service APIs meet different business service levels.
- ELT moves transformation into the target platform but does not remove data quality obligations.
- At-least-once delivery requires consumers to tolerate duplicate messages.
- Integration pipelines create new security exposure at movement and landing points.
Explanation
Correct Answer
D:Integration pipelines create new security exposure at movement and landing points. This concept explains the reason for the proposed control. Appropriate intervention: Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
Incorrect Answers
A:This is a defensible principle in another context (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the most relevant rationale here. For the stated issue: Integration pipelines create new security exposure at movement and landing points.
B:This is a defensible principle in another context (An analytics platform loads source extracts into a warehouse then performs transformations there.), not the most relevant rationale here. For the stated issue: Integration pipelines create new security exposure at movement and landing points.
C:This is a defensible principle in another context (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), not the most relevant rationale here. For the stated issue: Integration pipelines create new security exposure at movement and landing points.
Question 790
A data analyst must confirm the cause of this issue: A developer stores payment account numbers in a general-purpose dataset tagged public. Which check provides the strongest diagnostic evidence?
- Test different identities through both dashboards and direct data access paths.
- Test role grants with allowed reporting and prohibited update queries.
- Inspect classification lineage, access grants and unauthorized read attempts.
- Inspect storage encryption status, key access logs and a restoration test.
Explanation
Correct Answer
C:Inspect classification lineage, access grants and unauthorized read attempts. This test checks the relevant business and technical failure rather than assuming its cause. Security controls should reflect classification and sensitivity, not storage location alone. Expected control result: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
Incorrect Answers
A:Test different identities through both dashboards and direct data access paths. This check would investigate another issue (Regional sales managers can query all customer records despite regional authorization rules.), not the immediate case. The direct diagnostic is: Inspect classification lineage, access grants and unauthorized read attempts.
B:Test role grants with allowed reporting and prohibited update queries. This check would investigate another issue (A BI analyst receives administrator access to production customer tables for simple reporting.), not the immediate case. The direct diagnostic is: Inspect classification lineage, access grants and unauthorized read attempts.
D:Inspect storage encryption status, key access logs and a restoration test. This check would investigate another issue (A backup contains confidential employee salaries and is stored without encryption controls.), not the immediate case. The direct diagnostic is: Inspect classification lineage, access grants and unauthorized read attempts.