TS: Accessing Data with Microsoft .NET Framework 4 (070-516) Free Practice Test

Question 1

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.Suppress)
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.RequiresNew)
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.
using (SqlConnection cn2 = new SqlConnection(sql2)) {
try{
cn2.Open();
...
cn1.Open();
...
}
catch (Exception ex){}
}

D. 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){}
}

Correct Answer: D

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

Question 2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
WCF Data Services uses an authentication scheme that requires an HTTP request that has the following
header format:
GET /Odata.svc/Products(1)
Authorization: WRAP access_token="123456789"
The application includes the following code. (Line numbers are included for reference only.)
01 public class program
02 {
03 Public void GetProducts()
04 {
05 var proxy = new MyDataServiceContext("...");
06 ...
07 }
08 }
You need to ensure that the correct authentication header is present when requests are made by using
MyDataServiceContext.
What should you do?

A. Insert the following code segmen at line 06:
Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
(proxy_SendingRequest);
Insert the following code segmen at line 09:
void proxy_SendingRequest(object sender, SendingRequestEventArgs e){
e.RequestsHeaders.Add("WRAP access_token", "123456789");
}

B. Insert the following code segment at line 06:
Proxy.Credentials = new NetworkCredential("Authorization", "WRAP
access_token=\"123456789"\"");

C. Insert the following code segment at line 06:
Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
(proxy_SendingRequest);
Insert the following code segment at line 09:
void proxy_SendingRequest(object sender, SendingRequestEventArgs e){ e.RequestsHeaders.Add("Authorization","WRAP access_token", "123456789"); }

D. Insert the following code segmen at line 06:
Proxy.Credentials = new NetworkCredential("WRAP access_token", "123456789");

Correct Answer: C

Question 3

You are adding a process to the application. The process performs the following actions:
1.Opens a ContosoEntities context object named context1.
2.Loads a Part object into a variable named part1.
3.Calls the Dispose() method on context1.
4.Updates the data in part1.
5.Updates the database by using a new ContosoEntities context object named context2.
You need to update the database with the changed data from part1. What should you do?

A. Add the following code segment before calling SaveChanges() on context2:
context2.Attach(part1);
context2.ApplyCurrentValues("Parts", part1);

B. Add the following code segment before calling SaveChanges() on context2:
context2.ApplyOriginalValues("Parts", part1);

C. Add the following code segment before calling SaveChanges() on context2:
context2.ApplyCurrentValues("Parts", part1);

D. Add the following code segment before calling SaveChanges() on context2:
context2.Attach(part1);
context2.ObjectStateManager.ChangeObjectState(part1,
System.Data.EntitySate.Modified);

Correct Answer: D

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

Question 4

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.
The application uses the following object query to load a product from the database.
(Line numbers are included for reference only.)
01 using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities
())
02 {
03 ObjectQuery <Product> productQuery = advWorksContext.Product.Where
("it.ProductID = 900");
04 ...
05 }
You need to log the command that the query executes against the data source. Which code segment should you insert at line 04?

A. Trace.WriteLine(((IQueryable)productQuery).Expression);

B. Trace.WriteLine(productQuery.CommandText);

C. Trace.WriteLine(productQuery.ToString());

D. Trace.WriteLine(productQuery.ToTraceString());

Correct Answer: D

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

Question 5

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 retrieve an entity from an object context.
A different application updates the database. You need to update the entity instance to reflect updated
values in the database.
Which line of code should you use?

A. context.LoadProperty(entity, "Server", MergeOption.OverwriteChanges);

B. context.AcceptAllChanges();

C. context.Refresh(RefreshMode.StoreWins, entity);

D. context.LoadProperty(entity, "Client", MergeOption.OverwriteChanges);

Correct Answer: C

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

Question 6

You are developing a new feature in the application to display a list of all bundled products.
You need to write a LINQ query that will return a list of all bundled products. Which query expression should
you use?

A. context.Parts.OfType<Product>() .ToList() .Where(p => p.Descendants.Any(d => d is Product))

B. context.Parts.OfType<Product>() .Where(p => p.Descendants.Any(d => d is Product))

C. context.Parts.Cast<Product>() .ToList() .Where(p => p.Descendants.Any(d => d is Product))

D. context.Parts.Cast<Product>() .Where(p => p.Descendants.Any(d => d is Product))

Correct Answer: A

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

Question 7

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 = new ObjectParameter("ID", typeof(int));
context.InsertDepartment("Department 1", id);
Console.WriteLine(id.Value);
}

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 = context.InsertDepartment("Department 1", null);
Console.WriteLine(id);
}

Correct Answer: A

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

