/
Kimball Architecture
Save to my account
Sign up
Kimball Architecture
View
Lect2_ DWArchitectures..pdf Flashcards
Study
1
Question
What is the main focus of Ralph Kimball's approach to Data Warehousing?
Answer
The purpose of a Data Warehouse is a copy of transaction data specifically structured for query and analysis.
2
Question
What does Kimball's approach to Data Warehousing emphasize in terms of understanding?
Answer
Understand and document the business processes, business needs, and business questions being asked.
3
Question
What are the steps in Kimball's ETL process?
Answer
Build ETL pipelines that extract, transform, and load data into a denormalized data model.
4
Question
What types of schemas are used in a dimensional model according to Kimball?
Answer
The dimensional model is built as a star schema or a snowflake schema.
5
Question
Where is the dimensional model usually built?
Answer
The dimensional model is usually built around and within dimensional data marts for specific departments.
6
Question
List one advantage of Kimball's Dimensional Modelling approach.
Answer
Simplicity - The architecture is much simpler and faster to design and set up.
7
Question
Why is Kimball's Dimensional Modelling approach considered understandable?
Answer
It is easy to understand and gears answer organization needs.
8
Question
What is a skills-related advantage of Kimball's approach?
Answer
Requires a less number of highly skilled engineers and less technical knowledge.
9
Question
What is a disadvantage related to data in Kimball's approach?
Answer
Data Redundancy - Because data is loaded into a dimensional model, it is not normalized.
10
Question
What does Kimball's approach say about a single source of truth?
Answer
There is no Single Source of Truth; the warehouse is designed and organized around data marts.
11
Question
What is a disadvantage of Kimball's Dimensional Modelling approach related to flexibility?
Answer
It is Less Flexible and Incomplete due to the as-needed paradigm and is specific to needs.
