A Fabric report developer needs to create a DAX measure that counts the number of distinct customers who have made at least one purchase in the 'Online' channel. The model has a Sales table with columns: CustomerID, Channel, Amount. Which DAX measure correctly computes this?

Online Customers = CALCULATE(COUNT(Sales[CustomerID]), Sales[Channel] = "Online")

Online Customers = COUNTROWS(FILTER(Sales, Sales[Channel] = "Online"))

Online Customers = DISTINCTCOUNT(Sales[CustomerID]) WHERE Sales[Channel] = "Online"

Online Customers = CALCULATE(DISTINCTCOUNT(Sales[CustomerID]), Sales[Channel] = "Online")

A data analyst is using the Visual Query Editor to prepare a dataset for a report. They need to see only the 'CustomerID' and 'OrderTotal' columns for orders where the order total is greater than $500. The table is named 'Orders'. What is the most efficient way to achieve this?

Add a filter on OrderTotal > 500, then select all columns and export to Excel.

Select the CustomerID and OrderTotal columns, then add a filter on OrderTotal > 500.

Add a filter on CustomerID > 500, then select the OrderTotal column.

Select the CustomerID column only, then sort by OrderTotal descending.

In SQL, what does the DISTINCT keyword do when used in a SELECT statement?

Filters rows based on a condition.

Removes duplicate rows from the result set.

Sorts the result set in descending order.

In the Visual Query Editor, how would you select only the 'CustomerName' and 'OrderDate' columns for the query result?

Drag both columns to the Filter area.

Check the boxes next to 'CustomerName' and 'OrderDate' in the column selection pane.

Drag the columns to the Sort area.

Right-click each column and choose 'Delete'.

You are building a DAX measure in a Fabric semantic model. The table 'Sales' has columns 'ProductID', 'Units', and 'Price'. You need to calculate the total revenue (Units * Price) for only the products where Units > 10. Which DAX expression is correct?

CALCULATE(SUM(Sales[Units] * Sales[Price]), Sales[Units] > 10)

SUMX(FILTER(Sales, Sales[Units] > 10), Sales[Units] * Sales[Price])

SUM(Sales[Units] * Sales[Price]) WHERE Sales[Units] > 10

FILTER(Sales, Sales[Units] > 10) SUM(Sales[Units] * Sales[Price])

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 3

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

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 16–20

16application · medium
A Fabric report developer needs to create a DAX measure that counts the number of distinct customers who have made at least one purchase in the 'Online' channel. The model has a Sales table with columns: CustomerID, Channel, Amount. Which DAX measure correctly computes this?
Select an answer first
17application · medium
A data analyst is using the Visual Query Editor to prepare a dataset for a report. They need to see only the 'CustomerID' and 'OrderTotal' columns for orders where the order total is greater than $500. The table is named 'Orders'. What is the most efficient way to achieve this?
Select an answer first
18foundation · easy
In SQL, what does the DISTINCT keyword do when used in a SELECT statement?
Select an answer first
19foundation · easy
In the Visual Query Editor, how would you select only the 'CustomerName' and 'OrderDate' columns for the query result?
Select an answer first
20application · medium
You are building a DAX measure in a Fabric semantic model. The table 'Sales' has columns 'ProductID', 'Units', and 'Price'. You need to calculate the total revenue (Units * Price) for only the products where Units > 10. Which DAX expression is correct?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.