You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
The application uses nested transaction scopes. An inner transaction scope contains code that inserts
records into the database.
You need to ensure that the inner transaction can successfully commit even if the outer transaction rolls
back.
What are two possible TransactionScope constructors that you can use for the inner transaction to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

• A. TransactionScope(TransactionScopeOption.Required)
• B. TransactionScope()
• C. TransactionScope(TransactionScopeOption.Suppress)
• D. TransactionScope(TransactionScopeOption.RequiresNew)

Explanation: Only visible for DumpsQuestion 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.
You create an Entity Data Model (EDM) by using the Microsoft ADO.NET Entity Data Model Designer (Entity
Designer).
The EDM contains a complex type. You need to map a stored procedure to the complex type by using the
Entity Designer.
What should you do?

• A. Add an entity that mirrors the properties of the complex type.
• B. Add an association to the stored procedure.
• C. Add a function import for the stored procedure.
• D. Add a code generation item that has the name of the stored procedure.

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You add the following stored procedure to the database.
CREATE PROCEDURE dbo.GetClassAndStudents AS BEGIN
SELECT * FROM dbo.Class
SELECT * FROM dbo.Student
END
You create a SqIConnection named conn that connects to the database.
You need to fill a DataSet from the result that is returned by the stored procedure.
The first result set must be added to a DataTable named Class, and the second result set must be added to
a DataTable named Student.
Which code segment should you use?

• A. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.Fill(ds);
• B. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.TableMappings.Add("Table", "Class"); ad.TableMappings.Add("Table1", "Student") ; ad.Fill(ds) ;
• C. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");
• D. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);

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

You use Microsoft .NET Framework 4.0 to develop an application that uses WCF Data Services to persist entities from the following Entity Data Model.

You create a new Blog instance named newBlog and a new Post instance named newPost as shown in the
following code segment.
(Line numbers are included for reference only.)
01 Blog newBlog = new Blog();
02 Post newPost = new Post();
03 ....
04 Uri serviceUri = new Uri("...");
05 BlogsEntities context = new BlogsEntities(serviceUri);
06 ....
You need to ensure that newPost is related to newBlog through the Posts collection property and that
newPost and newBlog are sent to the service.
Which code segment should you insert at line 06?

• A. newBlog.Posts.Add(newPost); context.AddToBlogs(newBlog); context.AddToPosts(newPost); context.SaveChanges(SaveChangesOptions.Batch);
• B. newBlog.Posts.Add(newPost); context.UpdateObject(newBlog); context.UpdateObject(newPost); context.SaveChanges(SaveChangesOptions.Batch);
• C. newBlog.Posts.Add(newPost); context.AttachTo("Blogs", newBlog); context.AttachTo("Posts", newPost); context.SaveChanges(SaveChangesOptions.Batch);
• D. context.AttachLink(newBlog, "Posts", newPost); context.SaveChanges(SaveChangesOptions.Batch) ;

Explanation: Only visible for DumpsQuestion 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 that
uses LINQ to SQL.
The application contains the following model.

Each region contains a single vendor. Customers order parts from the vendor that is located in their region.
You need to ensure that each row in the Customer table references the appropriate row from the Vendor
table.
Which code segment should you use?

• A. SalesDataContext dc = new SalesDataContext("...");
  var query = from c in dc.Customers
  join v in dc.Vendors on c.VendorlD equals v.VendorID
  select new { Customer = c, Vendor = v };
  foreach (var u in query){
  u.Vendor.Region = u.Customer.Region;
  }
  dc.SubmitChanges();
• B. SalesDataContext dc = new SalesDataContext("...");
  var query = from c in dc.Customers
  join v in dc.Vendors on c.Region equals v.Region
  select new { Customer = c. Vendor = v };
  foreach (var u in query){
  u.Vendor.VendorlD = u.Customer.VendorID;
  }
  dc.SubmitChanges();
• C. SalesDataContext dc = new SalesDataContext("...");
  var query = from v in dc.Vendors
  join c in dc.Customers on v.Region equals c.Region
  select new { Vendor = v, Customer = c };
  foreach (var u in query){
  u.Customer.VendorlD = u.Vendor.VendorlD;
  }
  dc.SubmitChanges();
• D. SalesDataContext dc = new SalesDataContext("...");
  var query = from v in dc.Vendors
  join c in dc.Customers on v.VendorlD equals c.VendorID
  select new { Vendor = v, Customer = c };
  foreach (var u in query){
  u.Customer.Region = u.Vendor.Region;
  }
  dc.SubmitChanges();