Which of the following best practices for Power BI data modeling is relevant only to DirectQuery models?

• A. Set relationships to enforce integrity using the assume referential integrity property on relationships.
• B. Use a star schema as opposed to wide tables.
• C. Disable auto date/time in Power BI Desktop.
• D. Create composite models with multiple data sources.

Answer: (D)

DirectQuery models gain flexibility by letting you blend data from different sources in one model. Creating composite models that combine multiple data sources is the feature that makes this approach practical: you can keep large, live data in DirectQuery sources while bringing in smaller tables or lookup data from other sources via import, all within the same dataset. This hybrid capability is not available in a purely import-based model, so it’s a practice tied to DirectQuery scenarios. The other options describe general modeling ideas or features that aren’t exclusive to DirectQuery.