
Ultimate access to all questions.
You are tasked with optimizing a semantic model for a large retail company. The current model is experiencing slow query performance, especially during peak sales periods. Describe a detailed strategy to improve query performance using DAX Studio. What specific features of DAX Studio would you utilize, and how would they contribute to the overall performance improvement?
A
Use DAX Studio to analyze query execution plans and identify bottlenecks.
B
Utilize DAX Studio to optimize data model relationships and improve data lineage.
C
Employ DAX Studio to rewrite complex DAX formulas for better performance.
D
Leverage DAX Studio to increase the number of partitions in the data model.