Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Microsoft logo

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 3

Query and Analyze Data DP-600 Practice Questions (Page 3)

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 11–15

  1. 11foundation · easy

    In the Visual Query Editor, which operation would you use to calculate the total sales amount for each product category?

    Select an answer first
  2. 12foundation · easy

    What is the primary purpose of the CALCULATE function in DAX?

    Select an answer first
  3. 13foundation · easy

    What is the primary purpose of the pipe character (|) in a KQL query?

    Select an answer first
  4. 14foundation · easy

    In DAX, which function is used to add up all values in a column?

    Select an answer first
  5. 15foundation · easy

    Which DAX function would you use to calculate the average of a numeric column?

    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.