Microsoft 70-516 valid study dumps : TS: Accessing Data with Microsoft .NET Framework 4

You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses
Integrated Windows authentication.
The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server
as the application.
You use the following connection string to connect to the database.
Integrated Security=SSPI; Initial Catalog=AdventureWorks;
The application must also execute a stored procedure on the same server on a database named pubs.
Users connect to the ASP.NET application through the intranet by using Windows-based authentication.
You need to ensure that the application will use connection pooling whenever possible and will keep the
number of pools to a minimum.
Which code segment should you use?

• A. command.CommandText = "exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=pubs")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• B. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=AdventureWorks")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• C. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• D. command.CommandText = "exec uspLoginAudit;";
  using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI;")) {
  connection.Open();
  command.ExecuteNonQuery();
  }

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the ADO.NET Entity Framework Designer to model entities as shown in the following diagram.

You create an ObjectContext instance named objectContext1 and use it to create a SalesPerson instance
named person1.
You create an ObjectContext instance named objectContext2 and use it to create a SalesTerritory instance
named territory1.
You need to create and persist a relationship between person1 and terrotory1. What should you do?

• A. Attach person1 to objectContext2. Attach territory1 to objectContext1. Set the SalesTerritory property of person1 to territory1. Call SaveChanges on both objectContext1 and objectContext2.
• B. Detach person1 from objectContext1. Attach person1 to objectContext2. Set the SalesTerritory property of person1 to territory1. Call SaveChanges on objectContext2.
• C. Attach person1 to objectContext2. Detach territory1 from objectContext2. Set the SalesTerritory property of person1 to territory1. Call Refresh on objectContext1.
• D. Detach person1 from objectContext1. Detach territory1 from objectContext2. Set the SalesTerritory property of person1 to territory1. Call Refresh on both objectContext1 and objectContext2.

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:
  ctx.LoadProperty(category, "Products");
• B. 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);
• C. Add the following code segment at line 08:
  ctx.LoadProperty(product, "*");
• D. 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);

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You add the following stored procedure to the database.
CREATE PROCEDURE dbo.GetClassAndStudents AS BEGIN
SELECT * FROM dbo.Class
SELECT * FROM dbo.Student
END
You create a SqIConnection named conn that connects to the database.
You need to fill a DataSet from the result that is returned by the stored procedure.
The first result set must be added to a DataTable named Class, and the second result set must be added to
a DataTable named Student.
Which code segment should you use?

• A. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);
• B. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.TableMappings.Add("Table", "Class"); ad.TableMappings.Add("Table1", "Student") ; ad.Fill(ds) ;
• C. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.Fill(ds);
• D. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

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 uses the following object query to load a product from the database.
(Line numbers are included for reference only.)
01 using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities
())
02 {
03 ObjectQuery <Product> productQuery = advWorksContext.Product.Where
("it.ProductID = 900");
04 ...
05 }
You need to log the command that the query executes against the data source. Which code segment should you insert at line 04?

• A. Trace.WriteLine(productQuery.CommandText);
• B. Trace.WriteLine(((IQueryable)productQuery).Expression);
• C. Trace.WriteLine(productQuery.ToTraceString());
• D. Trace.WriteLine(productQuery.ToString());

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).