A Fabric pipeline receives daily customer updates from a CRM system. The updates include new customers and changes to existing customer details. The main customer table should reflect the latest information, and the pipeline must avoid creating duplicate customer records. What should the pipeline use?

An INSERT statement that adds all rows from the update file.

A DELETE statement that removes all rows and then inserts the update file.

A SELECT statement that returns the updated rows.

A MERGE statement that updates matching rows and inserts new rows based on the customer ID.

A Fabric lakehouse has a Sales table with a Region column that is missing for about 5% of rows. You need to produce a report that shows total sales by region. You want to avoid excluding those rows from the report. What should you do?

Filter out rows where Region is null before grouping.

Use a median value to fill the missing regions.

Group by Region and let the report show a blank for missing values.

Replace missing Region values with 'Unknown' and then group by Region.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 2

Transform Data DP-600 Practice Questions (Page 5)

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 59 practice questions to prepare you well beyond it. (estimate)

59questions here

12free pages

15concepts

45–50%of the exam

Questions 21–25

21application · medium
A Fabric pipeline receives daily customer updates from a CRM system. The updates include new customers and changes to existing customer details. The main customer table should reflect the latest information, and the pipeline must avoid creating duplicate customer records. What should the pipeline use?
Select an answer first
22foundation · easy
In PySpark, which function is used to replace null values in a column?
Select an answer first
23application · medium
A Fabric lakehouse has a Sales table with a Region column that is missing for about 5% of rows. You need to produce a report that shows total sales by region. You want to avoid excluding those rows from the report. What should you do?
Select an answer first
24foundation · easy
In Power Query, which function is used to replace missing values in a column?
Select an answer first
25foundation · easy
Which SQL aggregate function calculates the total of a numeric 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.

Transform Data DP-600 Practice Questions (Page 5)

Questions 21–25

In PySpark, which function is used to replace null values in a column?

A Fabric lakehouse has a Sales table with a Region column that is missing for about 5% of rows. You need to produce a report that shows total sales by region. You want to avoid excluding those rows from the report. What should you do?

In Power Query, which function is used to replace missing values in a column?

Which SQL aggregate function calculates the total of a numeric column?

Keep studying — Prepare data