Answer-first summary for fast verification
Answer: Configure query throttling to manage the rate of query execution, ensuring that the system resources are not overwhelmed during peak usage times.
Option B is the most effective solution because it directly addresses the issue of high concurrency by managing the rate at which queries are executed, thus preventing system overload without the need for significant additional resources or infrastructure changes. Implementing row-level security (Option A) may reduce data processing per user but does not directly address concurrency issues. Scaling up hardware resources (Option C) could improve performance but at a higher cost and with more administrative overhead. Redirecting users to a read-only replica (Option D) could distribute the load but requires additional infrastructure and may not be feasible for all scenarios, especially where real-time data access is critical.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.