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. You are
creating the data layer of the application. You write the following code segment. (Line numbers are included
for reference only.)
01 public static SqlDataReader GetDataReader(string sql){
02 SqlDataReader dr;
03
04 return dr;
05 }
You need to ensure that the following requirements are met:
*The SqlDataReader returned by the GetDataReader method can be used to retrieve rows from the
database.
*SQL connections opened within the GetDataReader method will close when the SqlDataReader is closed.
Which code segment should you insert at line 03?

• A. SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
  dr = cmd.ExecuteReader();
  cnn.Close();
  }
  catch {
  throw;
  }
• B. using (SqlConnection cnn=new SqlConnection(strCnn)){
  try {
  SqlCommand cmd =new SqlCommand(sql, cnn);
  cnn.Open();
  dr = cmd.ExecuteReader();
  }
  catch {
  throw;
  }
  }
• C. SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
  dr = cmd.ExecuteReader();
  }
  finally {
  cnn.Close();
  }
• D. SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
  dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  }
  catch {
  cnn.Close();
  throw;
  }

You are designing an ASP.NET Web Forms application.
You have the following requirements:
*Make use of exclusive features in a newly released Web browser.
*Do not change existing code files.
You need to design the application to meet the requirements.
Which approach should you recommend?

• A. Use a .browser file.
• B. Use the Web application's master page.
• C. Use the HttpWorkerRequest class.
• D. Parse the UserAgent string in Page_Load.

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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the ADO.NET Entity Framework to model entities. You create an entity as shown in the following code fragment.
<EntityType Name="ProductCategory"> <Key>
<PropertyRef Name="ProductCategoryID" />
</Key>
<Property Name="ProductCategoryID" Type="int" Nullable="false" StoreGeneraedPattern="Identity" />
<Property Name="ParentProductCategoryID" Type="int" />
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
...
</EntityType>
You need to provide two entity-tracking fields: "rowguid that is automatically generated when the entity is created "ModifiedDate that is automatically set whenever the entity is updated Which code fragment should you add to the .edmx file?

• A. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/ >
• B. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>
• C. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>
• D. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/ >

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
create stored procedures by using the following signatures:
"CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
"CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price float)
"CREATE procedure [dbo].[Product_Delete](@id int)
"CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
"CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp timestamp) "CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as shown in the exhibit. You need to map the Product and Order entities to the stored procedures. Which two procedures should you add to the @productId parameter? (Each correct answer presents part of the solution. Choose two.)

• A. Order_Update
• B. Order_Delete
• C. Product_Update
• D. Product_Delete