🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate143 / 150
Question 143 of 150
You are loading a customer dimension into a Fabric warehouse. The source ProductCategory column contains inconsistent values such as ' Electronics', 'electronics ', and 'ELECTRONICS' that represent the same category but break your GROUP BY aggregations. You must produce a single normalized value for each category during transformation using T-SQL. Which expression correctly standardizes the values so all three examples collapse into one group?
Reviewed for accuracy · Report an issueNext question