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
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 2 times
...
Tuki93
4 weeks ago
Selected Answer: BCF
I believe the provided answer is correct
upvoted 2 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