Online Access Free 070-516 Practice Test

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 manage customer and related order records.
You add a new order for an existing customer. You need to associate the Order entity with the Customer
entity.
What should you do?

• A.Set the Value property of the EntityReference of the Order entity.
• B.Call the Add method on the EntityCollection of the Order entity.
• C.Use the AddObject method of the ObjectContext to add both Order and Customer entities.
• D.Use the Attach method of the ObjectContext to add both Order and Customer entities.

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
200B database.
You populate a SqlDataAdapter by using the following code. (Line numbers are included for reference only.)
01 SqlDataAdapter dataAdapter1 = new SqlDataAdapter("SELECT * FROM
[BlogEntries] ORDER BY CreationDate", connection);
02 cmdBuilder = new SqlCommandBuilder(dataAdapter1);
03 dataAdapter1.Fill(BlogEntryDataSet, "BlogEntries");
04 ....
05 connection.Close();
You need to update the blog owner for all BlogEntry records. Which code segment should you insert at line 04?

• A.foreach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows) {
  row.Item["BlogOwner""] = "New Owner";
  }
  dataAdapter1.Fill(BlogEntryDataSet, "BlogEntries");
• B.SqlDataAdapter dataAdapter2 = new SqlDataAdapter("UPDATE [BlogEntries] SET [BlogOwner] = "New
  'Owner' 3", connection);
  dataAdapter2.Update(BlogEntryDataSet, "BlogEntries");
• C.foreach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows) {
  row.Item["BlogOwner""] = "New Owner";
  }
  dataAdapter1.Update(BlogEntryDataSet, "BlogEntries");
• D.SqlDataAdapter dataAdapter2 = new SqlDataAdapter(dataAdapterl.UpdateCommand); dataAdapter2.Fill(BlogEntryDataSet, "BlogEntries");

You add a table to the database to track changes to part names. The table stores the following row values:
-the username of the user who made the change
-a part ID
-the new part name
-a DateTime value
You need to ensure detection of unauthorized changes to the row values.
You also need to ensure that database users can view the original row values.

• A.Add a column named signature. Use System.Security.Cryptography.RSA to create a signature for all of the row values. Store the signature in the signature column. Publish only the public key internally.
• B.Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.
• C.Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.
• D.Add a column named hash. Use System.Security.Cryptography.MD5 to create an MD5 hash of the row values, and store in the hash column.

You use Microsoft .NET Framework 4.0 to develop an application that exposes a WCF Data Services
endpoint.
The endpoint uses an authentication scheme that requires an HTTP request that has the following header
format.
GET /OData.svc/Products(1)
Authorization: WRAP access_token "123456789"
You add the following method to your DataService implementation.
01 protected override void OnStartProcessingRequest(ProcessRequestArgs args)
02 {
03 ....
04 }
You need to ensure that the method retrieves the authentication token. Which line of code should you use?

• A.string token = args.OperationContext.ResponseHeaders["WRAP access_token"];
• B.string token = args.OperationContext.RequestHeaders["WRAP access_token"];
• C.string token = args.OperationContext.ResponseHeaders["Authorization"];
• D.string token = args.OperationContext.RequestHeaders["Authorization"];

You are adding a process to the application. The process performs the following actions:
1.Opens a ContosoEntities context object named context1.
2.Loads a Part object into a variable named part1.
3.Calls the Dispose() method on context1.
4.Updates the data in part1.
5.Updates the database by using a new ContosoEntities context object named context2.
You need to update the database with the changed data from part1. What should you do?

• A.Add the following code segment before calling SaveChanges() on context2:
  context2.Attach(part1);
  context2.ObjectStateManager.ChangeObjectState(part1,
  System.Data.EntitySate.Modified);
• B.Add the following code segment before calling SaveChanges() on context2:
  context2.ApplyCurrentValues("Parts", part1);
• C.Add the following code segment before calling SaveChanges() on context2:
  context2.Attach(part1);
  context2.ApplyCurrentValues("Parts", part1);
• D.Add the following code segment before calling SaveChanges() on context2:
  context2.ApplyOriginalValues("Parts", part1);