What should be of MOST concern to an IS auditor reviewing an organization's proposal to combine its online transaction processing (OLTP) data and data warehouse in the same database environment?
Click on the arrows to vote for the correct answer
A. B. C. D.C.
The proposal to combine online transaction processing (OLTP) data and data warehouse in the same database environment could have significant implications for an organization's data management and IT infrastructure. As an IS auditor reviewing this proposal, the most critical concern should be related to the potential risks associated with the proposed changes.
A. The quality of business intelligence reporting may be impacted:
Combining OLTP and data warehouse data in the same database environment may have a significant impact on the quality of business intelligence reporting. OLTP systems are designed to process and store real-time transactional data, while data warehouses are used to store historical data that can be used for analysis and reporting. Combining these two types of data in the same database environment could lead to data inconsistencies, duplication, and other issues that could impact the accuracy of business intelligence reporting. This concern is therefore relevant, but not the MOST critical.
B. A significant amount of data computing resources will be required:
Combining OLTP and data warehouse data in the same database environment would require a significant amount of computing resources. OLTP systems typically require high-performance computing and fast data access, while data warehouses need a lot of storage space and processing power. The combination of these two systems could lead to an increased demand for computing resources, which could impact the performance of the system and increase operational costs. This is a critical concern because the organization may need to invest in additional hardware and software resources to support the proposed changes.
C. The combination of static data with dynamic data could reduce data quality:
Combining static data from a data warehouse with dynamic data from an OLTP system in the same database environment could lead to a reduction in data quality. OLTP systems typically contain up-to-date, real-time data, while data warehouses store historical data that is not updated frequently. The combination of these two types of data could lead to inconsistencies, duplication, and other issues that could impact data quality. This is also a relevant concern, but not as critical as the computing resources required.
D. The complexity of the solution could lead to delays in deployment:
Combining OLTP and data warehouse data in the same database environment is a complex task that requires careful planning and execution. The organization may face significant challenges related to data migration, system integration, and other issues that could delay the deployment of the new system. This concern is also relevant, but not as critical as the computing resources required.
In conclusion, the MOST critical concern for an IS auditor reviewing an organization's proposal to combine its OLTP data and data warehouse in the same database environment is the significant amount of data computing resources that will be required. This proposal could lead to increased operational costs and performance issues if not planned and executed carefully.