🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate136 / 150
Question 136 of 150
You are building a T-SQL view in a Fabric warehouse to feed a Power BI semantic model. The source fact table stores a nvarchar column named RegionCode that contains values like 'North', ' north ', 'NORTH', and 'South'. Downstream reporting requires a single consistent value per region so that grouping produces correct totals. Which single expression should you apply to RegionCode inside the view to standardize the values before grouping?
Reviewed for accuracy · Report an issueNext question