🔥 3-day streak
Microsoft Azure Database Administrator Associate112 / 144
Question 112 of 144

A developer at your company reports that a reporting query on an Azure SQL Database is unexpectedly slow. The query calls a T-SQL scalar user-defined function in its SELECT list to compute a derived value for each row, and the estimated plan shows the function executing serially per row. The database compatibility level is currently set to 140. Without rewriting the query or the function, which action will most likely improve performance by allowing the function logic to be incorporated into the calling query's plan?

Reviewed for accuracy · Report an issueNext question