Question 8

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 create classes by using LINQ to SQL based on the records shown in the exhibit:

You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID
properties.
You need to retrieve the total price amount of each Order record. What are two possible ways to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

A. from details in dataContext.Order_Detail group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID select new {
OrderID = order.OrderID,
CustomerID = order.CustomerID,
TotalAmount = g.Sum(od => od.UnitPrice * od.Quantity)
}

B. dataContext.Order_Detail.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID,
(dts, ord) => new {
OrderID = dts.OrderID,
CustomerID = dts.Order.CustomerID,
TotalAmount = dts.UnitPrice * dts.Quantity
})

C. from order in dataContext.Orders group order by order.OrderID into g join details in dataContext.Order_Detail on g.Key equals details.OrderID
select new
{
OrderID = details.OrderID,
CustomerID = details.Order.CustomerID,
TotalAmount = details.UnitPrice * details.Quantity
}

D. dataContext.Orders.GroupJoin(dataContext.Order_Detail, o => o.OrderID, d => d.OrderID,
(ord, dts) => new {
OrderID = ord.OrderID,
CustomerID = ord.CustomerID,
TotalAmount = dts.Sum(od => od.UnitPrice *
od.Quantity)
})

Correct Answer: A,D

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

Question 9

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model entities. The application connects to a Microsoft SQL
Server database named AdventureWorks.
The application includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities context = new AdventureWorksEntities())
02 {
03 ObjectQuery <SalesOrderHeader> orders = context.SalesOrderHeader.
Where("it.CreditCardApprovalCode IS NULL").Top("100"); 04 foreach (SalesOrderHeader order in orders){ 05 order.Status = 4; 06 } 07 try{ 08 context.SaveChanges(); 09 } 10 catch (OptimisticConcurrencyException){ 11 ... 12 } 13 }
You need to resolve any concurrency conflict that can occur. You also need to ensure that local changes
are persisted to the database.
Which code segment should you insert at line 11?

A. context.Refresh(RefreshMode.ClientWins, orders); context.SaveChanges();

B. context.Refresh(RefreshMode.StoreWins, orders); context.AcceptAllChanges();

C. context.Refresh(RefreshMode.StoreWins, orders); context.SaveChanges();

D. context.Refresh(RefreshMode.ClientWins, orders); context.AcceptAllChanges();

Correct Answer: A

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

Question 10

The database contains orphaned Color records that are no longer connected to Part records.
You need to clean up the orphaned records. You have an existing ContosoEntities context object named
context.
Which code segment should you use?

A. context.Colors.TakeWhile(c => !c.Parts.Any()); context.SaveChanges();

B. var unusedColors = context.Colors.Where(c => !c.Parts.Any()); context.DeleteObject(unusedColors); context.SaveChanges();

C. var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){
context.DeleteObject(unused)
}
context.SaveChanges();

D. context.Colors.ToList().RemoveAll(c => !c.Parts.Any()); context.SaveChanges();

Correct Answer: C

Question 11

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.
The application allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
-Changes made to the local data store in disconnected mode are preserved.
-Entities that have already been loaded into the local data store, but have not been modified by the user,
are updated with the latest data. What should you do?

A. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins option.

B. Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.

C. Call the query's Execute method by using the MergeOptions.AppendOnly option.

D. Call the query's Execute method by using the MergeOptions.OverwriteChanges option.

Correct Answer: A

Question 12

The database contains a table named Categories. The Categories table has a primary key identity column
named CategoryID.
The application inserts new records by using the following stored procedure.
CREATE PROCEDURE dbo.InsertCategory @CategoryName nvarchar(15), @Identity int OUT
AS INSERT INTO Categories (CategoryName) VALUES(@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You write the following code segment.
SqlDataAdapter adapter = new SqlDataAdapter("SELECT categoryID, CategoryName
FROM dbo.Categories",connection);
adapter.InsertCommand = new SqlCommand("dbo.InsertCategory", connection);
adapter.InsertCommand.CommandType = commandType.StoredProcedure;
adapter.InsertCommand.Parameters.Add(new SqlParameter("@CategoryName",
SqlDbType.NVarChar, 15,"CategoryName"));
You need to retrieve the identity value for the newly created record. Which code segment should you add?

A. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int);
parameter.Direction = ParameterDirection.Output;
parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID");
parameter.Direction = ParameterDirection.ReturnValue;

B. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;

C. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;

D. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.ReturnValue; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;

Correct Answer: D

Welcome to TestSimulate

Microsoft TS: Accessing Data with Microsoft .NET Framework 4 (070-516) Free Practice Test