18 Data Modeling questions from the Power BI bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.
Free to start: the 2-minute IT readiness check — six questions and a result.
A.the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
B.the relationship setting controlling whether filters flow one way or both ways across a join
C.a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
D.a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
Answer + AI explanation with Pro
2. Which term means: "a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys"?
Junior
A.Cross-filter direction
B.Fact table
C.Snowflake schema
D.Star schema
Answer + AI explanation with Pro
3. Which statement is correct?
Junior
A.Star schema — the relationship setting controlling whether filters flow one way or both ways across a join
B.Star schema — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
C.Star schema — a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
D.Star schema — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
Answer + AI explanation with Pro
4. What is Fact table?
Junior
A.a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
B.the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
C.the central table holding measurable numeric events and the foreign keys linking to descriptive context
D.a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
Answer + AI explanation with Pro
5. Which term means: "the central table holding measurable numeric events and the foreign keys linking to descriptive context"?
Junior
A.Fact table
B.Cardinality
C.Cross-filter direction
D.Star schema
Answer + AI explanation with Pro
6. Which statement is correct?
Junior
A.Fact table — a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
B.Fact table — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
C.Fact table — the central table holding measurable numeric events and the foreign keys linking to descriptive context
D.Fact table — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
Answer + AI explanation with Pro
7. What is Dimension table?
Junior
A.a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
B.the relationship setting controlling whether filters flow one way or both ways across a join
C.a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
D.the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
Answer + AI explanation with Pro
8. Which term means: "a lookup table of descriptive attributes such as product, customer, or date used to slice and group values"?
Junior
A.Star schema
B.Fact table
C.Dimension table
D.Cardinality
Answer + AI explanation with Pro
9. Which statement is correct?
Junior
A.Dimension table — the central table holding measurable numeric events and the foreign keys linking to descriptive context
B.Dimension table — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
C.Dimension table — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
D.Dimension table — a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
Answer + AI explanation with Pro
10. What is Cardinality?
Mid
A.the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
B.the relationship setting controlling whether filters flow one way or both ways across a join
C.a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
D.a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
Answer + AI explanation with Pro
11. Which term means: "the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many"?
Mid
A.Fact table
B.Star schema
C.Snowflake schema
D.Cardinality
Answer + AI explanation with Pro
12. Which statement is correct?
Mid
A.Cardinality — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
B.Cardinality — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
C.Cardinality — the relationship setting controlling whether filters flow one way or both ways across a join
D.Cardinality — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
Answer + AI explanation with Pro
13. What is Cross-filter direction?
Mid
A.a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
B.the central table holding measurable numeric events and the foreign keys linking to descriptive context
C.a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
D.the relationship setting controlling whether filters flow one way or both ways across a join
Answer + AI explanation with Pro
14. Which term means: "the relationship setting controlling whether filters flow one way or both ways across a join"?
Mid
A.Dimension table
B.Snowflake schema
C.Cardinality
D.Cross-filter direction
Answer + AI explanation with Pro
15. Which statement is correct?
Mid
A.Cross-filter direction — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
B.Cross-filter direction — a lookup table of descriptive attributes such as product, customer, or date used to slice and group values
C.Cross-filter direction — the relationship setting controlling whether filters flow one way or both ways across a join
D.Cross-filter direction — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
Answer + AI explanation with Pro
16. What is Snowflake schema?
Senior
A.the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
B.a modeling layout with a central numeric table surrounded by descriptive lookup tables joined by keys
C.the central table holding measurable numeric events and the foreign keys linking to descriptive context
D.a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
Answer + AI explanation with Pro
17. Which term means: "a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels"?
Senior
A.Snowflake schema
B.Dimension table
C.Cross-filter direction
D.Star schema
Answer + AI explanation with Pro
18. Which statement is correct?
Senior
A.Snowflake schema — the central table holding measurable numeric events and the foreign keys linking to descriptive context
B.Snowflake schema — a layout where dimension tables are split into further related sub-tables, normalizing them across multiple linked levels
C.Snowflake schema — the relationship setting controlling whether filters flow one way or both ways across a join
D.Snowflake schema — the relationship classification describing how many matching rows exist on each side, such as one-to-many or many-to-many
Answer + AI explanation with Pro
Free to start
Start with a free readiness check
Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every Data Modeling question come with Pro.