Online Access Free 70-518 Exam Questions

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 conceptual schema xml file when the schema changes occur.
• B.Modify the xml mapping file when the schema changes occur.
• C.Build a storage model and use it to access data from the business entities.
• D.Build a conceptual model and use it to access data from the business entities.

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?

• A.Move the update method calls to a separate BackgroundWorker thread.
• B.Remove any limit on batch update sizes. Modify the client application to perform a single update.
• C.Disable batch updates. Modify the client application to perform a single update.
• D.Insert a random time interval between updates.

You are designing an n-tier .NET Framework 4 solution that includes a Windows Presentation Foundation (WPF) application.
You need to recommend an approach for ensuring that the solution can support 5,000 concurrent users.
What should you recommend?

• A.Buffer overflow testing
• B.Component stress testing
• C.Integration testing
• D.Stress testing

You are designing an application by using Windows Presentation Foundation (WPF) and Microsoft .NET Framework 4.
You create a control named HelpViewer to view the Help documentation of the application. The HelpViewer control must be available to all windows in the application.
You need to ensure that the application allows users to perform the following tasks:
- Bookmark their location in the documentation and return to the bookmark from any
window.
- Hide the HelpViewer control.
- Dock the HelpViewer control.
You create a main window as a base class.
What should you do next?

• A.Add the HelpViewer control and a Frame control to a StackPanel control to the window at runtime.
  Create all other windows in the application as pages and host them in the Frame control.
• B.Add the HelpViewer control to the window at runtime.
  Inherit all other window classes in the application from the main window base class.
• C.Add the HelpViewer control and a Frame control to a DockPanel control to the window at runtime.
  Create all other windows in the application as pages and host them in the Frame control.
• D.Add the HelpViewer control to a DockPanel control at runtime.
  Inherit all other window classes in the application from the main window base class.

You are designing a Windows Presentation Foundation (WPF) application that accesses a business tier. The business tier is implemented as a Windows Communication Foundation (WCF) service and stores data in a Microsoft SQL Server 2008 database.
The WCF service will be accessed by external applications that do not use the .NET Framework.
You need to recommend an approach for passing data between layers.
What should you recommend?

• A.Use the DiffGram XML format.
• B.Use custom .NET classes with binary serialization.
• C.Use a DataSet object.
• D.Use custom .NET classes with XML serialization.