DA0-001 · Question #353
DA0-001 Question #353: Real Exam Question with Answer & Explanation
The correct answer is C: The report included the previous month's data.. If this month's revenue report values are twice as much as last month's, it most likely indicates that data from the previous month was erroneously included and duplicated in the current month's report during the ETL process.
Question
The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?
Options
- AThe data cleansing processes failed to execute.
- BThe database connectivity failed.
- CThe report included the previous month's data.
- DThe data normalization processes failed.
Explanation
If this month's revenue report values are twice as much as last month's, it most likely indicates that data from the previous month was erroneously included and duplicated in the current month's report during the ETL process.
Common mistakes.
- A. Failure of data cleansing processes might lead to inaccurate or inconsistent data, but it's less likely to systematically double the total values across the board.
- B. Database connectivity failure would typically prevent any data from being loaded or reported, not result in doubled values.
- D. Failure of data normalization processes would more likely lead to data redundancy, integrity issues, or inefficient storage, but not necessarily a systematic doubling of aggregated report values.
Concept tested. ETL data quality issues - Duplication
Topics
Community Discussion
No community discussion yet for this question.