Certified Information Systems Auditor (CISA) — Question 1294

In data warehouse (DW) management, what is the BEST way to prevent data quality issues caused by changes from a source system?

Answer options

• A. Restrict access to changes in the extract/transfer/load (ETL) process between the two systems
• B. Include the data warehouse m the impact analysis for any changes in the source system
• C. Configure data quality alerts to check variances between the data warehouse and the source system
• D. Require approval for changes in the extract/transfer/load (ETL) process between the two systems

Correct answer: B

Explanation

The correct answer, B, emphasizes the importance of including the data warehouse in impact analyses, helping to identify potential data quality issues proactively. Options A and D focus on restricting or controlling changes, which may not address the root cause of data quality issues. Option C, while useful for monitoring, does not prevent issues from occurring in the first place.