You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data. 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?

Question

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data. 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?

Accepted Answer

A. ProductColor, ProductID, and ProductName. ProductID is the natural primary key for a product dimension, while ProductName and ProductColor are descriptive attributes of a product. These three columns represent the core identifying and descriptive information for a product, aligning with the purpose of a dimension table in a star schema.

Answer

B. ProductName, SalesAmount, and TransactionlD. SalesAmount and TransactionID are typically measures or fact identifiers, belonging in a fact table like FactSales, not a dimension table.

Answer

C. Date, ProductID, and TransactionlD. Date belongs in a DimDate dimension, and TransactionID belongs in a fact table.

Answer

D. ProductID, ProductName, and SalesAmount SalesAmount is a measure that belongs in a fact table, not a dimension table.

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

Question

Exhibit

Options

How the community answered

Why each option

Topics

Community Discussion