
Ultimate access to all questions.
You are a Microsoft Fabric Analytics Engineer working on optimizing a complex DAX (Data Analysis Expressions) query within an enterprise-scale semantic model. The query is causing significant delays in report generation due to a large number of calculations. Your goal is to improve the query's performance using DAX Studio, considering the constraints of cost, compliance, and scalability. Which of the following steps would you take first to effectively identify and address the performance bottlenecks? (Choose one option.)
A
Immediately refactor the DAX query to use simpler expressions and remove any redundant calculations without further analysis.
B
Use DAX Studio to run the query and meticulously analyze the execution plan to pinpoint specific bottlenecks or inefficiencies.
C
Request an increase in memory allocation for the DAX query engine to handle the dataset size, assuming it will resolve the performance issues.
D
Add more indexes to the underlying data source, hoping it will indirectly improve the DAX query performance.