nerdexam
MicrosoftMicrosoft

DP-600 · Question #142

DP-600 Question #142: Real Exam Question with Answer & Explanation

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?

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
Full DP-600 PracticeBrowse All DP-600 Questions