Free Microsoft 70-516 Exam Dumps Questions & Answers

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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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:

You add the following code segment to query the first row of the ProductCatalog table. (Line numbers are included for reference only.)
01 using(SqlConnection 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 {
10 var id = reader.GetInt32(0);
11 ...
12 reader.Close();
13 }
14 }
Which answer belongs in line 11?

• A.  var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);
• B.  var weight
  = reader.GetFloat(1); var price = reader.GetDecimal(2); var status = reader.GetByte(3);
• C.  var weight = reader.GetFloat(1); var price = reader.Doublel(2); var status = reader.GetByte(3);
• D.  var weight = reader.GetDouble(1); var price = reader.GetFloat(2); var status = reader.GetBoolean(3);

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET
application.
The application connects to a Microsoft SQL Server database. The application is hosted on a Web server
along with other applications.
You need to secure the transmission of data between the application and the database.
You need to achieve this goal without affecting other applications. What should you do?

• A.  Use Secure Sockets Layer (SSL) to establish connections to the database.
• B.  Encrypt the connection string.
• C.  Use encryption to store sensitive data in the database.
• D.  Use Internet Protocol Security (IPSec) to secure the communication channel.

You are a tasked with performing a code review. The business rule is the following:
-If INSERTs into the first table succeed, then INSERT into the second table.
-However, if the INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

• A.  try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequiresNew))
  { .... }
  }
  }
  }
• B.  try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  }
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew)) { .... } }
• C.  try
  {
  using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption)
  {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
  { .... }
  }
  }
  }
• D.  try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
  { .... }
  ......
  }
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the Entity Framework Designer to create an Entity Data Model (EDM).
You need to create a database creation script for the EDM. What should you do?

• A.  Run the Generate Database command.
• B.  Use a new Self-Tracking Entities template.
• C.  Select Run Custom Tool from the solution menu.
• D.  Drag entities to Server Explorer.