What should you do?

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?
A. Use the READ UNCOMMITTED transaction isolation level.
B. Split the execution of the stored procedure into batches.
C. Write the risk amounts to a table variable before you update the Policies table.
D. Write the risk amounts to a temporary table before you update the Policies table.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.