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

1. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create an Entity Data Model (EDM) by using the Microsoft ADO.NET Entity Data Model Designer (Entity
Designer).
The EDM contains a complex type. You need to map a stored procedure to the complex type by using the
Entity Designer.
What should you do?

A) Add a code generation item that has the name of the stored procedure.
B) Add an association to the stored procedure.
C) Add a function import for the stored procedure.
D) Add an entity that mirrors the properties of the complex type.

2. 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) 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.
C) Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.
D) Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.

3. 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 a DataTable named OrderDetailTable that has the following columns:
-ID
-OrderID
-ProductID
-Quantity
-LineTotal
Some records contain a null value in the LineTotal field and 0 in the Quantity field. You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn column = new DataColumn("UnitPrice", typeof(double));
02 ...
03 OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object.
You also need to ensure that UnitPrice is set to 0 when it cannot be calculated.
Which code segment should you insert at line 02?

A) column.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";
B) column.Expression = "LineTotal/Quantity";
C) column.Expression = "LineTotal/ISNULL(Quantity, 1)";
D) column.Expression = "if(Quantity > 0, LineTotal/Quantity, 0)";

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
You create an Entity Data Model (EDM) named Model. You need to ensure that the Storage Schema
Definition Language (SSDL)
of the EDM can be modified without rebuilding the application. What should you do?

A) Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string ="& "
B) Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string="& "
C) Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string="& "
D) Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string ="& "

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. You deploy an application to a
production server.
The application uses the model and mapping files that are deployed as application resources.
You need to update the conceptual model for the application on the production server. What should you do?

A) Copy the updated .edmx file to the production server.
B) Copy the updated .csdl file to the production server.
C) Recompile the application and redeploy the modified assembly file.
D) Copy the updated .ssdl file to the production server.

Solutions: