You manage a Microsoft SQL Server Analysis Services (SSAS) database for your company.
Users are reporting that SSAS performance has recently degraded.
You run a SQL Profiler trace on MDX queries that are being executed on a SSAS instance. Trace
analysis shows that a MDX query executed by a new user is consuming more than the required
resources. You review the MDX query and identify that the MDX query contains a complex IIF
function to return a result set.
Which advice should you give to the new user to improve query performance?
A.
Use user-defined stored procedures.
B.
Replace the IIF function with a complex CASE statement.
C.
Use query hints.
D.
Use an IF statement.