Microsoft TS: Accessing Data with Microsoft .NET Framework 4 認定 70-516 試験問題:

1. 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. The application includes a SqlConnection named
conn and a SqlCommand named cmd.
You need to create a transaction so that database changes will be reverted in the event that an exception is
thrown.
Which code segment should you use?

A) var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
...
}
catch
{
transaction.Commit();
}
B) var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
...
transaction.Commit();
}
catch
{
transaction.Dispose();
}
C) var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
...
transaction.Commit();
}
catch
{
transaction.Rollback();
}
D) var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
...
transaction.Rollback();
}
catch
{
transaction.Dispose();
}

2. You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

A) SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;
B) SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;
C) SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;
D) SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;

3. 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) MERGE /Northwind.svc/Customers(123) Host: contoso.com
Content-Type: application/json { City: 'Seattle' }
B) PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }
C) MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }
D) PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
The application has an entity model that contains a SalesOrderHeader entity. The entity includes an
OrderDate property of type DateTime.
You need to retrieve the 10 oldest SalesOrderHeaders according to the OrderDate property.
Which code segment should you use?

A) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.Take(10).OrderBy(soh => soh.OrderDate);
B) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.Take(10).OrderByDescending(soh => soh.OrderDate);
C) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.OrderBy(soh => soh.OrderDate).Take(10);
D) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.OrderByDescending(soh => soh.OrderDate).Take(10);

5. How do you call a model-defined function as static method on a custom class?

A) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts an IQueryable argument and returns the results of the Execute method that is returned by the Provider property.
B) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts and returns the results of the Execute method that is returned by the Provider property.
C) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts ICollection argument and returns the results of the Execute method that is returned by the Provider property.
D) Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts IEntityWithRelationships argument and returns the results of the Execute method that is returned by the Provider property.

質問と回答：