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

1. 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 has two DataTable objects that reference the Customers and Orders tables in the
database.
The application contains the following code segment. (Line numbers are included for reference only.)
01 DataSet customerOrders = new DataSet();
02 customerOrders.EnforceConstraints = true;
03 ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04 customerOrders.Tables
["Customers"].Columns["CustomerID"],
05 customerOrders.Tables["Orders"].Columns
["CustomerID"]);
06 ...
07 customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have
related Order records.
Which code segment should you insert at line 06?

A) ordersFK.DeleteRule = Rule.Cascade;
B) ordersFK.DeleteRule = Rule.None;
C) ordersFK.DeleteRule = Rule.SetDefault;
D) ordersFK.DeleteRule = Rule.SetNull;

2. 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 use the ADO.NET Entity Framework to model your entities. You use ADO.NET self-tracking entities.
You need to ensure that the change-tracking information for the self-tracking entities can be used to update
the database.
Which ObjectContext method should you call after changes are made to the entities?

A) Refresh
B) ApplyChanges
C) Attach
D) SaveChanges

3. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions
can be recovered.
What should you do?

A) Call the Reenlist method of the TransactionManager class.
B) Call the EnlistDurable method of the Transaction class.
C) Call the RecoveryComplete method of the TransactionManager class.
D) Call the EnlistVolatile method of the Transaction class.

4. 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.AcceptAllChanges();
B) context.Refresh(RefreshMode.ClientWins, orders); context.SaveChanges();
C) context.Refresh(RefreshMode.StoreWins, orders); context.SaveChanges();
D) context.Refresh(RefreshMode.StoreWins, orders); context.AcceptAllChanges();

5. 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 SqlConnection())
{
conn.ConnectionString = connString;
SqlCommand cmd = null;
using (HostingEnvironment.Impersonate())
{
cmd = new SqlCommand("SELECT * FROM BLOG", conn);
}
conn.Open();
var result = cmd.ExecuteScalar();
}
C) 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();
}
D) 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();
}

Solutions: