Certification Exam Study Guide & Practice Test
2026/2027 | Data Management and Governance |
Statistical Techniques | Data Validation & Evaluation |
Data Visualization | Predictive Analytics | Data Analytics
Methods | Practice Questions, Answers & Detailed
Rationales.
**Question 1: Which data quality dimension is concerned with whether the
values that must be present are actually present, field by field and record by
record? **
A. Validity
B. Completeness
C. Timeliness
D. Consistency
**CORRECT ANSWER: B. Completeness**
Rationale: Completeness measures whether required values are present across
fields and records. Validity tests conformance to a defined domain or format,
timeliness measures whether data reaches the consumer when it is still useful for
the decision, and consistency concerns agreement across sources or records.
**Question 2: A postcode field accepts only entries that match a national format
check. Which data quality dimension does this control primarily enforce?**
A. Timeliness
,B. Completeness
C. Validity
D. Uniqueness
**CORRECT ANSWER: C. Validity**
Rationale: Validity tests whether a value conforms to the defined domain, format,
or range. A national postcode format check is a validity rule because it constrains
the acceptable form of the value rather than merely checking presence or arrival
time.
**Question 3: What is the primary purpose of data profiling in a Vantage analytics
environment?**
A. To establish what the data actually contains as evidence for quality judgement
B. To replace all manual data quality rules with automated remediation
C. To guarantee that every column is perfectly populated
D. To archive historical data for regulatory retention
**CORRECT ANSWER: A. To establish what the data actually contains as evidence
for quality judgement**
Rationale: Profiling establishes what the data actually contains, which is the
evidence on which any quality judgement must rest. It does not by itself
remediate data or guarantee completeness; it provides the factual basis for later
quality decisions.
,**Question 4: Who is accountable for the definition, quality, and approved use of
a data domain?**
A. The data steward
B. The database administrator
C. The data owner
D. The reporting analyst
**CORRECT ANSWER: C. The data owner**
Rationale: Accountability sits with the data owner, an accountable business role
rather than a hands-on one. A steward applies the standards but does not own
the domain or answer for it.
**Question 5: What does a data dictionary record for each attribute?**
A. The names of analysts who have queried it
B. Its definition, format, permitted values, and owner
C. The cost of storing the attribute on disk
D. The fastest query band used against it
**CORRECT ANSWER: B. Its definition, format, permitted values, and owner**
Rationale: A data dictionary is the shared contract on meaning, so definition,
format, domain, and ownership are its core content. Query history and storage
cost are operational facts, not the meaning of the attribute.
, **Question 6: What does data lineage trace?**
A. Where a value came from and how it changed
B. How many rows the table will hold next year
C. Which business unit pays for storage
D. Which user holds the fastest query band
**CORRECT ANSWER: A. Where a value came from and how it changed**
Rationale: Lineage traces data from source to report, including the
transformations applied along the way. Volume forecasts and chargeback are
planning facts rather than the path of the data.
**Question 7: Why is data classified into sensitivity tiers before access is
granted?**
A. Every record can then be encrypted with the same key
B. The storage cost falls as the tier rises
C. Controls can be made proportionate to the harm of disclosure
D. All users can be granted permanent read access at induction
**CORRECT ANSWER: C. Controls can be made proportionate to the harm of
disclosure**