DA0-001 practice question 3 of 35

Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company. Which of the following systems is the most appropriate?

Full set: 361 questions

Domain Data Analysis

Answer options
A: OLTP.
B: OLAP.
C: Data warehouse. Correct answer
D: Data mart.
Correct Answer:
C. Data warehouse.
Explanation

The investigation requires analyzing integrated historical data from multiple, disparate business functions—manufacturing, marketing, and sales—to determine their impact on overall profitability. A data warehouse is the most appropriate system for this task. It is specifically designed to be a central repository that consolidates data from various operational systems across an enterprise. This integrated environment is optimized for complex queries, reporting, and business intelligence activities, enabling a holistic, cross-functional analysis of company performance, which is precisely what the scenario describes.

Why Incorrect

A. OLTP: Online Transaction Processing (OLTP) systems are designed for fast, high-volume, day-to-day operational tasks (e.g., recording a sale), not for complex, historical, cross-departmental analysis.
B. OLAP: Online Analytical Processing (OLAP) is the technology or methodology for performing multidimensional analysis. It operates on data typically stored in a data warehouse or data mart, but it is not the storage system itself.
D. Data mart: A data mart is a subset of a data warehouse focused on a single business line or department. It would be insufficient for an enterprise-wide analysis that integrates data from multiple departments.

References

1. Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26(1), 65-74. In Section 2, "Data Warehousing," the paper defines a data warehouse as an "integrated...collection of data in support of management's decision making process," contrasting it with operational OLTP databases. https://doi.org/10.1145/248603.248616

2. Inmon, W. H. (2005). Building the Data Warehouse (4th ed.). Wiley. In Chapter 1, "The Data Warehouse Environment," Inmon establishes that a key characteristic of a data warehouse is that it is "integrated," meaning it brings together data from different, often heterogeneous, source systems into a single, consistent corporate view.

3. Oracle. (n.d.). Data Warehousing Concepts. Oracle Database Concepts, 19c. In the section "What Is a Data Warehouse?", the documentation states, "A data warehouse...enables an organization to consolidate data from several sources," which is essential for analyzing the combined impact of manufacturing, marketing, and sales.

Scroll to Top