Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing a semantic model that contains a large number of complex hierarchies, leading to performance degradation. The model is critical for real-time analytics in a financial reporting scenario where accuracy and speed are paramount. You need to ensure the solution is cost-effective, scalable, and maintains data integrity. Which of the following steps would you take to optimize the performance of the semantic model? (Choose one)