exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 7 discussion

Actual exam question from Microsoft's DP-700
Question #: 7
Topic #: 1
[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 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.

  • A. Date
  • B. ProductName
  • C. ProductColor
  • D. TransactionID
  • E. SalesAmount
  • F. ProductID
Show Suggested Answer Hide Answer
Suggested Answer: BCF 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
maham
1 week, 3 days ago
Selected Answer: ABF
The dimension table has to track the changes also. Then date field is important for SCD. So Product color takes second priority in this list
upvoted 1 times
shmmini
1 week ago
in this case, the transaction date is referenced. you cannot use it as it is. If you have to track SCD, you have to create your own Date Column, and populate it differently, not from this table
upvoted 1 times
...
...
Madhu2023
1 month, 1 week ago
Selected Answer: BCF
BCF are the attributes of Product. TranId , Date and SalesAmt quaify for fact table instead
upvoted 2 times
...
robertlavigne
2 months, 1 week ago
Selected Answer: BCF
Date: Should be in the FactSales table ProductName: Attribute of the product and belongs in DimProduct ProductColour: Attribute of the product and belongs in DimProduct TransactionID: Belongs in the FactSales Table Sales Amount: Belongs in the FactSales Table ProductID: Will be the primary key for DimProduct
upvoted 1 times
...
QAZdbarhate12345678
3 months, 2 weeks ago
Selected Answer: BCF
Columns to Include in DimProduct ProductID - This is the unique identifier for each product and acts as the primary key in the DimProduct table. ProductName - Contains the name of the product, which is a descriptive attribute. ProductColor - Contains the color description of the product, which is also a descriptive attribute.
upvoted 4 times
...
Tuki93
3 months, 3 weeks ago
Selected Answer: BCF
I believe the provided answer is correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago