Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

1. You use Microsoft .NET Framework 4.0 to develop an application that connects to two separate Microsoft
SQL Server 2008 databases.
The Customers database stores all the customer information, and the Orders database stores all the order
information.
The application includes the following code. (Line numbers are included for reference only.)
01 try
02 {
03 conn.Open();
04 tran = conn.BeginTransaction("Order");
05 SqlCommand cmd = new SqlCommand();
06 cmd.Connection = conn;
07 cmd.Transaction = tran;
08 tran.Save("save1");
09 cmd.CommandText = "INSERT INTO [Cust].dbo.Customer " + "(Name,
PhoneNumber) VALUES ('Paul Jones', " + "'404-555-1212')";
10 cmd.ExecuteNonQuery();
11 tran.Save("save2");
12 cmd.CommandText = "INSERT INTO [Orders].dbo.Order " + "(CustomerID)
VALUES (1234)";
13 cmd.ExecuteNonQuery();
14 tran.Save("save3");
15 cmd.CommandText = "INSERT INTO [Orders].dbo." + "OrderDetail (OrderlD,
ProductNumber) VALUES" + "(5678, 'DC-6721')";
16 cmd.ExecuteNonQuery();
17 tran.Commit();
18 }
19 catch (Exception ex)
20 {
21 ...
22 }
You run the program, and a timeout expired error occurs at line 16. You need to ensure that the customer
information is saved in the database.
If an error occurs while the order is being saved, you must roll back all of the order information and save the
customer information.
Which line of code should you insert at line 21?

A) tran.Rollback("save2"); tran.Commit();
B) tran.Rollback("save2");
C) tran.Rollback();
D) tran.Rollback(); tran.Commit();

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the data service to the following URL: http://
contoso.com/Northwind.svc.
You need to update the City property of the Customer record that has its ID value as 123.
You also need to preserve the current values of the remaining properties. Which HTTP request should you
use?

A) PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }
B) MERGE /Northwind.svc/Customers(123) Host: contoso.com
Content-Type: application/json { City: 'Seattle' }
C) PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }
D) MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

3. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
You discover that when an application submits a PUT or DELETE request to the Data Services service, it
receives an error.
You need to ensure that the application can access the service. Which header and request type should you
use in the application?

A) an HTTP ContentType header as part of a POST request
B) an X-HTTP-Method header as part of a GET request
C) an HTTP ContentType header as part of a GET request
D) an X-HTTP-Method header as part of a POST request

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses
the Entity Framework.
The application has the entity model shown in the following diagram.

The application must create a projection of the unique set of names and year-to-date sales for territories
where at least one sales person had sales last year of more than $100,000.
The projection must consist of properties named Sales and Name. You need to write a query that will
generate the required projection.
Which code segment should you use?

A) (from person in model.SalesPersons where (person.SalesLastYear > 100000) select new {
Name = person.SalesTerritory.Name,
Sales = person.SalesTerritory.SalesYTD
}
).Distinct();
B) (from person in model.SalesPersons where (person.SalesLastYear > 100000) select new {
Name = person.SalesTerritory.Name,
Sales = person.SalesTerritory.SalesYTD
}
);
C) model.SalesTerritories.Where( t => t.SalesPersons.Any( p => p.SalesLastYear > 100000)) .Select( t=> new { t.Name, t.SalesYTD})
.Distinct();
D) model.SalesTerritories.Where( t=> t.SalesPersons.Any( p => p.SalesLastYear > 100000)) .Select( t=> new { t.Name, Sales = t.SalesYTD});

5. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Data Model (EDM) to define a Customer entity.
You need to add a new Customer to the data store without setting all the customer's properties. What
should you do?

A) Override the Create method for the Customer object.
B) Call the Create method of the Customer object.
C) Override the SaveChanges method for the Customer object.
D) Call the CreateObject method of the Customer object.

Solutions: