Querying Data with KQL and DAX

Introduction

This lesson completes the "Query and analyze data" group of the domain Prepare data (45–50% of the DP-600 skills measured): query and analyze data by using KQL and DAX, in addition to SQL and the visual query editor. This course targets the English syllabus effective October 19, 2026. Microsoft does not publish the question count or the question-type mix, so OnLevelUp mock exams use a 50-question practice length and an unofficial 80% practice target, which is not equivalent to the official 700/1000 scaled passing score.