A company's customer database has a 15% duplicate rate for customer records, causing marketing campaigns to send duplicate emails. The data governance team has limited budget and needs to improve the uniqueness metric. They have identified that most duplicates come from the same sales team entering data manually. Which improvement strategy is the most effective combination of prevention and remediation?

Create a monthly report that lists all duplicate records for manual review

Implement a deduplication rule in the CRM that blocks saving a new record if a similar name and email already exists, and run a one-time merge of existing duplicates

Train the sales team on the importance of data quality and ask them to be more careful

Run a one-time SQL script to delete all duplicate records based on email address

A data quality monitoring dashboard shows that the 'customer_email' field has a sudden spike in records that do not match the standard email pattern. The analyst needs to determine if this is a one-time event or a recurring problem. What is the most appropriate next step?

Ignore the spike because monitoring dashboards often produce false positives

Investigate the source system and the time window of the affected records to identify the root cause

Immediately delete all records with invalid emails to clean the database

Increase the alert threshold so the dashboard stops flagging these records

A data governance team wants to track the quality of their customer master data over time. They have decided to measure the percentage of records with a valid email address format and the percentage of records with a unique customer ID. Which pair of data quality metrics are they defining?

Consistency rate and timeliness rate

Integrity rate and volatility rate

Completeness rate and accuracy rate

Validity rate and uniqueness rate

An analyst is profiling a large dataset and finds that the 'age' column has a minimum value of -5 and a maximum value of 200. The analyst also notices that 10% of the values are exactly 0. The business rule states that age must be between 0 and 120. What is the most appropriate conclusion from this profiling exercise?

The column is complete because every record has a value

The column has validity issues (out-of-range values) and potential completeness issues (0 may represent missing data), requiring further investigation

The column is accurate because the profiling shows the full range of values

The column is consistent because all values are numeric

CompTIAData+

Domain 5Objective 4

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

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 6–10

6expert · hard
A company's customer database has a 15% duplicate rate for customer records, causing marketing campaigns to send duplicate emails. The data governance team has limited budget and needs to improve the uniqueness metric. They have identified that most duplicates come from the same sales team entering data manually. Which improvement strategy is the most effective combination of prevention and remediation?
Select an answer first
7application · medium
A data quality monitoring dashboard shows that the 'customer_email' field has a sudden spike in records that do not match the standard email pattern. The analyst needs to determine if this is a one-time event or a recurring problem. What is the most appropriate next step?
Select an answer first
8application · medium
A data governance team wants to track the quality of their customer master data over time. They have decided to measure the percentage of records with a valid email address format and the percentage of records with a unique customer ID. Which pair of data quality metrics are they defining?
Select an answer first
9expert · hard
An analyst is profiling a large dataset and finds that the 'age' column has a minimum value of -5 and a maximum value of 200. The analyst also notices that 10% of the values are exactly 0. The business rule states that age must be between 0 and 120. What is the most appropriate conclusion from this profiling exercise?
Select an answer first
10foundation · easy
Which strategy is commonly used to improve data quality by standardizing formats, correcting values, and removing duplicates?
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 2)

Questions 6–10

A data quality monitoring dashboard shows that the 'customer_email' field has a sudden spike in records that do not match the standard email pattern. The analyst needs to determine if this is a one-time event or a recurring problem. What is the most appropriate next step?

A data governance team wants to track the quality of their customer master data over time. They have decided to measure the percentage of records with a valid email address format and the percentage of records with a unique customer ID. Which pair of data quality metrics are they defining?

Which strategy is commonly used to improve data quality by standardizing formats, correcting values, and removing duplicates?

Keep studying — Data governance