DA0-001 Question #251: Real Exam Question with Answer & Explanation

Question

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?

Options

• AAssume the data was blended together and wait for feedback.
• BFilter on every column to look for inconsistencies in the data.
• CSpot check a few numbers to look for inconsistencies.
• DReview the files separately and ensure the blended totals match.

Explanation

To efficiently verify the accuracy of merged datasets, reviewing the original files separately and confirming that their aggregated totals correctly sum up to the blended total is the most effective approach. This method provides a high-level validation of data integration without needing to inspect every detail.

Common mistakes.

• A. Assuming data accuracy without verification is highly risky and unprofessional, potentially leading to incorrect reporting.
• B. Filtering on every column to look for inconsistencies would be an extremely time-consuming and inefficient process for a large dataset, making it impractical for initial verification.
• C. Spot checking a few numbers might catch some inconsistencies, but it's not thorough enough to ensure the overall integrity and accuracy of a large blended dataset.

Concept tested. Data quality assurance - data blending verification

Reference. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-combine-data-with-power-bi-desktop

No community discussion yet for this question.