Exam CISA topic 1 question 792 discussion

Actual exam question from Isaca's CISA

Question #: 792
Topic #: 1

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

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

Show Suggested Answer

Suggested Answer: B 🗳️

by Deeplaxmi at Sept. 24, 2022, 5:45 a.m.

Comments

Submit Cancel

maxson69

1 month, 3 weeks ago

Selected Answer: B

To proactively maintain data quality, the data warehouse team must be part of the impact analysis for any changes to the source systems. This prevents issues before they occur, making B the best answer.

upvoted 1 times

...

Swallows

1 year, 2 months ago

Selected Answer: B

This approach ensures that any changes made to the source system are thoroughly analyzed for their potential impact on the data warehouse. By including the data warehouse in the impact analysis process, stakeholders can assess how changes might affect data integrity, structure, or quality within the DW environment. It allows for proactive measures to be taken to mitigate potential risks and maintain data quality standards.

upvoted 3 times

...