Microsoft · DP-600
KQL and DAX queries
DP-600 · Lesson 9 of 15 · 52:10
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: KQL basics with where, project, and take, aggregations with summarize and bin, DAX queries with EVALUATE and SUMMARIZECOLUMNS, and the DAX query view. Includes three original practice questions.
Preview the topics
- Marketing wants the number of clicks per hour, for the last 24 hours, from the Clicks table. Which query fits?
- An analyst must test a new margin measure against the model, per category, without changing the model. What should the DAX query use?
- A tested query declares three measures with DEFINE MEASURE. The analyst wants those measures saved in the semantic model, in one step. What should the analyst select?