Microsoft
70-518 · Question #184
70-518 Question #184: Real Exam Question with Answer & Explanation
Sign in or unlock 70-518 to reveal the answer and full explanation for question #184. 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 DbDataAdapter object. Users report that the application runs slowly during peak business hours. When large number 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.
- BInsert a random time interval between updates.
- CRemove any limit on batch update sizes.
- DMove the update method calls to a separate BackgroundWorker thread.
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.