Power BI Data Modelling MCQS
Q. What is data modeling in Power BI?
Solution:
Data modeling is the process of structuring tables and their relationships so that reports, DAX calculations, and filters work correctly across the dataset.
Q. Which schema layout is recommended for Power BI data models?
Solution:
The star schema — a central fact table surrounded by dimension tables — is recommended for performance and DAX predictability.
Q. Can you create a full data model in Power BI online (the Service)?
Solution:
Full data modeling requires Power BI Desktop. The Service is primarily for publishing and viewing.
Q. What is a composite model in Power BI?
Solution:
Composite models mix Import and DirectQuery, letting large tables stay live while smaller ones are imported.
Q. What is the most common relationship type in Power BI?
Solution:
One-to-Many is the standard in a star schema.
Q. How do you create a relationship between two tables in Power BI ?
Solution:
In Model View, drag a column from one table onto the corresponding column in another.
Q. How many active relationships can exist between the same two tables in Power BI ?
Solution:
Only one active relationship per table pair. Additional connections must be inactive.
Q. What does an inactive relationship look like in Model View in Power BI ?
Solution:
Inactive relationships appear as dashed lines.
Q. Which DAX function activates an inactive relationship?
Solution:
USERELATIONSHIP() activates an inactive relationship inside CALCULATE.
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
