QuestionQ90

VerifiedPrepare data

HOTSPOT

You have a Fabric warehouse containing the following data.

Question Image

The data has these characteristics:

  • Each customer has a unique CustomerID value.
  • Each customer is linked to one SalesRegion value.
  • Each customer is linked to one CustomerAddress value.
  • The Customer table has 5 million rows.
  • All foreign-key values are non-null.

You need to create a view that denormalizes the data into a customer dimension with one row for each distinct CustomerID value. The solution must minimize query-processing time and resource use.

How should you complete the T-SQL statement?

Community Discussion

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