Certified Information Systems Auditor (CISA) — Question 1357

Which of the following would BEST integrate multiple data warehouses while reducing the workload required for moving data between the warehouses?

Answer options

• A. Extract, transform, and load
• B. Data virtualization
• C. Real-time data mirroring
• D. Streaming data integration

Correct answer: B

Explanation

Data virtualization allows for a unified view of data across multiple warehouses without physically moving it, which significantly reduces workload. In contrast, Extract, transform, and load (ETL) involves moving data, which can be more resource-intensive. Real-time data mirroring and streaming data integration also require more effort in terms of managing data movement compared to data virtualization.