Free Microsoft 70-516 Exam Dumps Questions & Answers

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.Recompile the application and redeploy the modified assembly file.
• B.Copy the updated .ssdl file to the production server.
• C.Copy the updated .edmx file to the production server.
• D.Copy the updated .csdl file to the production server.

Which one of these samples it the correct way to close the connection using Command Behavior?

• A.SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); rdr.Close(); Console.WriteLine("{0}", rdr);
• B.SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); conn.Close(); Console.WriteLine("{0}", rdr);
• C.SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Console.WriteLine("{0}", rdr);
• D.using (SqlDataReader rdr = new SqlDataReader())
  {
  string sql = @"sql statement";
  SqlConnection conn = connection.GetConnection();
  SqlCommand cmd = new SqlCommand(sql, conn);
  SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  Console.WriteLine("{0}", rdr);
  }

Which method will return all nodes of an XDocument?

• A.doc.GetAllnodes();
• B.doc.Descendants();
• C.doc.Root.Allnodes();
• D.doc.DescendantNodes();

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 RecoveryComplete method of the TransactionManager class.
• B.Call the Reenlist method of the TransactionManager class.
• C.Call the EnlistVolatile method of the Transaction class.
• D.Call the EnlistDurable method of the Transaction class.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service
on
the production server, attempting to update or delete an entity results in an error.
You need to ensure that you can update and delete entities on the production server. What should you do?

• A.Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);
• B.Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.
• C.Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.
• D.Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);