Online Access Free 70-523 Practice Test

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. The application uses DataContexts to query the database. You create a function that meets the following requirements: *Updates the Customer table on the database when a customer is marked as deleted. *Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted. *Prevents consumer code from setting the Deleted column's value directly. You need to ensure that the function verifies that customers have no outstanding orders before they are marked as deleted. You also need to ensure that existing applications can use the updated function without requiring changes in the code. What should you do?

• A.Override the Delete operation of the DataContext object.
• B.Add new entities to the DataContext object for the Customers and Orders tables.
• C.Override the Update operation of the DataContext object.
• D.Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.

You create an ASP.NET page named TestPage.aspx that contains validation controls. You need to verify that all input values submitted by the user have been validated by testing the Page.IsValid property. Which page event should add an event handler to?

• A.PreLoad
• B.Load
• C.PreInit
• D.Init

You are designing a process for deploying an ASP.NET MVC 2 Web application to IIS 6.0.
You need to ensure that the Web application properly handles Web requests.
Which approach should you recommend?

• A.Configure IIS to map all requests to aspnet_wp.exe by using a wildcard script map.
• B.Modify the Web application to route all requests to an HttpHandler class.
• C.Modify the Web application to route all requests to an HttpModule class.
• D.Configure IIS to map all requests to aspnet_isapi.dll by using a wildcard script map.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the following object query
to load a product from the database. (Line numbers are included for reference only.)
01using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02{
03ObjectQuery <Product> productQuery = advWorksContext.Product.Where("it.ProductID = 900");
04
05}
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

• A.Trace.WriteLine(productQuery.CommandText);
• B.Trace.WriteLine(productQuery.ToString());
• C.Trace.WriteLine(((IQueryable)productQuery).Expression);
• D.Trace.WriteLine(productQuery.ToTraceString());

You are developing an ASP.NET application by using Visual Studio 2010. You need to interactively debug the entire application. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Set the Debug attribute of the compilation node of the web.config file to true.
• B.Define the DEBUG constant in the project settings.
• C.Add a DebuggerDisplay attribute to the code-behind file of the page that you want to debug.
• D.Select the ASP.NET debugger option in the project properties.