Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev : 70-523

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

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.PreserveChanges;
• B. context.MergeOption = MergeOption.AppendOnly;
• C. context.MergeOption = MergeOption.NoTracking;
• D. context.MergeOption = MergeOption.OverwriteChanges;

You are implementing an ASP. NET MVC 2 Web application. You add a controller named
CompanyController.
You need to modify the application to handle the URL path /company/info.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Right-click the Views folder, and select View from the Add submenu to create the view for the action.
• B. Add the following method to the CompanyController class. public ActionResult Company_Info() {
  return View();
  }
• C. Right-click inside the action method in the CompanyController class, and select Add View to create a view for the action.
• D. Add the following method to the CompanyController class. public ActionResult Info () {
  return View();
  }

You are dynamically adding controls to an ASP.NET page in the Page_Load event handler. The page will
have text boxes that correspond to the columns in a database table. Each text box will be preceded by a
label that displays the name of the corresponding column.
You need to create the form so that when the user clicks the label, the corresponding text box is selected
for input.
What should you do?

• A. For each column, output the following HTML, where COL is replaced by the name of the column. <label AssociatedControlID="COL">COL</label> <input name="COL" type="text" id="COL" />
• B. For each column, create an asp:Label control and a corresponding asp:TextBox that have the same ID.
• C. For each column, create an asp:Label control and set the AssociatedControlID to the ID of the corresponding asp:Textbox control.
• D. For each column, output the following HTML, where COL is replaced by the name of the column. <label>COL</label> <input name="COL" type="text" id="COL" />

You are implementing an ASP.NET application that includes a page named TestPage.aspx. TestPage.
aspx uses a master page named TestMaster.master. You add the following code to the TestPage.aspx
code-behind file to read a TestMaster.master public property named CityName.
protected void Page_Load(object sender, EventArgs e).
{ string s = Master.CityName;.
} You need to ensure that TestPage.aspx can access the CityName property. What should you do?

• A. Set the Explicit attribute in the @ Master directive of the TestMaster.master page to true.
• B. Add the following directive to TestPage.aspx. <%@ MasterType VirtualPath="~/TestMaster.master" %>
• C. Add the following directive to TestPage.aspx. <%@ PreviousPageType VirtualPath="~/TestMaster.master" %>
• D. Set the Strict attribute in the @ Master directive of the TestMaster.master page to true.