Free Microsoft 070-518 Exam Dumps Questions & Answers

You are designing a .NET Framework 4 solution that includes a Windows Presentation Foundation (WPF) application. The WPF application connects to a Microsoft SQL Server 2008 database. You plan to deploy the WPF application to millions of client computers. The SQL Server database will be hosted in a data center.
The WPF application will query the database to provide type-ahead assistance as users enterdata.
The WPF application will send a query after each character is entered. Each query will access multiple joined tables.
You need to recommend an approach for maximizing scalability of the solution.
What should you recommend?

• A.  Create stored procedures to abstract the tables.
• B.  Denormalize the data to fewer tables.
• C.  Use System.Runtime.Caching to cache query results on the client.
• D.  Create a separate data layer with caching.

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 custom .NET classes with XML serialization.
• B.  Use the DiffGram XML format.
• C.  Use a DataSet object.
• D.  Use custom .NET classes with binary serialization.

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 and error messages by creating a handler for the InfoMessage event.
• D.  Retrieve informational messages by creating a handler for the InfoMessage event. Retrieve error messages in a SqlException object.

You are designing a Windows Presentation Foundation (WPF) application. The WPF application displays indicators to compare your company's past performance to the current day's operations datA.
The WPF application accesses historic data from your company's data warehouse through a Web service, and accesses current data directly from a Microsoft SQL Server 2008 database.
The WPF application must meet the following requirements:
- Retrieve historic data from the data warehouse at application startup and then
once per day.
- Retrieve current data from the database every five minutes, and then update the
indicators.
- Cache all retrieveddata.
- Target the .NET Framework 4 Client Profile.
You need to recommend an approach to data caching.
What should you recommend?

• A.  UseSystem.Web.Caching with a sliding expiration.
• B.  UseSystem.Web.Caching with an absolute expiration.
• C.  Use System.Runtime.Caching with an absolute expiration.
• D.  Use System.Runtime.Caching with a sliding expiration.

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 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.
• B.  Implement the IDataErrorlnfo interface in the data class of the application.
• C.  Implement the INotifyPropertyChanged interface in the data class of the application.
• D.  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.