CAF-3 · Chapter 6 · Question 13 of 15
An enterprise wants to integrate its 'Sales' process and its 'Inventory' process into one analytical model. The database designer creates an architecture with two separate fact tables that share the same dimension tables (like Time and Product). This complex structure is known as a:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) Galaxy Schema (Fact Constellation)
Explanation
A Galaxy Schema (or Fact Constellation) contains two or more fact tables that share common dimension tables, enabling integrated analysis across multiple business processes
More Data Warehouse Schemas & Data Marts MCQs
- Q15The Marketing Department of a large corporation finds the main enterprise data warehouse too massive and slow for their specific daily…
- Q1An organization’s customer database frequently suffers from update anomalies because the same customer’s address is stored in multiple…
- 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…