CompTIA Data+ (DA0-001) — Question 169

Company A recently merged with Company B and will be reporting first quarter numbers soon. Prior to the release, an analyst wants to ensure the data was accurately blended together. Which of the following is the MOST efficient way to ensure the data is reported correctly?

Answer options

• A. Assume the data was blended together and wait for feedback.
• B. Filter on every column to look for inconsistencies in the data.
• C. Spot check a few numbers to look for inconsistencies.
• D. Review the files separately and ensure the blended totals match.

Correct answer: D

Explanation

The correct answer, D, is optimal because it ensures that the totals from both companies match, confirming accurate data blending. Options A and C are insufficient as they either rely on assumptions or only check a few values, which may overlook significant discrepancies. Option B, while thorough, is inefficient as it requires filtering every column instead of focusing on the overall totals.