🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate7 / 150
Question 7 of 150

You are building a customer dimension in a Fabric warehouse. The source table contains three phone columns: MobilePhone, HomePhone, and WorkPhone. Many rows have NULLs in one or more columns. You must produce a single PrimaryPhone column that returns the first non-null value in the priority order Mobile, then Home, then Work. Which T-SQL expression should you use?

Reviewed for accuracy · Report an issueNext question