Online Access Free 070-523 Exam Questions

You need to design a deployment solution for the rewritten Web application. Which approach should you recommend?

• A.Use MSDeploy and FTP.
• B.Use DB Deployment and FTP.
• C.Use DB Deployment and One-Click Publishing.
• D.Use MSDeploy and One-Click Publishing.

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. You create classes by using LINQ to SQL based on the records shown in the exhibit. (Click the Exhibit button.) You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID properties. You need to retrieve the total price amount of each Order record. What are two possible ways to achieve this goal (Each correct answer presents a complete solution. Choose two.)

• A.dataContext.Orders.GroupJoin(dataContext.Order_Details, o => o.OrderID, d => d.OrderID, (ord, dts) => new { OrderID = ord.OrderID, CustomerID = ord.CustomerID, TotalAmount = dts.Sum(od => od. UnitPrice * od.Quantity) } )
• B.dataContext.Order_Details.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID, (dts, ord) => new { OrderID = dts.OrderID, CustomerID = dts.Order.CustomerID, TotalAmount = dts.UnitPrice * dts.Quantity } )
• C.from order in dataContext.Orders group order by order.OrderID into g join details in dataContext.Order_Details on g.Key equals details. OrderID select new { OrderID = details.OrderID, CustomerID = details.Order.CustomerID, TotalAmount = details.UnitPrice * details.Quantity }
• D.from details in dataContext.Order_Details group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID select new { OrderID = order.OrderID, CustomerID = order.CustomerID, TotalAmount = g.Sum(od => od.UnitPrice * od.Quantity) }

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?

• A.Page_Load
• B.Page_PreRender
• C.btnAddToCart_Click
• D.Page_PreInit

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use
the ADO.NET Entity Framework to model entities. You write the following code segment. (Line numbers
are included for reference only.)
01AdventureWorksEntities context = New AdventureWorksEntities (http://localhost:1234/AdventureWorks.
svc );
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;
You need to ensure that the application meets the following requirements: "Compares the current values of
unmodified properties with values returned from the data source. "Marks the property as modified when the
properties are not the same. Which code segment should you insert at line 02?

• A.context.MergeOption = MergeOption.AppendOnly;
• B.context.MergeOption = MergeOption.PreserveChanges;
• C.context.MergeOption = MergeOption.OverwriteChanges;
• D.context.MergeOption = MergeOption.NoTracking;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service on the production server, attempting to update or delete an entity results in an error. You need to ensure that you can update and delete entities on the production server. What should you do?

• A.Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.
• B.Add the following line of code to the InitializeService method of the service. config.SetEntitySetAccessRule ("*",EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);
• C.Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.
• D.Add the following line of code to the InitializeService method of the service. config.SetEntitySetAccessRule ("*",EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);