Free Microsoft 70-518 Exam Dumps Questions & Answers

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.  Remove any limit on batch update sizes. Modify the client application to perform a single update.
• B.  Insert a random time interval between updates.
• C.  Move the update method calls to a separate BackgroundWorker thread.
• D.  Disable batch updates. Modify the client application to perform a single update.

You are designing an application by using Windows Presentation Foundation (WPF), Microsoft .NET Framework 4, and Microsoft SQL Server 2008.
The application will contain several forms that include custom data validators.
You need to ensure that data is validated before the database updates occur. You also need to ensure that the validation logic can be reused.
How should you design the validation?

• A.  Subscribe to the TextChanged event for all user interface (UI) components of the application.
  Perform data validation in the event handler and alert users when a data entry error occurs.
• B.  Subscribe to the MouseLeave event for all user interface (UI) components of the application.
  Perform data validation in the event handler and alert users when a data entry error occurs.
• C.  Implement the INotifyPropertyChanged interface in the data class of the application.
• D.  Implement the IDataErrorlnfo interface in the data class of the application.

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

You are designing a Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The application uses a subset of the functionality provided by a third-party COM component that will be replaced later.
The application developers must have access to only the required subset of functionality.
You need to recommend a solution that meets the requirements.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)

• A.  In the adapter assembly, use an embedded interop reference.
• B.  In the adapter assembly, use a standard interop reference.
• C.  Create an adapter assembly that exposes the entire functionality of the COM component.
• D.  Create an adapter assembly that exposes the required subset of the COM component functionality.

You are designing a Windows Presentation Foundation (WPF) data entry application. The application uses data binding to bind controls in the user interface (UI) to business objects. The UI uses validation rules for each input control.
The data validation rules change based on the state of the business object.
You need to recommend a validation strategy that will allow changes to the validation rules without changes to the UI code.
What should you recommend?

• A.  Set the ValidationStep attribute on ValidationRule elements to RawProposedValue.
• B.  Implement the IDataErrorInfo interface in the business objects and replace all ValidationRule elements with ExceptionValidationRule elements.
• C.  Implement the IDataErrorInfo interface in the business objects and replace all ValidationRule elements with DataErrorValidationRule elements.
• D.  Set the ValidationStep attribute on ValidationRule elements to CommittedValue.