Study with 70-518 most valid questions & verified answers

You are developing a Windows application by using Microsoft .NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008.
New features that require changes to be made to the database schema are added to the application every week.
You need to ensure that the changes made to the database schema do not require the application to be recompiled.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

• A. Modify the xml mapping file when the schema changes occur.
• B. Build a storage model and use it to access data from the business entities.
• C. Modify the conceptual schema xml file when the schema changes occur.
• D. Build a conceptual model and use it to access data from the business entities.

You are designing updates to a Windows solution that processes complex scientific datA.The solution extracts analyzed data from Microsoft Excel by using an application-level add-in.
You have the following requirements:
---
Deploy the Excel add-in to client machines with the application. Ensure that the solution supports Excel 2007 and Excel 2010. Minimize the size of the deployment package.
You need to recommend an approach that meets the requirements.
What should you recommend?

• A. Embed the Excel 2010 COM library.
• B. Include the primary interop assembly for Excel 2007.
• C. Include the primary interop assembly for Excel 2010.
• D. Embed the type information from the Excel 2010 COM library.

You are designing a Windows Forms application. The application connects to a Microsoft SQL Server 2008 database.
You need to recommend an approach for retrieving and logging all informational messages and error messages reported by the database.
What should you recommend?

• A. Retrieve informational messages and error messages in a SqlException object.
• B. Retrieve informational messages in a SqlException object. Retrieve error messages by creating a handler for the InfoMessage event.
• C. Retrieve informational messages by creating a handler for the InfoMessage event. Retrieve error messages in a SqlException object.
• D. Retrieve informational messages and error messages by creating a handler for the InfoMessage event.

You are designing a distributed application that will be deployed to 5,000 users worldwide.
Servers on five continents will host the Web services and the Microsoft SQL Server 2008
databases that support the application.
You have the following requirements:
---
Collect information about all errors associated with the application.
Store and view all error information in a centralized location.
Minimize the network bandwidth required for the transfer of error information.
You need to recommend a strategy for reporting error information. Which strategy should you recommend?

• A. Write error messages to the event logs on the local computers. Use Windows Management Instrumentation (WMI) to view the error information.
• B. Write error messages to the SQL Server databases. Synchronize the databases by using merge replication.
• C. Write error messages to the event logs on the local computers. Use Windows Error Reporting to view the error information.
• D. Write error messages to the SQL Server databases. Synchronize the databases by using transactional replication.

You are designing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.
During testing of the application, you identify several bottlenecks by using Windows Task Manager and Windows Performance Monitor.
You need to recommend a system test strategy that will meet the following requirements:
- Identify major application workloads.
- Identify the functions of the application that are most impacted.
Which testing strategy should you recommend?

• A. Scalability testing
• B. Stability testing
• C. Usability testing
• D. Security testing