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.
The application uses the ADO.NET Entity Framework to manage Plain Old CLR Objects (POCO) entities.
You create a new POCO class. You need to ensure that the class meets the following requirements:
-It can be used by an ObjectContext.
-It is enabled for change-tracking proxies.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Modify each mapped property to contain non-sealed, public, and virtual accessors.
B) Modify each mapped property to contain sealed and protected accessors.
C) Configure the navigation property to return a type that implements the IEntityWithRelationships interface.
D) Configure the navigation property to return a type that implements the ICollection interface.
E) Configure the navigation property to return a type that implements the IQueryable interface.

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application retreives data from Microsoft SQL Server 2008 database named AdventureWorks. The AdventureWorks.dbo.ProductDetails table contains a column names ProductImages that uses a varbinary(max) data type.
You write the following code segment. (Line numbers are included for reference only.)
01 SqlDataReader reader = command.ExecureReader(--empty phrase here --);
02 while(reader.Read())
03 {
04 pubID = reader.GetString(0);
05 stream = new FileStream(...);
06 writer = new BinaryWriter(stream);
07 startIndex = 0;
08 retval = reader.GetBytes(1, startIndex, outByte, 0, bufferSize);
09 while(retval == bufferSize)
10 {
11 ...
12 }
13 writer.Write(outbyte, 0, (int)retval-1);
14 writer.Flush();
15 writer.Close();
16 stream.Close();
17 }
You need to ensure that the code supports streaming data from the ProductImages column. Which code segment should you insert at the empty phrase in line 01?

A) CommandBehavior.KeyInfo
B) CommandBehavior.SingleResult
C) CommandBehavior.Default
D) CommandBehavior.SequentialAccess

3. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects
to a Microsoft SQL Server 2008 database. The application performs a database query within a transaction.
You need to ensure that the application can read data that has not yet beed commited by other
transactions.
Which IsolationLevel should you use?

A) ReadUncommitted
B) ReadCommitted
C) Unspecified
D) RepeatableRead

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
You plan to deploy the application to several shared client computers. You write the following code
segment.
(Line numbers are included for reference only.)
01 Configuration config = ConfigurationManager.OpenExeConfiguration
(exeConfigName);
02 ...
03 config.Save();
04 ...
You need to encrypt the connection string stored in the .config file. Which code segment should you insert at line 02?

A) ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
B) ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
C) ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
D) ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");

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

Solutions: