70-451 · Question #46
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Policies. The table contains information about 100 million insurance…
The correct answer is B. Split the execution of the stored procedure into batches. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Policies. The table contains information about 100 million insurance policies. A complex stored procedure executes daily to calculate the risk amount of each policy and stores the information in the table. When the stored procedure is executed, users experience poor performance and query time-out errors. The queries used in the stored procedure are optimized for performance. You need to ensure that the disruption to users is minimal while the stored procedure is being executed. What should you do?
Options
- AUse the READ UNCOMMITTED transaction isolation level.
- BSplit the execution of the stored procedure into batches.
- CWrite the risk amounts to a table variable before you update the Policies table.
- DWrite the risk amounts to a temporary table before you update the Policies table.
How the community answered
(35 responses)- A6% (2)
- B83% (29)
- C9% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.