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

1. Which method will return all nodes of an XDocument?

A) doc.DescendantNodes();
B) doc.GetAllnodes();
C) doc.Root.Allnodes();
D) doc.Descendants();

2. You use Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that connects to a
Microsoft SQL Server 2008 database.
The application uses Integrated Windows authentication in Internet Information Services (IIS) to
authenticate users.
A connection string named connString defines a connection to the database by using integrated security.
You need to ensure that a SqlCommand executes under the application pool's identity on the database
server.
Which code segment should you use?

A) using (var conn = new SqlConnection(connString))
{
var cmd = new SqlCommand ("SELECT * FROM BLOG, conn);
conn.Open();
using(HostingEnvironment.Impersonate())
{
var result = cmd.ExecuteScalar();
}
}
B) using (var conn = new SqlConneccion())
{
using (HostingEnvironroent.Impersonate())
{
conn.ConnectionString = connString;
}
var cmd = new SqlCommand("SELECT * FROM BLOG, conn);
conn.Open() ;
var result = cmd.ExecuteScalar();
}
C) using (var conn = new SqlConnection())
{
conn.ConnectionString = connString;
var cmd = new SqlCommand("SELECT * FROM BLOG", conn);
using (HostingEnvironment.Impersonate())
{
conn.Open();
}
var result = cmd.ExecuteScalar();
}
D) using (var conn = new SqlConnection())
{
conn.ConnectionString = connString;
SqlCommand cmd = null;
using (HostingEnvironment.Impersonate())
{
cmd = new SqlCommand("SELECT * FROM BLOG", conn);
}
conn.Open();
var result = cmd.ExecuteScalar();
}

3. 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).OrderByDescending(soh => soh.OrderDate);
B) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.OrderBy(soh => soh.OrderDate).Take(10);
C) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.Take(10).OrderBy(soh => soh.OrderDate);
D) var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.OrderByDescending(soh => soh.OrderDate).Take(10);

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 2008 database. You add the following store procedure
to the database.
CREATE PROCEDURE GetSalesPeople AS BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone FROM SalesPeople END
You write the following code segment. (Line numbers are included for reference only.)
01 SqlConnection connection = new SqlConnection("...");
02 SqlCommand command = new SqlCommand("GetSalesPeople", connection);
03 command.CommandType = CommandType.StoredProcedure;
04 ...
You need to retreive all of the results from the stored procedure. Which code segment should you insert at line 04?

A) var res = command.ExecuteReader();
B) var res = command.ExecuteScalar();
C) var res = command.ExecuteNonQuery();
D) var res = command.ExecuteXmlReader();

5. 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.
You need to ensure that the model and mapping files are not deployed as application resources. What
should you do?

A) Set the value of the .edmx file's Metadata Artifact Processing property to Copy to Output Directory.
B) Set the value of the .edmx file's Build Action property to Copy to Output.
C) Modify the connection string in the application's .config file to refer to the relative path to the .edmx file.
D) Modify the connection string in the application's .config file to refer to the absolute physical path to the .edmx file.

Solutions: