🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate6 / 150
Question 6 of 150
You are building a T-SQL view in a Fabric warehouse that calculates total compensation as BaseSalary + Bonus. During testing, several rows return NULL for TotalComp even though BaseSalary has a value, because the Bonus column contains NULLs for employees without bonuses. You must ensure that employees without a bonus show their BaseSalary as the total compensation instead of NULL. Which expression should you use in the view?
Reviewed for accuracy · Report an issueNext question