100% Microsoft 70-518 Guaranteed Success With Testing Engine

Microsoft PRO: Design & Develop Wndws Apps Using MS .NET Framework 4 Sample Questions:

1. You are designing an n-tier .NET Framework 4 solution that includes a Windows
Presentation Foundation (WPF) application.
The WPF application will access data stored in a Microsoft SQL Server 2008 database by
using the solution's data access tier.
The data access tier must also be available from within Microsoft Excel 2010. You need to recommend a technology for accessing the data access tier. Which technology should you recommend?

A) LINQ to SQL
B) LINQ to XML
C) WCF Data Services
D) ADO.NET Entity Framework 4

2. You are designing an n-tier .NET Framework 4 solution that includes a Windows Presentation Foundation (WPF) application and a Windows Workflow Foundation (WF) component. The WF component contains functionality to incorporate frequently changing rules.
You need to recommend a tier for the deployment of the WF component that will not degrade the performance of the WPF application.
Which tier should you recommend?

A) The data access tier
B) The presentation tier
C) The data tier
D) The business tier

3. You are modifying an existing Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The WPF application uses a wizard to capture data and insert the data into a database. The database includes one parent table and many child tables.
Inserting captured data in the database locks many database tables and delays application access.
You have the following requirements:
-
Reduce delays when saving datA.
--
Ensure that other application users are not blocked from reading datA. Ensure that captured data is available only after all child tables are updated.
You need to recommend an approach for inserting captured data into the database.
What should you recommend?

A) Insert all captured data in a single transaction when the user completes the wizard.
B) Insert captured data by using a single transaction as the user completes each wizard page.
C) Insert captured data by using non-transactional operations when the user completes the wizard.
D) Insert captured data by using optimistic concurrency as the user completes each wizard page.

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

5. You are designing a Windows Presentation Foundation (WPF) application.
The WPF application must run against either Microsoft SQL Server 2008 or a third-party
database system without duplicating data access logiC.
You need to recommend a data access technology.
What should you recommend?

A) ADO.NET using DataSet objects and SqlDataReader objects
B) LINQ to SQL
C) LINQ to Entities
D) ADO.NET using DataSet objects and SqIDataAdapter objects

Solutions: