Free Microsoft 070-516 Exam Dumps Questions & Answers

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create a Database Access Layer (DAL) that is database-independent. The DAL includes the following
code segment.
(Line numbers are included for reference only.)
01 static void ExecuteDbCommand(DbConnection connection)
02 {
03 if (connection != null){
04 using (connection){
05 try{
06 connection.Open();
07 DbCommand command = connection.CreateCommand();
08 command.CommandText = "INSERT INTO Categories (CategoryName)
VALUES ('Low Carb')";
09 command.ExecuteNonQuery();
10 }
11 ...
12 catch (Exception ex){
13 Trace.WriteLine("Exception.Message: " + ex.Message);
14 }
15 }
16 }
17 }
You need to log information about any error that occurs during data access.
You also need to log the data provider that accesses the database. Which code segment should you insert
at line 11?

• A.  catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• B.  catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }
• C.  catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• D.  catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }

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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
You need to retrieve an entity, and you must ensure that the entity is loaded in a detached state.
Which MergeOption enumeration value should you use to retrieve the entity?

• A.  NoTracking
• B.  AppendOnly
• C.  PreserveChanges
• D.  OverwriteChanges

You are developing an ADO.NET 4.0 application that interacts with a Microsoft SQL Server 2008 server
through the SQL Server Native Client.
You create a trace DLL registry entry and you register all of the trace schemas.
You need to trace the application data access layer. Which control GUID file should you use?

• A.  ctrl.guid.msdadiag
• B.  ctrl.guid.snac10
• C.  ctrl.guid.adonet
• D.  ctrl.guid.mdac

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

• A.  SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;
• B.  SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;
• C.  SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;
• D.  SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;