Microsoft Certified:Fabric Analytics Engineer Associate
Domain 2Objective 3
Query and Analyze Data DP-600 Practice Questions (Page 7)
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 31–34
- 31
In Kusto Query Language (KQL), which operator is used to select specific columns from a table?
Select an answer first - 32
Which SQL function would you use to calculate the total of a numeric column?
Select an answer first - 33
In the Visual Query Editor in Microsoft Fabric, which action is performed by dragging a column name into the 'Filter' area?
Select an answer first - 34
A Fabric analyst is writing a KQL query to find the maximum temperature recorded per city, but only for cities where the maximum temperature exceeded 100 degrees. The table 'Weather' has columns 'City', 'Temperature', and 'Date'. Which query is correct?
Select an answer first
Finished these 4 questions?
Review the revealed explanations, or continue through the curriculum.
No more pagesBack to DP-600
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.