70-523 試験問題を無料オンラインアクセス

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use the ADO.NET Entity Data Model (EDM) to define a Customer entity. You need to add a new Customer to the data store without setting all the customer's properties. What should you do?

• A.Override the SaveChanges method for the Customer object.
• B.Call the Create method of the Customer object.
• C.Override the Create method for the Customer object.
• D.Call the CreateObject method of the Customer object.

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.using (SqlConnection cnn=new SqlConnection(strCnn)){
  try {
  SqlCommand cmd =new SqlCommand(sql, cnn);
  cnn.Open();
  dr = cmd.ExecuteReader();
  }
  catch {
  throw;
  }
  }
• B.SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
  dr = cmd.ExecuteReader();
  cnn.Close();
  }
  catch {
  throw;
  }
• C.SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
  dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  }
  catch {
  cnn.Close();
  throw;
  }
• D.SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
  dr = cmd.ExecuteReader();
  }
  finally {
  cnn.Close();
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the ADO.NET Entity Framework to manage customer and related order records. You add a new order for an existing customer. You need to associate the Order entity with the Customer entity. What should you do?

• A.Call the Add method on the EntityCollection of the Order entity.
• B.Use the AddObject method of the ObjectContext to add both Order and Customer entities.
• C.Use the Attach method of the ObjectContext to add both Order and Customer entities.
• D.Set the Value property of the EntityReference of the Order entity.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. You deploy the service to the following URL: http://contoso.com/Northwind.svc. You want to query the WCF Data Services service to retrieve a list of customer objects. You need to ensure that the query meets the following requirements: "Only customers that match the following filter criteria are retrieved: City="Seattle" AND Level > 200. "Data is sorted in ascending order by the ContactName and Address properties. Which URL should you use for the query?

• A.http: //contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName, Address
• B.http: //contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName,Address
• C.http: //contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName and Address
• D.http: //contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName and Address

You create an ASP.NET page that contains the following tag.
<h1 id="hdr1" runat="server">Page Name</h1>
You need to write code that will change the contents of the tag dynamically when the page is loaded. What
are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose
two.)

• A.(hdr1.Parent as HtmlGenericControl).InnerText = "Text";
• B.this.hdr1.InnerHtml = "Text";
• C.HtmlGenericControl h1 = this.FindControl("hdr1") as HtmlGenericControl; h1.InnerText = "Text";
• D.HtmlGenericControl h1 = Parent.FindControl("hdr1") as HtmlGenericControl; h1.InnerText = "Text";