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 questionsDomain Data Analysis
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.
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.
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.
Keep practicing
Take the free DA0-001 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DA0-001 practice questions
- Question 1Which of the following data analysis tools increases the efficiency of data visualization…
- Question 4Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600 Which of the…
- Question 7A research analyst wants to determine whether the data being analyzed is connected to oth…
- Question 8Mario works with a group of R programmers tasked with copying data from an accounting sys…
- Question 9What would be an example of an acceptable form of primary identification for the Data+ ex…
- Question 10A financial institution is reporting on sales performance to a company at the account lev…
