• Description:Microsoft 70-306 Developing Windows-based Applications with Microsoft Visual Basic .NET
• Passing Score:75%
• Practice Test - Number of questions:247 questions
• Simulation Test - Number of questions:247 questions
• Simulation Test Duration:41 minutes
• Has explanations:Yes

You develop a Windows-based inventory management application that interacts with a Microsoft SQL Server database. Your application enables users to update information about items in inventory. Each time a user changes an inventory item, your application executes a SQL Server stored procedure IT departmentSP to update rows in the database. IT departmentSP will run many times during each user session. Your application will use a SqlCommand object to execute IT departmentSP. You must revise your code so that the use of this object optimizes query performance. What should you do?

Answer(s)

1. Call the SqlCommand.DeriveParameters method before each call to SqlCommand.ExecuteNonQuery.
2. Call the SqlCommand.Prepare method before each call to SqlCommand.ExecuteNonQuery.
3. Call the SqlCommand.DeriveParameters method before the first call to SqlCommand.ExecuteNonQuery.
4. Call the SqlCommand.Prepare method before the first call to SqlCommand.ExecuteNonQuery.

Call the SqlCommand.Prepare method before the first call to SqlCommand.ExecuteNonQuery.