nerdexam
Microsoft

DP-700 · Question #11

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. Name Description TransactionID…

The correct answer is B. ProductName C. ProductColor F. ProductID. To create a DimProduct table for a star schema from a flat table, include ProductID, ProductName, and ProductColor as they represent the product's unique identifier and descriptive attributes.

Design and implement data modeling

Question

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. Name Description TransactionID Contains a unique ID for each transaction Date Contains the date of a transaction ProductID Contains a unique ID for each product ProductColor Contains a descriptive attribute that describes the color of each product ProductName Contains a unique name for each product SalesAmount Contains the sales amount of a transaction 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.

Options

  • ADate
  • BProductName
  • CProductColor
  • DTransactionID
  • ESalesAmount
  • FProductID

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    89% (16)
  • E
    6% (1)

Why each option

To create a DimProduct table for a star schema from a flat table, include ProductID, ProductName, and ProductColor as they represent the product's unique identifier and descriptive attributes.

ADate

Date is typically a transaction-specific attribute that belongs in the FactSales table, often as a foreign key to a separate DimDate table.

BProductNameCorrect

ProductName is a descriptive attribute of the product that clearly belongs in the DimProduct dimension table.

CProductColorCorrect

ProductColor is another descriptive attribute of the product that should be included in the DimProduct dimension table.

DTransactionID

TransactionID is a unique identifier for each transaction and is a measure that belongs in the FactSales table.

ESalesAmount

SalesAmount is a measure representing the sales value and belongs in the FactSales fact table.

FProductIDCorrect

ProductID is the unique identifier for each product and serves as the natural key or business key within the DimProduct table, essential for linking to the FactSales table.

Concept tested: Dimensional Modeling DimProduct

Source: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

Topics

#Dimensional Modeling#Star Schema#Fact and Dimension Tables#Data Modeling

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-700 Practice