
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing a semantic model that is critical for real-time business intelligence reports. The model is experiencing significant performance degradation during peak hours when over 500 users access it simultaneously. The business requires uninterrupted access to the model without compromising on the speed of report generation. Given the constraints of cost efficiency and the need for minimal administrative overhead, which of the following solutions would BEST optimize the performance of the semantic model under high concurrency? (Choose one option)
A
Implement row-level security to reduce the amount of data processed per user, thereby decreasing the load on the semantic model.
B
Configure query throttling to manage the rate of query execution, ensuring that the system resources are not overwhelmed during peak usage times.
C
Scale up the underlying hardware resources allocated to the semantic model to handle the increased load, accepting the associated cost increase.
D
Redirect a portion of the users to a read-only replica of the semantic model during peak hours to distribute the load.