Pass with professional 70-528 actual quiz materials

You have a Microsoft ASP.NET Web site that connects to a Microsoft SQL Server database.
You configure the database to allow only trusted connections. The Web site uses Windows Authentication
to authenticate all users.
You create a new domain account named dbUser that has access to the database.
You need to ensure that the Web site can access the database without allowing each individual user to
access the database.
What should you do?

• A. Impersonate the dbUser account when you access the database.
• B. Modify the connection string in the Web.config file to use the dbUser account.
• C. Use the anonymous account when you access the database.
• D. Grant the Public database role access to the database.

You create a Web site to use a Microsoft ASP.NET membership provider. You create the following roles: Admin, Manager, and Employee.
The Web page contains the following code fragment.
<asp:LoginView id="LoginView1" runat="server">
<RoleGroups>
<asp:RoleGroup Roles="Admin">
<ContentTemplate>
You are logged in as an administrator.
</ContentTemplate> </asp:RoleGroup> </RoleGroups> </asp:LoginView
You need to display a message to authenticated users even if a RoleGroup has not been defined for their role.
Which code fragment should you add to the LoginView control?

• A. <asp:RoleGroup Roles="Default"> <ContentTemplate> Welcome! </ContentTemplate> </asp:RoleGroup>
• B. <LoggedInTemplate> Welcome! </LoggedInTemplate>
• C. <AnonymousTemplate> Welcome! </AnonymousTemplate>
• D. <asp:RoleGroup Roles="User"> <ContentTemplate> Welcome! </ContentTemplate> </asp:RoleGroup>

You have a Microsoft ASP.NET Web application.
You create a handler named ImageGenerator.ashx. The handler dynamically generates an image for display on a Web page.
The handler contains the following code. (Line numbers are included for reference only.)
01 Public Sub ProcessRequest(ByVal context As HttpContext)
02 Dim outfilePath As String = GetFilePath()
03 Dim bitmapImage As Bitmap = GetBitmapImage()
04 context.Response.ContentType = "image/jpeg"
06 bitmapImage.Dispose()
07 End Sub
You need to ensure that requests to ImageGenerator.ashx will return the image to the Web browser.
Which line of code should you insert at line 05?

• A. bitmapImage.Save(outfilePath, ImageFormat.Jpeg)
• B. context.Response.Write(bitmapImage.ToString())
• C. bitmapImage.Save(context.Response.OutputStream, ImageFormat.Jpeg)
• D. context.Response.Output.Write(bitmapImage.ToString())

You are creating a Web Form to report on orders in a database.
You create a DataSet that contains Order and OrderDetails tables.
You add a relationship between the tables by using the following code segment.
DataTable dtOrders = dsOrders.Tables["Orders"];
DataTable dtOrderDetails =
dsOrders.Tables["OrderDetails"];
DataColumn colParent = dtOrders.Columns["OrderID"];
DataColumn colChild = dtOrderDetails.Columns["OrderID"];
dsOrders.Relations.Add("Rel1", colParent, colChild, false);
You need to calculate the total quantity of items for each order by adding the values in the Quantity column in the OrderDetails rows for each order.
Which code segment should you use?

• A. foreach (DataRow parentRow in dtOrders.Rows) { currQty = 0; foreach (DataRow childRow in dtOrderDetails.Rows) { currQty += Convert.ToInt32(childRow["Quantity"]); } ShowQty(currQty); }
• B. foreach (DataRow parentRow in dtOrders.Rows) { currQty = 0; DataRow[] childRows = parentRow.GetChildRows("Rel1"); currQty += childRows.Length; ShowQty(currQty); }
• C. foreach (DataRow parentRow in dtOrders.Rows) { currQty = 0; foreach (DataRow childRow in parentRow.GetChildRows("Rel1")) { currQty += Convert.ToInt32(childRow["Quantity"]); } ShowQty(currQty); }
• D. foreach (DataRow childRow in dtOrders.Rows) { currQty = 0; foreach (DataRow parentRow in childRow.GetParentRows("Rel1")) { currQty += Convert.ToInt32(childRow["Quantity"]); } ShowQty(currQty); }

You are developing a Web application that has two distinct UIs. One UI is targeted to desktop browsers.
The other UI is targeted to mobile devices.
The mobile devices might or might not support cookies and relative URLs.
Users request the Default.aspx page.
You need to redirect users to the appropriate UI, depending on whether they are using a mobile device or a desktop browser.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

• A. Add the following code segment to the Page_Load event of Default.aspx. If Request.Browser.Type = "MobileDevice" Then Response.Redirect("MobileDefault.aspx") Else Response.Redirect("DesktopDefault.aspx") End If
• B. Add the following node to the <system.web> element of the Web.config file. <httpRuntime useFullyQualifiedRedirectUrl="false" />
• C. Add the following code segment to the Page_Load event of Default.aspx. If Request.Browser("IsMobileDevice") = "true" Then Response.Redirect("MobileDefault.aspx") Else Response.Redirect("DesktopDefault.aspx") End If
• D. Add the following node to the <system.web> element of the Web.config file. <httpRuntime useFullyQualifiedRedirectUrl="true" />