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)
  {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
  { .... }
  }
  }
  }
• B. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
  { .... }
  ......
  }
  }
• C. try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequiresNew))
  { .... }
  }
  }
  }
• 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 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 server.
You need to ensure that applications authenticate against user information stored in the database before
the application is allowed to use the service.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Modify the Data Services service to use a Microsoft ASP.NET membership provider.
• B. Configure IIS to require Windows authentication.
• C. Configure IIS to allow anonymous access.
• D. Configure IIS to require basic authentication.
• E. Enable the WCF Authentication Service.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET Entity Framework Designer to model entities. You add the following stored
procedure to the database, and you add a function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment] @Name nvarchar(50), @ID int NULL OUTPUT
AS INSERT INTO Department (Name) VALUES (@Name) SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you use?

• A. using (SchoolEntities context = new SchoolEntities())
  {
  var id = context.InsertDepartment("Department 1", null);
  Console.WriteLine(id);
  }
• B. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", null));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• C. using (SchoolEntities context = new SchoolEntities())
  {
  ObjectParameter id = null;
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• D. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", typeof(int));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }

You use Microsoft .NET Framework 4.0 to develop an application. You use the XmlReader class to load
XML from a location that you do not control.
You need to ensure that loading the XML will not load external resources that are referenced in the XML.
Which code segment should you use?

• A. XmlReaderSettings settings = new XmlReaderSettings(); settings.CheckCharacters = true; XmlReader reader = XmlReader.Create("data.xml", settings);
• B. XmlReaderSettings settings = new XmlReaderSettings(); settings.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);
• C. XmlReaderSettings settings = new XmlReaderSettings(); settings.XmlResolver = null; XmlReader reader = XmlReader.Create("data.xml", settings);
• D. XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Auto; XmlReader reader = XmlReader.Create("data.xml", settings);