70-518 · Question #55
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…
The correct answer is D. Remove any limit on batch update sizes. Several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDataAdapter object. (The DbDataAdapter class inherits from the DataAdapter class and helps a class implement a DataAdapter designed for use with a…
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.
How the community answered
(34 responses)- A3% (1)
- B12% (4)
- C9% (3)
- D76% (26)
Explanation
Several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDataAdapter object. (The DbDataAdapter class inherits from the DataAdapter class and helps a class implement a DataAdapter designed for use with a relational database. An application does not create an instance of the DbDataAdapter interface directly, but creates an instance of a class that inherits IDbDataAdapter and DbDataAdapter.) The BackgroundWorker component is designed to allow you to execute time-consuming operations on a separate, dedicated thread. This allows you to run operations that take a lot of time, such as file downloads and database transactions asynchronously and allow the UI to remain responsive.
Topics
Community Discussion
No community discussion yet for this question.