Microsoft Certified:Fabric Analytics Engineer Associate
Domain 2Objective 3
Query and Analyze Data DP-600 Practice Questions (Page 2)
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 6–10
- 6
In KQL, which operator would you use to limit the number of rows returned to the first 100?
Select an answer first - 7
Which SQL query would return only the 'ProductName' and 'Price' columns from the 'Products' table?
Select an answer first - 8
In KQL, which operator would you use to calculate the average value of a numeric column?
Select an answer first - 9
Which SQL clause is used to specify which columns to return in a query?
Select an answer first - 10
Which DAX function would you use to return a table that contains only the rows where a condition is true?
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.