Microsoft
DP-600 · Question #142
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data. You need to perform the following
Sign in or unlock DP-600 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
Submitted by tom_us· Apr 18, 2026Prepare and serve data
Question
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data. You need to perform the following actions:
- Load the data from Table1 into a star schema.
- Create a product dimension table named DimProduct and a fact table
named FactSales. Which three columns should you include in DimProduct?
Exhibit
Options
- AProductColor, ProductID, and ProductName.
- BProductName, SalesAmount, and TransactionlD.
- CDate, ProductID, and TransactionlD.
- DProductID, ProductName, and SalesAmount
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Star Schema#Dimension Tables#Data Modeling#Microsoft Fabric