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.You are designing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.
The application contains a COM component.
You plan to deploy the application to several client computers by using read-only media. You need to ensure that the COM component is registered during deployment of the application.
Which deployment technology should you use?
A. XCopyYou are designing a sales and inventory tracking system by using Microsoft Visual Studio 2010 and Microsoft SQL Server 2008. The sales, inventory, and shipping tables will reside in different databases on different database servers.
You need to ensure that the tables are updated simultaneously.
What should you do?
A. Use LINQ to SQL.You are designing a Windows Presentation Foundation (WPF) application. The application data files have the file name extension.abc.
The WPF application installer must meet the following requirements:
Add a shortcut to the desktop.
Install infrequently used assemblies on demand.
Associate the .abc file name extension with the WPF application.
Roll back the installation in the event of a failure.
You need to recommend a deployment method.
What should you recommend?
A. ClickOnceYou are preparing to deploy a solution that includes a Windows Forms application and several COM components. Unsigned interop assemblies have been created for each of the COM components.
You need to recommend an approach for deploying the solution.
What should you recommend?
A. Deploy the Windows Forms application to a folder on the client computer. Deploy the COM components and interop assemblies to the Global Assembly Cache (GAC). Register the COM components.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. ADO.NET Entity Framework 4You 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. Implement the IDataErrorlnfo interface in the business objects and replace all ValidationRule elements with ExceptionValidationRule elements.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.You are designing an n-tier Windows solution that includes a data entry application. The solution uses Microsoft .NET Framework 4 and Microsoft SQL Server 2008.
The data entry application sends customer orders to a middle-tier server. The middle-tier server sends orders to a set of services that perform operations on the orders. Business rules determine which services to call and whether to run them
in sequence or in parallel. The business rules are complex and data dependent.
The Windows solution must meet the following requirements:
Optimize application performance by using dynamic load balancing.
Allow for business rules to be changed at runtime.
You need to recommend an approach that meets the requirements.
What should you recommend?
A. Private message queues with a controller class on the middle-tier serverYou are designing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. The application will store data that includes a time and date stamp.
The middle tier of the application is implemented by using Windows Communication Foundation (WCF).
The middle tier connects to geographically separated database servers.
You need to ensure that the application meets the following requirements:
Data stored contains time and date information local to the database server.
Data stored contains Universal Coordinated Time (UTC).
Which class should you use?
A. DateTimeNowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Microsoft exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 70-518 exam preparations and Microsoft certification application, do not hesitate to visit our Vcedump.com to find your solutions here.