Microsoft
70-518 · Question #55
70-518 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock 70-518 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
You are analyzing an application that uses Microsoft .NET Framework 4 and Microsoft SQL Server 2008. The application is used to maintain an inventory database and is accessed from several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDotoAdopter object. Users report that the application runs slowly during peak business hours. When large numbers of records are changed by multiple users, you discover the following: - The CPU utilization of the client applications is normal. - The network utilization increases slightly. - The CPU utilization of the database server remains close to the normal average for a day. You need to resolve the performance issue. What should you do?
Options
- ADisable batch updates. Modify the client application to perform a single update.
- BInsert a random time interval between updates.
- CMove the update method calls to a separate BackgroundWorker thread.
- DRemove any limit on batch update sizes.
Unlock 70-518 to see the answer
You've previewed enough free 70-518 questions. Unlock 70-518 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.