Power BI 778 Data Modeling in Power BI 1 — Questions and Answers
Question 1: What type of schema uses a single fact table connected to multiple dimension tables in Power BI?
- Star schema (Correct answer)
- Snowflake schema
- Galaxy schema
- Flat schema
Correct answer: Star schema
A star schema uses one central fact table directly connected to dimension tables, optimizing query performance in Power BI.
Question 2: Which cardinality setting should you use when one row in Table A matches exactly one row in Table B?
- Many-to-many
- One-to-many
- One-to-one (Correct answer)
- Many-to-one
Correct answer: One-to-one
A one-to-one relationship means each row in Table A has exactly one corresponding row in Table B.
Question 3: What is the default storage mode for tables in Power BI Desktop?
- DirectQuery
- Import (Correct answer)
- Live Connection
- Dual
Correct answer: Import
Import mode is the default storage mode, which loads data into Power BI's in-memory engine (VertiPaq).
Question 4: In Power BI, which relationship filter direction allows filters to propagate in both directions between two tables?
- Single
- Bidirectional (Correct answer)
- Unidirectional
- Cross-filter
Correct answer: Bidirectional
Bidirectional cross-filter direction allows filters to flow from either table to the other in a relationship.
Question 5: What tool in Power BI Desktop helps you visualize all table relationships at once?
- Data view
- Report view
- Model view (Correct answer)
- Query editor
Correct answer: Model view
Model view displays all tables and their relationships visually, allowing you to manage the data model.
Question 6: Which storage mode in Power BI sends queries directly to the source database without caching data?
- Import
- Dual
- DirectQuery (Correct answer)
- Composite
Correct answer: DirectQuery
DirectQuery mode sends every query directly to the data source, ensuring real-time data without local caching.
Power BI 778 Data Modeling in Power BI 1
What type of schema uses a single fact table connected to multiple dimension tables in Power BI?