QuestionQ90
VerifiedPrepare dataHOTSPOT
You have a Fabric warehouse containing the following data.

The data has these characteristics:
- Each customer has a unique
CustomerIDvalue. - Each customer is linked to one
SalesRegionvalue. - Each customer is linked to one
CustomerAddressvalue. - 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?
Select
Create View DimCustomer As Select C.CustomerID, C.CustomerName, C.CompanyName, SR.SalesRegion, A.City, A.StateProvince, A.CountryRegion, A.PostalCode from SalesLT.Customer C SalesLT.SalesRegion SR on C.SalesRegionID = SR.SalesRegionID inner join [SalesLT].[CustomerAddress] CA on CA.customerid = C.customerid inner join [SalesLT].[Address] A on where CA.AddressType = 'Main Office'
Community Discussion