Instant Access Microsoft 070-516 Exam Premium Dumps - FreeCram

Every candidate studies differently, so FreeCram ships the 070-516 practice questions in three formats: a printable PDF, a Desktop Test Engine for Windows, and an Online Test Engine that runs in any browser. However you prefer to prepare for Microsoft TS: Accessing Data with Microsoft .NET Framework 4, there is a version that fits.

Microsoft 070-516 Exam Overview:

Microsoft 070-516 Exam Syllabus Topics:

Microsoft 070-516 Exam: Frequently Asked Questions

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

Question 1

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the Entity Data Model for the fallowing database tables.

You need to ensure that the entity that is mapped to the ContectTypeDerived table derives from the entity that is mapped to the ContentTypeBase table. What should you do?

A. Create a complect type for each entity.
B. Use a Table-Per-Hierarchy mapping method.
C. Create a function import for each entity.
D. Use a Table-Per-Type mapping method.

Question 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 add the following code segment. (Line numbers are included for reference only.)
01 var uri = new Uri(@"http://contoso.com/Northwind.svc/");
02 var ctx = new NorthwindEntities(uri);
03 var categories = from c in ctx.Categories select c;
04 foreach (var category in categories) {
05 PrintCategory(category);
06 ...
07 foreach (var product in category.Products) {
08 ...
09 PrintProduct(product);
10 }
11 }
You need to ensure that the Product data for each Category object is lazy-loaded. What should you do?

A. Add the following code segment at line 06:
var strPrdUri = string.Format("Categories({0})?$expand=Products",
category.CategoryID);
var productUri = new Uri(strPrdUri, UriKind.Relative);
ctx.Execute<Product>(productUri);
B. Add the following code segment at line 06:
ctx.LoadProperty(category, "Products");
C. Add the following code segment at line 08:
var strprdUri= string.format("Products?$filter=CategoryID eq {0}",
category.CategoryID);
var prodcutUri = new Uri(strPrd, UriKind.Relative);
ctx.Execute<Product>(productUri);
D. Add the following code segment at line 08:
ctx.LoadProperty(product, "*");

Question 3

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
Entity types in the model are generated by the Entity Data Model generator tool (EdmGen.exe).
You write the following code. (Line numbers are included for reference only.)
01 MemoryStream stream = new MemoryStream();
02 var query = context.Contacts.Include("SalesOrderHeaders.SalesOrderDetails");
03 var contact = query.Where("it.LastName = @lastname", new ObjectParameter
("lastname", lastName)).First();
04 ....
You need to serialize the contact and all of its related objects to the MemoryStream so that the contact can
be deserialized back into the model.
Which code segment should you insert at line 04?

A. var formatter = new SoapFormatter(); formatter.Serialize(stream, contact);
B. var formatter = new BinaryFormatter(); formatter.Serialize(stream, contact);
C. var formatter = new XmlSerializer(typeof(Contact)); formatter.Serialize(stream, contact);
D. var formatter = new XmlSerializer(typeof(Contact), new Type[] { typeof(SalesOrderHeader), typeof(SalesOrderDetail)
});
formatter.Serialize(stream, contact);

Question 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 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]; 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 - 1]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();

Question 5

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.None;
B. ordersFK.DeleteRule = Rule.SetNull;
C. ordersFK.DeleteRule = Rule.SetDefault;
D. ordersFK.DeleteRule = Rule.Cascade;

Solutions: