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?
What should you do?
You use the ASP.NET Web Application template to create an application in a new Visual Studio solution.
The project uses types that are defined in a class library project.
Source code for the class library is frequently modified.
You need to ensure that classes in the Web application project always reference the most recent version of the class library types.
What should you do?
Which two actions should you perform?
You are implementing an ASP. NET MVC 2 Web application. You add a controller named CompanyController.
You need to modify the application to handle the URL path /company/info.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Which URL should you use for the query?
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?
Which two actions should you perform?
You are implementing an ASP.NET Web application.
Users will authenticate to the application with an ID.
The application will allow new users to register for an account.
The application will generate an ID for the user based on the user’s full name.
You need to implement this registration functionality.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are implementing an ASP.NET Dynamic Data Web site.
The Web site includes a data context that enables automatic scaffolding for all tables in the data model. The Global.asax.cs file contains the following code segment. public static void RegisterRoutes(RouteCollection routes) { {
routes.Add(new DynamicDataRoute(“{table}/ListDetails.aspx”) {
Action = PageAction.List,
ViewName = “ListDetails”,
Model = DefaultModel
});
routes.Add(new DynamicDataRoute(“{table}/ListDetails.aspx”) {
Action = PageAction.Details,
ViewName = “ListDetails”,
Model = DefaultModel
});
}
You need to display the items in a table named Products by using a custom layout.
What should you do?
Which DataGridView event should you use?
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?
Which two actions should you perform?
You are creating an ASP.NET Web application that uses the SqlMembershipProvider.
You plan to test locally and deploy to multiple production servers.
You need to ensure that each deployed application accesses the same production database in Microsoft SQL Server.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Which event handler should you add?
You are implementing an ASP.NET page in an e-commerce application. Code in a btnAddToCart_Click event handler adds a product to the shopping cart.
The page should check the status of the shopping cart and always show a cart icon when one or more items are in the shopping cart. The page should hide the icon when the shopping cart has no items. You need to add an event handler to implement this requirement.
Which event handler should you add?
What should you do?
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?