Choose 70-518 most accurate study material

Microsoft 70-518 Exam Overview:

Microsoft 70-518 Exam Syllabus Topics:

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

1. You are designing an application by using Microsoft .NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008.
The application will be used by a sales team to enter sales orders and update customer information.
You need to ensure that the application meets the following requirements:
- Allows users to enter sales orders while their computers are disconnected from the
network
- Uploads sales orders to the server database when connected to the network
- Compiles against the .NET Framework 4 client profile
What should you use?

A) TheSystem.Web.Caching namespace classes
B) XML files
C) WCF services
D) Microsoft Sync Framework

2. 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 SqIDataAdapter objects
B) ADO.NET using DataSet objects and SqlDataReader objects
C) LINQ to SQL
D) LINQ to Entities

3. 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.

4. You are designing an n-tier solution that connects to a Microsoft SQL Server 2008 database.
You plan to deploy the database to development machines and to a staging database server from within Microsoft Visual Studio 2010. You plan to set up separate build configurations for development and staging. You also plan to deploy to multiple production database servers managed by an outside vendor.
You must not allow the outside vendor to access the Visual Studio projects.
You need to recommend an approach for configuring and deploying the production database servers.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)

A) Use SQL Server 2008 Management Studio to deploy the production databases.
B) Use VSDBCMD to deploy the production databases.
C) Use a SQL Server 2008 Database Project.
D) Use a Visual Basic SQL CLR Database Project.

5. You design a Windows Presentation Foundation (WPF) application that connects to a Microsoft SQL Server 2008 database.
The WPF application becomes unresponsive at times. When the WPF application is running, physical memory usage is between 90 percent and 95 percent.
You need to recommend a tool that will identify the memory usage characteristics of the WPF application.
Which tool should you recommend?

A) SQL Profiler
B) Application Center Test (ACT)
C) CLR Profiler
D) Event Tracing for Windows (ETW)

Solutions: