A data governance team needs to report on the quality of the 'employee' table. They want to show the percentage of records where the 'salary' field is not null and the percentage of records where the 'department' field matches a value in the official department lookup table. Which two metrics should they calculate?

Completeness rate for 'salary' and validity rate for 'department'

Accuracy rate for 'salary' and consistency rate for 'department'

Integrity rate for 'salary' and volatility rate for 'department'

Uniqueness rate for 'salary' and timeliness rate for 'department'

A data quality assessment reveals that 30% of customer address records have a missing postal code. The data governance team needs to improve this metric. Which strategy is most likely to be effective as a long-term improvement?

Implement a mandatory validation rule in the data entry application that requires a postal code and uses an address lookup service to auto-fill it

Exclude records with missing postal codes from all future analyses

Run a one-time SQL update to populate missing postal codes based on the city and state fields

Document the issue in the data dictionary and take no further action

CompTIAData+

Domain 5Objective 4

Implement Quality Assurance DA0-001 Practice Questions (Page 6)

Part of the Data governance domain, which accounts for 14% of the DA0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~5–8 in this domain), expect 1–2 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

7concepts

14%of the exam

Questions 26–30

26application · medium
A data governance team needs to report on the quality of the 'employee' table. They want to show the percentage of records where the 'salary' field is not null and the percentage of records where the 'department' field matches a value in the official department lookup table. Which two metrics should they calculate?
Select an answer first
27foundation · easy
Which data quality metric measures the percentage of records that contain all required fields?
Select an answer first
28foundation · easy
A data team wants to receive automated notifications when the percentage of missing values in a critical column exceeds 5%. Which data monitoring technique should they implement?
Select an answer first
29foundation · easy
During data profiling, an analyst discovers that the 'birth_date' column contains values that are in the future. What type of data quality issue is this?
Select an answer first
30application · medium
A data quality assessment reveals that 30% of customer address records have a missing postal code. The data governance team needs to improve this metric. Which strategy is most likely to be effective as a long-term improvement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DA0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DA0-001” is a trademark of its owner, used for identification only.

Implement Quality Assurance DA0-001 Practice Questions (Page 6)

Questions 26–30

Which data quality metric measures the percentage of records that contain all required fields?

A data team wants to receive automated notifications when the percentage of missing values in a critical column exceeds 5%. Which data monitoring technique should they implement?

During data profiling, an analyst discovers that the 'birth_date' column contains values that are in the future. What type of data quality issue is this?

A data quality assessment reveals that 30% of customer address records have a missing postal code. The data governance team needs to improve this metric. Which strategy is most likely to be effective as a long-term improvement?

Keep studying — Data governance