Free Microsoft 70-523 Exam Dumps Questions & Answers

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to several SQL Server databases. You create a function that modifies customer records that are stored in multiple databases. All updates for a given record are performed in a single transaction. You need to ensure that all transactions can be recovered. What should you do?

• A.  Call the EnlistDurable method of the Transaction class.
• B.  Call the Reenlist method of the TransactionManager class.
• C.  Call the EnlistVolatile method of the Transaction class.
• D.  Call the RecoveryComplete method of the TransactionManager class.

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.  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();
  }
• B.  Insert the following code segment at line 07. using (SqlConnection conn = new SqlConnection(connString)){
  conn.Open();
  }
• C.  Insert the following code segment at line 04. private SqlConnection conn = new SqlConnection(connString); public void Open(){
  conn.Open();
  }
  public void Close(){
  conn.Close();
  }
• D.  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();
  }

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

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.GetFloat(1); var price = reader.GetDouble(2); var status = reader.GetByte(3);
• C.  var weight = reader.GetDecimal(1); var price = reader.GetFloat(2); var status = reader.GetByte(3);
• D.  var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);

You are implementing an ASP.NET page. Client-side script requires data. Your application includes a class
named Person with a Name property of type string. The code-behind file of the page includes the following
code segment.
public string JsonValue;
List<Person> people = GetPeopleList();
JavaScriptSerializer json = new JavaScriptSerializer();
You need to use the JavaScriptSerializer class to serialize only the Name property of each item in the
people list.
Which code segment should you use?

• A.  JsonValue = json.Serialize(people.Select(p => p.Name)); var names = from person in people select person; JsonValue = "{" + json.Serialize(names) + "}";
• B.  JsonValue = json.Serialize(people.SelectMany( p => Name.AsEnumerable())); var names = from person in people select person; JsonValue = json.Serialize(names);