Exam DP-600 topic 1 question 162 discussion

HOTSPOT
-

You have a Fabric warehouse that contains the following data.



The data has the following characteristics:

• Each customer is assigned a unique CustomerID value.
• Each customer is associated to a single SalesRegion value.
• Each customer is associated to a single CustomerAddress value.
• The Customer table contains 5 million rows.
• All foreign key values are non-null.

You need to create a view to denormalize the data into a customer dimension that contains one row per distinct CustomerID value. The solution must minimize query processing time and resources.

How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Suggested Answer: