Microsoft · DP-600
Storage modes and composite models
DP-600 · Lesson 10 of 15 · 1:05:18
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate). In this lesson: Import, DirectQuery, Dual, and Direct Lake storage modes, composite models, Dual tables and limited relationships, and the large semantic model storage format. Includes three original practice questions.
Preview the topics
- Inventory lives in an operational SQL database, outside Fabric, and must never be stale in reports, even between refreshes. Which storage mode fits the inventory table?
- A Date table relates to an Import Sales table and to a DirectQuery Inventory table from the same database. Some visuals are slow because of a limited relationship. What should the Date table use?
- A model on a Fabric capacity stopped refreshing at about 10 GB. It must keep growing in the service. What should the owner turn on?