Microsoft Certified:Fabric Analytics Engineer Associate
Domain 2Objective 3
Query and Analyze Data DP-600 Practice Questions (Page 5)
Part of the Prepare data domain, which accounts for 45–50% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~18–33 in this domain), expect 6–11 from this objective — we provide 34 practice questions to prepare you well beyond it. (estimate)
34questions here
7free pages
16concepts
45–50%of the exam
Questions 21–25
- 21
Which DAX expression returns only the sales records where the 'Region' column equals 'West'?
Select an answer first - 22
Which KQL query counts the number of storm events in each state?
Select an answer first - 23
Which aggregation function in the Visual Query Editor would you use to count the number of rows in each group?
Select an answer first - 24
Which of the following is a valid filter condition you can set in the Visual Query Editor for a numeric column?
Select an answer first - 25
Which KQL query would return only the 'EventType' and 'State' columns from the 'StormEvents' table?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-600” is a trademark of its owner, used for identification only.