Microsoft Exam DP-700 Topic 2 Question 9 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 9
Topic #: 2

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns.

You plan to load the data into a dimensional model and implement a star schem

a. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.

You need to prepare the data.

Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

ADate

BProductName

CProductColor

DTransactionID

ESalesAmount

FProductID

Show Suggested Answer

Suggested Answer: B

This code does not meet the goal because this is an SQL-like query and cannot be executed in KQL, which is required for the database.

Correct code should look like:

by Benton at Mar 07, 2025, 06:32 PM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Domonique

26 days ago

I'm still a bit confused about the difference between a flat table and a dimensional model. Is the flat table like a spreadsheet, and the dimensional model is more like a database? Anyway, I'll go with B, C, and F as well.

upvoted 0 times

...

Avery

30 days ago

Haha, I was going to choose D) TransactionID just to see if the exam reviewer has a sense of humor. But I guess that would be the wrong answer. Maybe I'll save that for the next question!

upvoted 0 times

Eun

1 days ago

A) Date, B) ProductName, and F) ProductID should be included in the DimProduct table.

upvoted 0 times

...

2 months ago

I think the correct columns to include in the DimProduct table are B) ProductName, C) ProductColor, and F) ProductID. These columns contain the product-related information that is needed for the dimensional model and star schema.

upvoted 0 times

Tijuana

1 months ago

Including those columns will help us track changes in product information effectively.

upvoted 0 times

...

Gary

1 months ago

I agree, ProductName, ProductColor, and ProductID are essential for the DimProduct table.

upvoted 0 times

...

Yen

2 months ago

I believe we should also include Date in DimProduct to have a complete view of the data.

upvoted 0 times

...

Nichelle

2 months ago

I agree with Rodney. Those columns are essential for tracking changes in DimProduct.

upvoted 0 times

...

Rodney

2 months ago

I think we should include ProductName, ProductColor, and ProductID in DimProduct.

upvoted 0 times

...