TS: Accessing Data with Microsoft .NET Framework 4: 070-516 Exam Premium File as PDF & Test Engine

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service
on
the production server, attempting to update or delete an entity results in an error.
You need to ensure that you can update and delete entities on the production server. What should you do?

• A. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);
• B. Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.
• C. Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.
• D. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);

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. Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.
• B. Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.
• C. 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.
• 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 Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The database includes a table named
dbo.Documents
that contains a column with large binary data. You are creating the Data Access Layer (DAL).
You add the following code segment to query the dbo.Documents table. (Line numbers are included for
reference only.)
01 public void LoadDocuments(DbConnection cnx)
02 {
03 var cmd = cnx.CreateCommand();
04 cmd.CommandText = "SELECT * FROM dbo.Documents";
05 ...
06 cnx.Open();
07 ...
08 ReadDocument(reader);
09 }
You need to ensure that data can be read as a stream. Which code segment should you insert at line 07?

• A. var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo);
• B. var reader = cmd.ExecuteReader(CommandBehavior.Default);
• C. var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
• D. var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

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. The database includes a table that
contains information about all the employees.
The database table has a field named EmployeeType that identifies whether an employee is a Contractor or
a Permanent employee.
You declare the Employee entity base type. You create a new Association entity named Contractor that
inherits the Employee base type.
You need to ensure that all Contractors are bound to the Contractor class. What should you do?

• A. Modify the .edmx file to include the following line of code: <Condition ColumnName="EmployeeType" Value="Contractor" />
• B. Modify the .edmx file to include the following line of code: <NavigationProperty Name="Type" FromRole="EmployeeType" ToRole="Contractor" />
• C. Use the Entity Data Model Designer to set up an association between the Contractor class and EmployeeType.
• D. Use the Entity Data Model Designer to set up a referential constraint between the primary key of the Contractor class and EmployeeType.