You are deploying an application on Windows client computers by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. You need to ensure that the deployment package meets the following requirements:
* Grants only the necessary permissions
* Adds a shortcut to the Windows Start menu
* Registers the application within Programs and Features
* Can be published to a Web site
Which deployment strategy should you use?

You are developing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. The application will run in a partially trusted sandbox. You plan to deploy the application on client computers by using the ClickOnce deployment technology. You plan to sign the deployment and application manifest by using a trusted publisher certificate. You need to ensure that the following requirements are met:
* Users are not prompted for elevated permissions during application deployment.
* The application can request elevated permissions at runtime.
Where should you install the trusted publisher certificate?

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application contains an ObservableCollection object named Pictures that contains several Picture objects. Each Picture object contains the Name and PictureFilePath properties. You add a ListBox control to the application. You need to ensure that the pictures are displayed in the ListBox control. Which code fragment should you use?

You 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?

You are analyzing an application that uses Microsoft .NET Framework 4 and Microsoft SQL Server 2008. The application is used to maintain an inventory database and is accessed from several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDataAdapter object. Users report that the application runs slowly during peak business hours. When large number of records are changed by multiple users, you discover the following: The CPU utilization of the client applications is normal. The network utilization increases slightly. The CPU utilization of the database server remains close to the normal average for a day. You need to resolve the performance issue. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. You deploy the service to the following URL: http://contoso.com/Northwind.svc. You want to query the WCF Data Services service to retrieve a list of customer objects. You need to ensure that the query meets the following requirements:
* Only customers that match the following filter criteria are retrieved: City=”Seattle” AND Level > 200.
* Data is sorted in ascending order by the ContactName and Address properties.
Which URL should you use for the query?

You use Microsoft .NET Framework 4 to create a Windows Forms application. You have a DataGridView that is bound to a DataTable containing a column named ProductName. The ProductName column can contain any valid string, except “ProductX,” “ProductY,” or “ProductZ.” You need to ensure that only valid entries for ProductName are saved when users edit the DataGridView. Which DataGridView event should you use?

You are designing the data access layer (DAL) for an application that uses Microsoft SQL Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring in the SQL Server database due to concurrent updates. You need to design a database locking strategy that meets the following requirements:
* Resolves concurrent update conflicts without loss of data
* Ensures that data conflicts can be resolved by users
* Locks only the data necessary for updates
What should you do?

You are designing a Windows application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. You plan to implement control caching to improve the loading time of a control. It is not required to refresh the content of the control after the application loads. The application will be compiled by using the .NET 4 client profile. You need to ensure that the following requirements are met:
* The control is reusable in multiple forms.
* Data in the control is cached when the application is loaded.
What should you do?

You are developing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. The application contains a grid that displays customer data stored in a database table. Users report that the grid takes a long time to display. You plan to implement data caching to improve loading time for the grid. You need to ensure that the cached data expires when the customer data is updated. What should you do?