QuestionQ16
VerifiedImplement and manage semantic modelsYou have a Fabric workspace containing a large warehouse.
You plan to create a lakehouse named Lakehouse1 for a sales dataset. Lakehouse1 will contain these tables:
- Sales: Contains sales transactions
- Stores: Contains a unique list of store names and locations
- Loyalty: Contains a list of customers and their preferred stores
- Customers: Contains a unique list of customer names and addresses
- Products: Contains a unique list of available products and their descriptions
You need to configure a star schema for Lakehouse1.
Which table should be defined as the fact table, and which relationship type should be configured from the Sales table to the Customers table?
Select
Fact table:
Relationship:
Community Discussion