ExamGecko
Question list
Search
Search

Related questions











Question 242 - CISA discussion

Report
Export

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

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

Explanation:

Including the data warehouse in the impact analysis for any changes in the source system is the best way to prevent data quality issues caused by changes from a source system. A data warehouse is a centralized repository of integrated data from one or more source systems. An impact analysis is a technique of assessing the potential effects and consequences of a change on the existing system or environment. Including the data warehouse in the impact analysis can help to identify and mitigate any data quality issues that may arise from changes in the source system, such as data inconsistency, incompleteness, or inaccuracy. The other options are less effective ways to prevent data quality issues, as they may involve data quality alerts, approval for changes, or access restrictions.Reference:

CISA Review Manual (Digital Version), Chapter 5, Section 5.41

CISA Review Questions, Answers & Explanations Database, Question ID 226

asked 18/09/2024
Daniel Ramirez
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first