You are building a Fabric warehouse for a finance team. Multiple reports need to calculate a 'fiscal quarter' from a date column, and the logic is complex (e.g., fiscal year starts in April). You want to encapsulate this logic so that it is defined once and reused across all reports. What should you create?

A calculated column in each fact table that uses the date part directly.

A stored procedure that calculates the fiscal quarter and stores it in a table.

A T-SQL function that accepts a date and returns the fiscal quarter.

A view that contains the fiscal quarter calculation for a specific table.

A Fabric pipeline ingests customer data from multiple sources. The same customer may appear in multiple sources with slightly different names or addresses. The team needs to create a single customer dimension with unique customers, but they cannot rely on a common customer ID across sources. What is the most effective approach?

Use exact matching on email address.

Use a full outer join on all customer attributes.

Use a stored procedure that deletes duplicate rows based on name.

Use a fuzzy matching algorithm to group records that are likely the same customer and assign a new surrogate key.

A Fabric warehouse has a Sales table where the Discount column contains NULL for orders that did not receive a discount. You need to calculate the total revenue after discount for each order. The revenue is Quantity * UnitPrice. Which expression should you use?

Quantity * UnitPrice * (1 - COALESCE(Discount, 1))

Quantity * UnitPrice * (1 - Discount)

Quantity * UnitPrice - Discount

Quantity * UnitPrice * (1 - ISNULL(Discount, 0))

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 2

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

59questions here

12free pages

15concepts

45–50%of the exam

Questions 26–30

26foundation · easy
Which statement is used to execute a stored procedure in T-SQL?
Select an answer first
27application · medium
You are building a Fabric warehouse for a finance team. Multiple reports need to calculate a 'fiscal quarter' from a date column, and the logic is complex (e.g., fiscal year starts in April). You want to encapsulate this logic so that it is defined once and reused across all reports. What should you create?
Select an answer first
28foundation · easy
In PySpark, which method removes duplicate rows from a DataFrame?
Select an answer first
29expert · hard
A Fabric pipeline ingests customer data from multiple sources. The same customer may appear in multiple sources with slightly different names or addresses. The team needs to create a single customer dimension with unique customers, but they cannot rely on a common customer ID across sources. What is the most effective approach?
Select an answer first
30application · medium
A Fabric warehouse has a Sales table where the Discount column contains NULL for orders that did not receive a discount. You need to calculate the total revenue after discount for each order. The revenue is Quantity * UnitPrice. Which expression should you use?
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 6)

Questions 26–30

Which statement is used to execute a stored procedure in T-SQL?

In PySpark, which method removes duplicate rows from a DataFrame?

A Fabric warehouse has a Sales table where the Discount column contains NULL for orders that did not receive a discount. You need to calculate the total revenue after discount for each order. The revenue is Quantity * UnitPrice. Which expression should you use?

Keep studying — Prepare data