• Description: Designing and Developing Windows-Based Applications by Using the
• Passing Score: 0%
• Practice Test - Number of questions: 207 questions
• Simulation Test - Number of questions: 207 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

You create Microsoft Windows-based applications. You are creating a component. The component performs statistical computations by using sets of data from a large, complex database. According to the design specification, the component performs a full set of calculations in not more than 5 seconds. Currently, the component takes more than 20 seconds to perform the required calculations. The project is almost complete and you must resolve the performance issues quickly. You need to identify the major processing performance issues in the component. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

Answer(s)

1. Add custom instrumentation to the component for operations that you expect will exceedperformance requirements.
2. Use SQL Profiler when you run the component to identify long-running database queries.
3. Use Microsoft Network Monitor to identify long-running or large network data transfers.
4. Use the common language runtime (CLR) profiler to identify the most used and long-runningfunctions in the component and the specific external functions they call.
5. Create a custom test harness that calls individual functions and measures how long they taketo run.

Use SQL Profiler when you run the component to identify long-running database queries.