Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev Sample Questions:

1. 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 server. You need to ensure that applications authenticate against user information stored in the database before the application is allowed to use the service. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Configure IIS to require basic authentication.
B) Configure IIS to allow anonymous access.
C) Modify the Data Services service to use a Microsoft ASP.NET membership provider.
D) Enable the WCF Authentication Service.
E) Configure IIS to require Windows authentication.

2. 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 stores encrypted credit card numbers in the database. You need to ensure that credit card numbers can be extracted from the database. Which cryptography provider should you use?

A) AESCryptoServiceProvider
B) DSACryptoServiceProvider
C) SHA1CryptoServiceProvider
D) MD5CryptoServiceProvider

3. 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) 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 }
C) 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 } )
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) }

4. 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(((IQueryable)productQuery).Expression);
B) Trace.WriteLine(productQuery.ToTraceString());
C) Trace.WriteLine(productQuery.CommandText);
D) Trace.WriteLine(productQuery.ToString());

5. You are implementing an ASP.NET Web page.
You need to add a text box that allows only values between 1 and 10, inclusive, to be submitted. Which two
code segments should you use? (Each correct answer presents part of the solution. Choose two.)

A) <asp:TextBox ID="txt1" runat="server" /> <asp:CustomValidator ID="val1" runat="server" ControlToValidate="txt1" ClientValidationFunction="validate_value" ErrorMessage="Value invalid" />
B) <asp:TextBox ID="txt1" runat="server" onChange="validate_value(this, args)" />
C) <script type="text/javascript"> function validate_value(obj, args) { args.IsValid = (args.Value >= 1 && args.Value <= 10); } </script>
D) <script type="text/javascript"> function validate_value(obj, args) { return (args.Value >= 1 && args.Value <= 10); } </script>

Solutions: