CAF-3 · Chapter 6 · Question 15 of 15
The Marketing Department of a large corporation finds the main enterprise data warehouse too massive and slow for their specific daily campaign reporting. To solve this, IT builds them a smaller, customized subset of the warehouse containing only marketing-related data. This subset is called a:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) Data Mart
Explanation
A Data Mart is a tailored subset of a data warehouse designed to provide faster, focused access to specific business units or departments (like Marketing or HR)
More Data Warehouse Schemas & Data Marts MCQs
- Q2A bank's database table stores a customer's 'Phone Number' attribute. However, several customers have submitted two or three phone…
- Q3A retail company’s 'Order Details' table uses a composite primary key consisting of both OrderID and ProductID. However, the attribute…
- Q4In an employee database, the EmployeeID is the primary key. The table includes a DepartmentID column and a DepartmentLocation column. The…
- Q5When designing a database, an IT team debates whether to fully normalize the data or leave it partially denormalized. What is the primary…
- Q6A nationwide supermarket chain processes tens of thousands of customer checkout transactions every hour. The system must quickly insert…