Microsoft · DP-600
Optimize performance
DP-600 · Lesson 14 of 15 · 1:25:54
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: measuring before changing with Performance Analyzer, testing DAX queries, shrinking the model with fewer columns and better data types, and tuning DAX. Includes three original practice questions.
Preview the topics
- In Performance analyzer, a table visual shows a short DAX query time, but a very long visual display time. What should the author look at first?
- An Import model has forty date columns, and its size keeps growing, although it already has its own Date table. Which setting should the modeler turn off?
- A measure divides sales by a fixed number of stores, written as the constant 12, and it uses DIVIDE. What does the guidance recommend?