QuestionQ16

VerifiedImplement and manage semantic models

You 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?

Community Discussion

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