PL-300 Model the data Practice Question
Which TWO of the following are true about the Power BI composite model?
⚠ Common exam trap
Candidates often assume composite models require uniform storage modes or cannot handle many-to-many relationships, but Power BI's composite model is designed to flexibly mix storage modes and supports many-to-many relationships through proper configuration.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
A composite model can combine DirectQuery and Import tables.
A composite model in Power BI allows mixing DirectQuery and Import tables within the same data model. This enables you to leverage the performance of in-memory Import storage for some tables while using DirectQuery to access large or real-time data sources without duplicating data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Composite models do not support many-to-many relationships.
Why it's wrong here
Many-to-many relationships are supported.
- ✗
All tables in a composite model must use the same storage mode.
Why it's wrong here
Composite models allow mixing storage modes.
- ✓
A composite model can combine DirectQuery and Import tables.
Why this is correct
This is a key feature of composite models.
- ✓
Relationships can be created between tables from different source groups.
Why this is correct
Composite models allow cross-source relationships.
- ✗
Calculated tables are not supported in composite models.
Why it's wrong here
Calculated tables are supported.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.