QUESTION 81
You are deploying a Windows Presentation Foundation (WPF) application that uses MicrosoftNET Framework 4 and Microsoft SQL Server 2008.Your company is consolidating database servers. Your application uses a database and storedprocedures. The application stores a large amount of data in the tempdb file The database must be allocated two central processing units. The stored procedures employ three-pail naming. You need to deploy the database. Where should you deploy the database?
A. on a shared server on a shared instance
B. on a shared server on a stand-alone instance
C. on a stand-alone server on a shared instance
D. on a stand-alone server on a stand-alone instance
Answer: B
QUESTION 82
You e designing a Windows Presentation Foundation (WPF) application by using MicrosoftNET Framework 4 and Microsoft SQL Server 2008, The application runs successfully on a localclient computer by using your user account.
You deploy the database of the application to theproduction server.
You configure the application connection string to use the Windows Authentication mode.
You deploy the application to several client computers that use other applications on the network The client computers access different databases on the production server by using the Windows Authentication mode Users report that the application is not working and that they receive a database connection exception.
You need to identify the source of the problem.
What is the source of the problem?
A. The database is currently blocked due to locks
B. The users do not have the correct database permissions
C. The users do not have valid SQL Server 2008 database logins
D. The client computers are not configured to use the network
Answer: B
QUESTION 83
You are deploying a Windows Presentation Foundation (WPF) application that uses Microsoft .NET Framework 4 and Microsoft SQL Server 2008.The installation program for the application will create a new database Corporate policy does not allow storage of user names and passwords in any software program.
You need to ensure that users who do not have administrative rights can install the application.
What should you do?
A. Require the installation to use the current Windows user
B. Require the installation to include the SQL Server sa account
C. Require the installation to include a SQL Server username and password
D. Require the installation to prompt for a Windows username and password
Answer: D
QUESTION 84
You are deploying an application on Windows client computer by using Microsoft NETFramework 4 and Microsoft Visual Studio 2010.You need to ensure that the deployment package meets the following requirements:
– Adds a shortcut to the Windows Start menu
– Registers the application within Programs and Features
– Grants only the necessary permissions
– Can be published to a Web site.
Which deployment strategy should you use?
A. XCopy
B. ClickOnce
C. Merge module
D. Windows Installer
Answer: B
QUESTION 85
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. Microsoft Windows installer (MSI)
B. Click Once along with full trust
C. X Copy
D. Click Once along with partial trust
Answer: A
QUESTION 86
You are designing a Windows Presentation Foundation (WPF) application by using Microsoft NET Framework 4 and Microsoft Visual Studio 2010.
You plan to create a Customer object that contains an Orders property. The Orders property contains an array of Orders objects. When users browse Customer objects, they must be able to optionally view Orders objects you need to design a data access strategy that retrieves data only when necessary.
Which strategy should you use
A. lazy loading
B. eager loading
C. file streaming
D. pessimistic locking
Answer: A
QUESTION 87
You are designing a Windows Presentation Foundation (WPF) application by using Microsoft NET Framework 4 and Microsoft Visual Studio 2010.
You plan to create an Author object that contains a Books property. The Books property contains a large array of Books objects. When users browse through author data in the application, they must be able to view all information related to books written by that author without additional queries.
You need to design a data access strategy that meets the requirement.
Which strategy should you use?
A. lazy loading
B. eager loading
C. optimistic locking
D. pessimistic locking
Answer: B
QUESTION 88
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 disconnectedfrom 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. XML files
B. WCF services
C. Microsoft Sync Framework
D. the System Web. Caching namespace classes
Answer: C
QUESTION 89
You are developing an application by using Microsoft NET Framework 4 and Microsoft Visual Studio 2010. The application accesses customer data stored on both Microsoft and non-Microsoft database servers.
You need to combine data from the multiple databases to display customer information.
Which data access technology should you use?
A. LINQ to SQL
B. ADO.NET Data Reader
C. ADO.NET Entity Framework
D. Microsoft Sync Framework
Answer: C
QUESTION 90
You are designing a Windows application by using Microsoft NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008.
You need to design a data access strategy that meets the following requirements:
– Automatically tracks changes
– Maps the database data model to the object model
Which data access technology should you use?
A. LINQ to SQL
B. LINQ to XML
C. ADO.NET Data Set
D. ADO.NET Data Reader
Answer: A
Free Download Microsoft 70-518 PDF and VCE Dumps Help You 100% Pass Exam
