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. 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) }
• 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. 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) } )

You are designing an ASP.NET Web application that displays daily sales information. The sales
information is stored in a large Microsoft SQL Server database. The database information is updated each
night. During the day, people use the Web application to display a set of standard sales reports based on
the latest database information.
The SQL queries that are required to retrieve the database information can take from 20 to 30 seconds to
execute.
You need to design the application to ensure that pages usually load in no more than 5 seconds.
Which two approaches could you recommend? (Each correct answer presents a complete solution.
Choose two.)

• A. Use AJAX to retrieve the database information.
• B. Use a control that retrieves and displays the database information.
• C. Use a service that proxies the database queries and caches the results.
• D. Use SQL Server replication.

You are creating an ASP.NET Web site. The site contains pages that are available to anonymous users.
The site also contains a page named Premium.aspx that provides premium content to only members of a
group named Subscribers.
You need to modify the web.config file to ensure that Premium.aspx can be accessed by only members of
the Subscribers group.
Which configuration should you use?

• A. <location path="Premium.aspx"> <system.web> <authorization> <allow users="Subscribers"/> <deny users="*"/> </authorization> </system.web> </location>
• B. <location path="Premium.aspx"> <system.web> <authorization> <allow roles="Subscribers"/> <deny users="?"/> </authorization> </system.web> </location>
• C. <location path="Premium.aspx"> <system.web> <authorization> <allow roles="Subscribers"/> <deny users="*"/> </authorization> </system.web> </location>
• D. <location path="Premium.aspx"> <system.web> <authorization> <deny users="*"/> <allow roles="Subscribers"/>
  </authorization>
  </system.web>
  </location>

You are troubleshooting an ASP.NET Web application. System administrators have recently expanded your
web farm from one to two servers. Users are periodically reporting an error message about invalid view
state.
You need to fix the problem.
What should you do?

• A. Override the SavePageStateToPersistenceMedium and LoadPageStateFromPersistenceMedium methods in the page base class to serialize the view state to a local web server file.
• B. Set viewStateEncryptionMode to Auto in web.config on both servers.
• C. Change the session state mode to SQL Server on both servers and ensure both servers use the same connection string.
• D. Set the machineKey in machine.config to the same value on both servers.