CompTIA Data+ (DA0-001) — Question 275

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?

Answer options

• A. The data cleansing processes failed to execute.
• B. The database connectivity failed.
• C. The report included the previous month's data.
• D. The data normalization processes failed.

Correct answer: C

Explanation

The correct answer is C because including last month's data in this month's report would logically result in values that are twice as high. Options A and D relate to failures that would typically prevent accurate data from being reported, while B concerns connectivity issues that would not directly lead to inflated revenue figures.