
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing the performance of a Fabric environment that supports a large organization with complex data models and a high volume of users. The organization is experiencing slow query responses and system bottlenecks during peak usage times. You need to recommend a solution that not only addresses the immediate performance issues but also ensures scalability for future growth. Consider the following constraints: the solution must be cost-effective, comply with organizational data governance policies, and minimize downtime during implementation. Which of the following actions would you recommend as the BEST solution to optimize the Fabric environment's performance and scalability? (Choose one option.)
A
Implement data partitioning and indexing strategies across all data models to enhance query performance, ensuring that the strategies are aligned with the most frequently accessed data patterns.
B
Deploy Azure Monitor and Azure Application Insights to continuously monitor the Fabric environment's performance, setting up alerts for any performance degradation or bottlenecks.
C
Utilize Azure Data Factory to redesign and optimize all data pipelines, focusing on reducing data movement and transformation times to alleviate the load on the Fabric environment.
D
Adjust the Fabric environment's configuration settings, including memory allocation and query execution options, to better match the current workload demands and anticipated growth, ensuring optimal resource utilization.