You are designing a star schema for a Fabric warehouse. The source has a table with OrderID, CustomerID, CustomerName, CustomerCity, ProductID, ProductName, ProductCategory, OrderDate, Quantity, and UnitPrice. You need to support reports that filter by customer city and product category, and you want to minimize redundancy and improve maintainability. Which design should you choose?

Create separate fact tables for each dimension and join them in a view.

Create a fact table with all descriptive columns and separate dimension tables only for Date.

Create Customer, Product, and Date dimensions, and a fact table with OrderID, CustomerID, ProductID, DateKey, Quantity, and UnitPrice.

Create a single wide table with all columns and use it as both fact and dimension.

In PySpark, which method converts a column to a different data type?

df.withColumn('col', df['col'].cast('integer'))

df.changeType('col', 'integer')

df.convertColumn('col', 'integer')

What is the main reason to denormalize data in a data warehouse?

To reduce storage costs by eliminating redundant data

To enforce referential integrity between tables

To improve query performance by reducing the number of joins

To simplify data ingestion from source systems

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 2Objective 2

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

59questions here

12free pages

15concepts

45–50%of the exam

Questions 16–20

16foundation · easy
In Power Query (M), which function is commonly used to add a custom column to a table?
Select an answer first
17expert · medium
You are designing a star schema for a Fabric warehouse. The source has a table with OrderID, CustomerID, CustomerName, CustomerCity, ProductID, ProductName, ProductCategory, OrderDate, Quantity, and UnitPrice. You need to support reports that filter by customer city and product category, and you want to minimize redundancy and improve maintainability. Which design should you choose?
Select an answer first
18foundation · easy
In SQL, which clause is used to filter rows based on a condition?
Select an answer first
19foundation · easy
In PySpark, which method converts a column to a different data type?
Select an answer first
20foundation · easy
What is the main reason to denormalize data in a data warehouse?
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 4)

Questions 16–20

In Power Query (M), which function is commonly used to add a custom column to a table?

In SQL, which clause is used to filter rows based on a condition?

In PySpark, which method converts a column to a different data type?

What is the main reason to denormalize data in a data warehouse?

Keep studying — Prepare data