What is the purpose of the 'Preview' pane in the Visual Query Editor when selecting rows?

It shows a sample of the data that will be returned by the query.

It shows the SQL code generated by the query.

It allows you to edit the data directly in the source table.

It lists all available columns in the dataset.

Which KQL query returns only storm events with a damage property greater than 100000?

StormEvents | order by Damage desc

StormEvents | where Damage > 100000

A Fabric developer is creating a DAX measure to calculate the year-to-date (YTD) sales. The table 'Sales' has columns 'SaleDate' and 'Amount'. The measure must be dynamic and reflect the current date. Which DAX expression is correct?

CALCULATE(SUM(Sales[Amount]), YEAR(Sales[SaleDate]) = YEAR(TODAY()))

SUM(Sales[Amount]) WHERE SaleDate <= TODAY()

CALCULATE(SUM(Sales[Amount]), Sales[SaleDate] <= TODAY())

TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 3

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

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 26–30

26foundation · easy
Which SQL clause is used to filter rows based on a condition?
Select an answer first
27foundation · easy
What is the purpose of the 'Preview' pane in the Visual Query Editor when selecting rows?
Select an answer first
28foundation · easy
Which KQL query returns only storm events with a damage property greater than 100000?
Select an answer first
29expert · hard
A Fabric developer is creating a DAX measure to calculate the year-to-date (YTD) sales. The table 'Sales' has columns 'SaleDate' and 'Amount'. The measure must be dynamic and reflect the current date. Which DAX expression is correct?
Select an answer first
30foundation · easy
Which DAX function counts the number of non-blank values in a column?
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.

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

Questions 26–30

Which SQL clause is used to filter rows based on a condition?

What is the purpose of the 'Preview' pane in the Visual Query Editor when selecting rows?

Which KQL query returns only storm events with a damage property greater than 100000?

A Fabric developer is creating a DAX measure to calculate the year-to-date (YTD) sales. The table 'Sales' has columns 'SaleDate' and 'Amount'. The measure must be dynamic and reflect the current date. Which DAX expression is correct?

Which DAX function counts the number of non-blank values in a column?

Keep studying — Prepare data