Get real 70-516 exam questions for better preparation

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.
You need to use a spatial value type as a parameter for your database query. What should you do?

• A. Set the parameter's SqlDbType to Binary.
• B. Set the parameter's SqlDbType to Variant.
• C. Set the parameter's SqlDbType to Structured. Set the parameter's TypeName to GEOMETRY.
• D. Set the parameter's SqlDbType to Udt. Set the parameter's UdtTypeName to GEOMETRY.

Explanation: Only visible for itPass4sure 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 two different Microsoft SQL Server 2008 database servers named Server1 and
Server2.
A string named sql1 contains a connection string to Server1. A string named sql2 contains a connection
string to Server2.
01 using (TransactionScope scope = new
02 ...
03 )
04 {
05 using (SqlConnection cn1 = new SqlConnection(sql1))
06 {
07 try{
08 ...
09 }
10 catch (Exception ex)
11 {
12 }
13 }
14 scope.Complete();
15 }
You need to ensure that the application meets the following requirements:
-There is a SqlConnection named cn2 that uses sql2.
-The commands that use cn1 are initially enlisted as a lightweight transaction.
The cn2 SqlConnection is enlisted in the same TransactionScope only if commands executed by cn1 do not
throw an exception.
What should you do?

• A. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.RequiresNew)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2)) {
  try{
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }
• B. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.Suppress)
  Insert the following code segment at line 08.
  cn1.Open();
  ...
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  }
  catch (Exception ex){}
  }
• C. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.RequiresNew)
  Insert the following code segment at line 08.
  cn1.Open();
  ...
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  }
  catch (Exception ex){}
  }
• D. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.Suppress)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }

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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET
application.
You want to connect the application to a Microsoft SQL Server Express 2008 database named
MyDatabase.
The primary database file is named MyDatabase.mdf and it is stored in the App_Data folder.
You need to define the connection string. Which connection string should you add to the Web.config file?

• A. Data Source=.\SQLEXPRESS; Initial Catalog=MyDataBase; Integrated Security=True; User Instance=True
• B. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\MyDatabase.mdf; Integrated Security=True; User Instance=True
• C. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\App_Data\MyDatabase.mdf; Integrated Security=SSPI; User Instance=True
• D. Data Source=localhost; Initial Catalog=MyDataBase; Integrated Security=SSPI; User Instance=True

Explanation: Only visible for itPass4sure 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 a Microsoft SQL Server database. You use the ADO.NET Entity Framework to
model entities.
You need to add a new type to your model that organizes scalar values within an entity.
You also need to map stored procedures for managing instances of the type. What should you do?

• A. 1. Add the stored procedures in the SSDL file along with a Function attribute.
  2.Define a complex type in the CSDL file.
  3.Map the stored procedure in the MSL file with an AssociationEnd element.
• B. 1. Add the stored procedures in the SSDL file along with a Function attribute.
  2.Derive an entity class from the existing entity as a complex type.
  3.Map the stored procedure in the MSL file with a ModificationFunctionElement.
• C. 1. Use the edmx designer to import the stored procedures.
  2.Derive an entity class from the existing entity as a complex type.
  3.Map the stored procedure in the MSL file with an AssociationEnd element.
• D. 1. Add the stored procedures in the SSDL file along with a Function attribute.
  2.Define a complex type in the CSDL file.
  3.Map the stored procedure in the MSL file with a ModificationFunctionElement.

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

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. The application includes two
ObjectContext instances named context1 and context2.
You need to persist the changes in both object contexts within a single transaction. Which code segment
should you use?

• A. using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope1 = new TransactionScope (TransactionScopeOption.RequireNew))
  {
  context1.SaveChanges();
  scope1.Complete();
  }
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequireNew))
  {
  context2.SaveChanges();
  scope2.Complete();
  }
  scope.Complete();
  }
• B. using (TransactionScope scope = new TransactionScope())
  {
  context1.SaveChanges();
  context2.SaveChanges();
  scope.Complete();
  }
• C. using (TransactionScope scope = new TransactionScope())
  {
  context1.SaveChanges();
  context2.SaveChanges();
  }
• D. using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope1 = new TransactionScope (TransactionScopeOption.RequireNew)) {
  context1.SaveChanges();
  }
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequireNew))
  {
  context2.SaveChanges();
  }
  }

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