Microsoft 070-523 Exam Questions : UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use Microsoft ADO.NET Entity Data Model (EDM) to model entities. You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name="CPerson">
<Key>
<PropertyRef Name="PersonId" />
</Key>
<Property Name="PersonId" Type="Int32" Nullable="false" />
<Property Name="CompanyName" Type="String" />
<Property Name="ContactName" Type="String" />
<Property Name="ContactTitle" Type="String" />
<Property Name="Address" Type="String" /> </EntityType>
You need to ensure that entities within the application are able to add properties related to the city, region, and country of Person's address. What should you do?

• A. "Create a new complex type named CAddress that contains the properties for city, region, and country. "Change the Type of the Address property in CPerson to "Self.CAddress".
• B. "Create a SubEntity named Address. "Map the SubEntity to a stored procedure that retrieves city, region, and country.
• C. "Create a view named Name that returns city, region, and country along with person IDs. "Add a WHERE clause to filter the results to display only the City, Region and Country properties for a specific Person entity.
• D. "Create a new entity named Address. "Add a person ID property to filter the results to display only the City, Region, and Country properties for a specific Person entity.

You are designing the user interface for an ASP.NET Web application. The Web application allows several departments to personalize the style of their sections of the Web application.
All departmental section styles derive from the core styles of the Web application and can only append to
the Web application's core styles. The departmental master pages inherit from the Web application's
master page.
You need to ensure that core CSS styles appear in all pages of the Web application.
Which approach should you recommend?

• A. Link from the Web application's master page to a .css file containing the CSS styles.
• B. Add a ContentPlaceHolder containing the CSS styles to the Web application's master page.
• C. Add a master.css file containing the CSS styles to the Web application.
• D. Link from the Web application's master page to a css.ascx file containing the CSS styles.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application.
The application contains the following code segment. (Line numbers are included for reference only.)
01 class DataAccessLayer
02 {
03 private static string connString;
04
05 ...
06 public static DataTable GetDataTable(string command){
07
08 ...
09 }
10 }
You need to define the connection life cycle of the DataAccessLayer class. You also need to ensure that
the application uses the minimum number of connections to the database.
What should you do?

• A. Replace line 01 with the following code segment.
  class DataAccessLayer : IDisposable
  Insert the following code segment to line 04.
  private SqlConnection conn = new SqlConnection(connString);
  public void Open(){
  conn.Open();
  }
  public void Dispose(){
  conn.Close();
  }
• B. Insert the following code segment at line 04. private SqlConnection conn = new SqlConnection(connString); public void Open(){
  conn.Open();
  }
  public void Close(){
  conn.Close();
  }
• C. Insert the following code segment at line 07. using (SqlConnection conn = new SqlConnection(connString)){
  conn.Open();
  }
• D. Insert the following code segment at line 04. private static SqlConnection conn = new SqlConnection(connString); public static void Open(){
  conn.Open();
  }
  public static void Close(){
  conn.Close();
  }

You create a Web page that contains drop-down menus that are defined by using div tags in the following
code.
<div class="dropdown-menu">
<div class="menu-title">Menu One</div>
<div class="menu-items" style="display:none;">
<div><a href="#">Item One</a></div>
<div><a href="#">Item Two</a></div>
</div>
</div>
<div class="dropdown-menu">
<div class="menu-title">Menu Two</div>
<div class="menu-items" style="display:none;">
<div><a href="#">Item Three</a></div>
<div><a href="#">Item Four</a></div>
</div>
</div>
You need to write a JavaScript function that will enable the drop-down menus to activate when the user
positions the mouse over the menu title.
Which code segment should you use?

• A. $(".dropdown-menu").hover( function () { $(".menu-items", this).slideDown(100); }, function () { $(".menu-items",this).slideUp(100); } );
• B. $(".dropdown-menu").hover( function () { $(".menu-items").slideDown(100); }, function () { $(".menu-items").slideUp(100); } );
• C. $(".dropdown-menu").hover( function () { $(this)".slideDown(100); }, function () { $(this).slideUp(100); } );
• D. $(".dropdown-menu").hover(
  function () {
  $("this,".menu-title",).slideDown(100);
  },
  function () {
  $("this.menu-title",).slideUp(100);
  }
  );

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.
The database includes a database table named ProductCatalog as shown in the exhibit. (Click the Exhibit
button.)
You add the following code segment to query the first row of the ProductCatalog table. (Line numbers are
included for reference only.)
01 using (var cnx = new SqlConnection(connString))
02 {
03 var command = cnx.CreateCommand();
04 command.CommandType = CommandType.Text;
05 command.CommandText ="SELECT TOP 1 * FROM dbo.ProductCatalog";
06 cnx.Open();
07 var reader = command.ExecuteReader();
08 if (reader.Read()) {
09 var id = reader.GetInt32(0);
10
11 reader.Close();
12 }
13 }
You need to read the values for the Weight, Price, and Status columns.
Which code segment should you insert at line 10?
Exhibit:

• A. var weight = reader.GetDouble(1); var price = reader.GetFloat(2); var status = reader.GetBoolean(3);
• B. var weight = reader.GetDecimal(1); var price = reader.GetFloat(2); var status = reader.GetByte(3);
• C. var weight = reader.GetFloat(1); var price = reader.GetDouble(2); var status = reader.GetByte(3);
• D. var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);