A Fabric warehouse has a complex query that joins five tables and applies multiple filters. Several analysts need to run this exact query regularly, but they are not familiar with the underlying schema. The team wants to provide a simple object that analysts can query without seeing the join logic. What should they create?

A function that returns a table.

A view that encapsulates the join and filter logic.

A stored procedure that returns the result set.

A new table that stores the joined result.

A Fabric lakehouse table contains customer records with an email column. Due to a data entry issue, some customers appear multiple times with the same email but different phone numbers. The team needs to keep only one record per email, preferring the record with the most recent last_updated value. What is the most efficient approach?

Use SELECT DISTINCT on the email column.

Use GROUP BY email and MAX(last_updated).

Use a window function with ROW_NUMBER() partitioned by email and ordered by last_updated DESC, then filter for row number 1.

Use a self-join on email and last_updated.

In a Fabric notebook using PySpark, which code snippet correctly defines a function that adds a column with a constant value?

df.transform(lambda d: d.withColumn('new_col', 10))

df.withColumn('new_col', lit(10))

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 2

Transform Data DP-600 Practice Questions (Page 9)

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 41–45

41foundation · easy
In T-SQL, which set operation combines the results of two SELECT statements and removes duplicates?
Select an answer first
42application · medium
A Fabric warehouse has a complex query that joins five tables and applies multiple filters. Several analysts need to run this exact query regularly, but they are not familiar with the underlying schema. The team wants to provide a simple object that analysts can query without seeing the join logic. What should they create?
Select an answer first
43application · medium
A Fabric lakehouse table contains customer records with an email column. Due to a data entry issue, some customers appear multiple times with the same email but different phone numbers. The team needs to keep only one record per email, preferring the record with the most recent last_updated value. What is the most efficient approach?
Select an answer first
44foundation · easy
In Power Query, which operation is used to combine two tables based on a matching column?
Select an answer first
45foundation · easy
In a Fabric notebook using PySpark, which code snippet correctly defines a function that adds a column with a constant value?
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 9)

Questions 41–45

In T-SQL, which set operation combines the results of two SELECT statements and removes duplicates?

In Power Query, which operation is used to combine two tables based on a matching column?

In a Fabric notebook using PySpark, which code snippet correctly defines a function that adds a column with a constant value?

Keep studying — Prepare data