The Microsoft TS: Accessing Data with Microsoft .NET Framework 4 exam has a reputation for tripping up even experienced candidates. Working through 196 realistic practice questions from ActualCollection exposes your weak spots before exam day does.

Microsoft 070-516 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	TS: Accessing Data with Microsoft .NET Framework 4
Exam Number:	70-516
Exam Price:	$165 USD (varies by region)
Available Languages:	English, Chinese (Simplified), German, Korean, Japanese, French
Real Exam Qty:	40-60
Exam Format:	Multiple choice, Scenario-based questions, Case studies
Related Certifications:	Microsoft Certified Technology Specialist (MCTS): .NET Framework 4 Data Access
Certificate Validity Period:	Retired
Exam Duration:	120-150
Passing Score:	700 (on a 1000 scale)
Sample Questions:
Exam Way:	Online proctored or test center delivery (historical Microsoft certification format)
Pre Condition:	Recommended experience with C# and Microsoft .NET Framework 4 data access technologies including ADO.NET and Entity Framework

Microsoft 070-516 Exam Syllabus Topics:

Answers Every 070-516 Candidate Should Read First

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

Question 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. You load records from the Customers table
into a DataSet object named dataset.
You need to retrieve the value of the City field from the first and last records in the Customers table.
Which code segment should you use?

A. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count - 1]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
B. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count - 1]["City"].ToString();
C. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count]["City"].ToString();
D. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();

Question 2

A performance issue exists in the application. The following code segment is causing a performance bottleneck:
var colors = context.Parts.GetColors();
You need to improve application performance by reducing the number of database calls. Which code segment should you use?

A. var colors = context.Parts.OfType<Product>().Include ("Parts.Color").GetColors();
B. var colors = context.Parts.OfType<Product>().Include("Color").GetColors();
C. var colors = context.Parts.OfType<Product>().Include("Colors").GetColors();
D. var colors = context.Parts.OfType<Product>().Include ("Product.Color").GetColors();

Question 3

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses LINQ to SQL.
The application contains the following model. You write the following code. (Line numbers are included for
reference only.)
01 static void Insert()
02 {
03 NorthwindDataContext dc = new NorthwindDataContext();
04 Customer newCustomer = new Customer();
05 newCustomer.Firstname = "Todd";
06 newCustomer.Lastname = "Meadows";
07 newCustomer.Email = "[email protected]";
08 .....
09 dc.SubmitChanges();
10 }

A product named Bike Tire exists in the Products table. The new customer orders the Bike Tire product.
You need to ensure that the correct product is added to the order and that the order is associated with the
new customer.
Which code segment should you insert at line 08?

A. Product newProduct = new Product(); newProduct.ProductName = "Bike Tire"; Order newOrder = new Order (); newOrder.Product = newProduct; newCustomer.Orders.Add(newOrder) ;
B. Product newProduct = new Product(); newProduct.ProductName = "Bike Tire"; Order newOrder = new Order(); newOrder.Product = newProduct;
C. Order newOrder = new Order();
newOrder.Product = (from p in dc.Products
where p.ProductName == "Bike Tire"
select p) .First();
D. Order newOrder = new Order();
newOrder.Product = (from p in dc.Products
where p.ProductName == "Bike Tire"
select p).First();
newCustomer.Orders.Add(newOrder) ;

Question 4

You use Microsoft .NET Framework 4.0 to develop an application that connects to a local Microsoft SQL
Server 2008 database.
The application can access a high-resolution timer. You need to display the elapsed time, in sub-
milliseconds (<1 millisecond),
that a database query takes to execute. Which code segment should you use?

A. DateTime Start = DateTime.UtcNow; command.ExecuteNonQuery(); TimeSpan Elapsed = DateTime.UtcNow - Start; Console.WriteLine("Time Elapsed: {0:N} ms", Elapsed.Milliseconds);
B. Stopwatch sw = Stopwatch.StartNew(); command.ExecuteNonQuery() ; sw.Stop() ; Console.WriteLine("Time Elapsed: {0:N} ms", sw.Elapsed.TotalMilliseconds);
C. Stopwatch sw = new Stopwatch(); sw.Start() ; command.ExecuteNonQuery(); sw.Stop(); Console.WriteLine("Time Elapsed: {0:N} ms", sw.Elapsed.Milliseconds);
D. int Start = Environment.TickCount; command.ExecuteNonQuery(); int Elapsed = (Environment.TickCount) - Start; Console.WriteLine("Time Elapsed: {0:N} ms", Elapsed);

Question 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. The model includes the entity
shown in the following exhibit:

You need to add a function that returns the number of years since a person was hired.
You also need to ensure that the function can be used within LINQ to Entities queries. What should you do?

A. //Add the following conceptual model function returns the number of years since an instructor was hired
<Function Name="YearsSince" ReturnType="Edm.Int32">
<Parameter Name="date" Type="Edm.DateTime" />
<DefiningExpression>
YearsSince(DateTime date)
</DefiningExpression>
</Function>
// add the following method to your application and use an EdmFunctionAttribute to map it to the
conceptual model function:
[EdmFunction("SchoolModel", "YearsSince")]
public static int YearsSince(DateTime date){
return CurrentDateTime() -Year(date);
}
B. //Add the following conceptual model function returns the number of years since an instructor was hired
<Function Name="YearsSince" ReturnType="Edm.Int32">
<Parameter Name="date" Type="Edm.DateTime" />
<DefiningExpression>
Year(CurrentDateTime()) -Year(date)
</DefiningExpression>
</Function>
// add the following method to your application and use an EdmFunctionAttribute to map it to the
conceptual model function:
[EdmFunction("SchoolModel", "YearsSince")]
public static int YearsSince(DateTime date){
return CurrentDateTime() -Year(date);
}
C. Use the Entity Data Model Designer to create a complex property named YearsSinceNow that can be accessed throuqh the LINQ to Entites query at a Later time
D. //Add the following conceptual model function returns the number of years since an instructor was hired
<Function Name="YearsSince" ReturnType="Edm.Int32">
<Parameter Name="date" Type="Edm.DateTime" />
<DefiningExpression>
Year(CurrentDateTime()) -Year(date)
</DefiningExpression>
</Function>
// add the following method to your application and use an EdmFunctionAttribute to map it to the
conceptual model function:
[EdmFunction("SchoolModel", "YearsSince")] public static int YearsSince(DateTime date){ throw new NotSupportedException("Direct calls are not supported."); }

Solutions: