Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-700 Exam - Topic 2 Question 9 Discussion

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 schema. 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.
B) ProductName
A) Date
C) ProductColor
D) TransactionID
E) SalesAmount
F) ProductID

Microsoft DP-700 Exam - Topic 2 Question 9 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 9
Topic #: 2
[All DP-700 Questions]

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.

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Dorian
10 months ago
TransactionID? That doesn't belong in DimProduct!
upvoted 0 times
...
Therese
10 months ago
ProductColor should definitely be there, right?
upvoted 0 times
...
Dorthy
10 months ago
Not sure about including Date in DimProduct. Seems off.
upvoted 0 times
...
Skye
11 months ago
I think ProductName is a must too!
upvoted 0 times
...
Fausto
11 months ago
Definitely need ProductID in DimProduct.
upvoted 0 times
...
Carmen
11 months ago
I feel like TransactionID doesn't belong in DimProduct since it's more of a fact related to sales rather than a product attribute.
upvoted 0 times
...
Domitila
11 months ago
This question reminds me of a practice exam where we had to identify dimensions and facts. I think Date and ProductID are definitely essential for DimProduct.
upvoted 0 times
...
Pamela
12 months ago
I'm not entirely sure about including ProductColor. I think it might be relevant, but I need to double-check if it's a key attribute for tracking changes.
upvoted 0 times
...
Jimmie
12 months ago
I remember we discussed that the DimProduct table should include attributes that describe the product, so ProductName and ProductID seem like good choices.
upvoted 0 times
...
Jess
12 months ago
I think the key is to identify the columns that represent the product attributes, like ProductName and ProductColor. Those would be good candidates for the DimProduct table.
upvoted 0 times
...
Sarah
12 months ago
I'm a bit confused about the difference between the FactSales and DimProduct tables. I'll need to re-read the question carefully to make sure I understand the requirements.
upvoted 0 times
...
Shawnee
12 months ago
Okay, let's see. The table has a lot of columns, but I need to focus on the ones that are relevant for the product dimension.
upvoted 0 times
...
Rosalia
12 months ago
Hmm, the question mentions tracking changes in the DimProduct table, so I'll need to think about which columns would be good for that.
upvoted 0 times
...
Isabelle
12 months ago
This looks like a classic dimensional modeling question. I'll need to identify the columns that should be included in the DimProduct table to track changes.
upvoted 0 times
...
Domonique
1 year 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
1 year 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
Milly
1 year ago
Definitely don't choose D) TransactionID just for humor, stick to the correct answers!
upvoted 0 times
...
Hoa
1 year ago
Yeah, those are the correct columns to include in the DimProduct table for tracking changes.
upvoted 0 times
...
Eun
1 year ago
A) Date, B) ProductName, and F) ProductID should be included in the DimProduct table.
upvoted 0 times
...
...
Lauran
1 year ago
Yeah, I agree with Lucy. The DimProduct table should have the product attributes, not the sales transaction details like Date, TransactionID, and SalesAmount.
upvoted 0 times
Thad
1 year ago
That makes sense, we want to make sure we can easily track changes in DimProduct.
upvoted 0 times
...
Vannessa
1 year ago
We should also include ProductID in the DimProduct table to uniquely identify each product.
upvoted 0 times
...
Iluminada
1 year ago
I agree, those are definitely important product attributes to track.
upvoted 0 times
...
Marilynn
1 year ago
I think we should include ProductName and ProductColor in the DimProduct table.
upvoted 0 times
...
...
Lucy
1 year 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 year ago
Including those columns will help us track changes in product information effectively.
upvoted 0 times
...
Gary
1 year ago
I agree, ProductName, ProductColor, and ProductID are essential for the DimProduct table.
upvoted 0 times
...
...
Yen
1 year ago
I believe we should also include Date in DimProduct to have a complete view of the data.
upvoted 0 times
...
Nichelle
1 year ago
I agree with Rodney. Those columns are essential for tracking changes in DimProduct.
upvoted 0 times
...
Rodney
1 year ago
I think we should include ProductName, ProductColor, and ProductID in DimProduct.
upvoted 0 times
...

Save Cancel