DA0-001 · Question #353
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?
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.
How the community answered
(38 responses)- A13% (5)
- B3% (1)
- C76% (29)
- D8% (3)
Why each option
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.
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.
Database connectivity failure would typically prevent any data from being loaded or reported, not result in doubled values.
When a report shows values exactly double what is expected (e.g., twice last month's total), a common ETL issue is data duplication, where the same data (like last month's revenue) is processed and added multiple times for the current period. This can happen if the ingestion logic incorrectly pulls and aggregates historical data along with current data, leading to inflated totals.
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.