Which technology should a company utilize to consolidate data from multiple systems to support reporting and informed decision-making?

• A. Data lake
• B. Data warehouse
• C. Data mart
• D. Database cluster

Answer: (B)

A data warehouse is designed specifically for the purpose of consolidating data from multiple sources in a structured manner that supports reporting and analytics. This technology enables businesses to store large volumes of historical data, which can be easily queried and analyzed to support informed decision-making.

Data warehouses typically organize data into a schema that improves performance and usability for end-users, allowing them to run complex queries and generate reports effectively. The process of extracting, transforming, and loading (ETL) data into the warehouse ensures that the data is clean, consistent, and suitable for analysis.

In contrast, a data lake is more suited for storing large amounts of unstructured data and may not be optimized for reporting purposes. A data mart, while it serves a similar function, typically narrows its focus to a specific business line or department, which may limit its effectiveness in consolidating an organization-wide view of data. A database cluster, on the other hand, refers to a group of databases that work together to provide high availability and scalability, but it does not inherently support the consolidation and reporting of data across varying sources in the same way a data warehouse does.

Therefore, utilizing a data warehouse allows a company to effectively consolidate data from multiple systems, enabling richer analytics and informed decision-making