QuestionQ41

VerifiedPrepare data

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data.

Question Image

You need to perform the following actions:

• Load the data from Table1 into a star schema.

• Create a product dimension table named DimProduct and a fact table named FactSales.

Which three columns should you include in DimProduct?

Explanation

In a star schema, dimension tables contain descriptive attributes and characteristics of business entities. ProductColor, ProductID, and ProductName are all inherent product attributes. SalesAmount and Date are typically held in fact tables as measures and temporal dimensions respectively, not in the product dimension.

Community Discussion

No comments yet. Be the first to start the discussion!