Try and practice the latest Microsoft : 070-516 real questions & answers

You use Microsoft .NET Framework 4.0 to develop an application.
You write the following code to update data in a Microsoft SQL Server 2008 database.
(Line numbers are included for reference only.)
01 private void ExecuteUpdate(SqlCommand cmd, string connString, string
updateStmt)
02 {
03 ...
04 }
You need to ensure that the update statement executes and that the application avoids connection leaks. Which code segment should you insert at line 03?

• A. using (SqlConnection conn = new SqlConnection(connString))
  {
  cmd.Connection = conn;
  cmd.CommandText = updateStmt;
  cmd.ExecuteNonQuery();
  cmd.Connection.Close();
  }
• B. using (SqlConnection conn = new SqlConnection(connString))
  {
  conn.Open() ;
  cmd.Connection = conn;
  cmd.CommandText = updateStmt;
  cmd.ExecuteNonQuery() ;
  }
• C. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery(); cmd.Connection.Close() ;
• D. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery();

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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 Reenlist method of the TransactionManager class.
• B. Call the EnlistDurable method of the Transaction class.
• C. Call the RecoveryComplete method of the TransactionManager class.
• D. Call the EnlistVolatile method of the Transaction class.

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities. You deploy an application to a
production server.
The application uses the model and mapping files that are deployed as application resources.
You need to update the conceptual model for the application on the production server. What should you do?

• A. Copy the updated .ssdl file to the production server.
• B. Copy the updated .csdl file to the production server.
• C. Recompile the application and redeploy the modified assembly file.
• D. Copy the updated .edmx file to the production server.

You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses
Integrated Windows authentication.
The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server
as the application.
You use the following connection string to connect to the database.
Integrated Security=SSPI; Initial Catalog=AdventureWorks;
The application must also execute a stored procedure on the same server on a database named pubs.
Users connect to the ASP.NET application through the intranet by using Windows-based authentication.
You need to ensure that the application will use connection pooling whenever possible and will keep the
number of pools to a minimum.
Which code segment should you use?

• A. command.CommandText = "exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=pubs")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• B. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• C. command.CommandText = "exec uspLoginAudit;";
  using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI;")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• D. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=AdventureWorks")) {
  connection.Open();
  command.ExecuteNonQuery();
  }

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

The application populates a DataSet object by using a SqlDataAdapter object.
You use the DataSet object to update the Categories database table in the database. You write the
following code segment.
(Line numbers are included for reference only.)
01 SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM Categories", connection);
02 SqlCommandBuilder builder = new SqlCommandBuilder(dataAdpater);
03 DataSet ds = new DataSet();
04 dataAdpater.Fill(ds);
05 foreach (DataRow categoryRow in ds.Tables[0].Rows)
06 {
07 if (string.Compare(categoryRow["CategoryName"].ToString(), searchValue,
true) == 0)
08 {
09 ...
10 }
11 }
12 dataAdpater.Update(ds);
You need to remove all the records from the Categories database table that match the value of the
searchValue variable.
Which line of code should you insert at line 09?

• A. ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();
• B. ds.Tables[0].Rows.Remove(categoryRow);
• C. ds.Tables[0].Rows.RemoveAt(0);
• D. categoryRow.Delete();

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).