Microsoft TS: Accessing Data with Microsoft .NET Framework 4 - 070-516 Exam Practice Test

You use Microsoft .NET Framework 4 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].[InsertTag] @Name nvarchar (15)
AS INSERT INTO [dbo].[Tags] (Name) VALUES(@Name) RETURN @@ROWCOUNT
You need to invoke the stored procedure by using an open SqlConnection named conn. Which code segment should you use?

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 create an entity as shown in
the following code fragment.
<EntityType Name="ProductCategory">
<Key>
<PropertyRef Name="ProductCategoryID" />
</Key>
<Property Name="ProductCategoryID" Type="int" Nullable="false" StoreGeneraedPattern="Identity" />
<Property Name="ParentProductCategoryID" Type="int" />
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
...
</EntityType>
You need to provide two entity-tracking fields:
-rowguid that is automatically generated when the entity is created
-ModifiedDate that is automatically set whenever the entity is updated. Which code fragment should you add to the .edmx file?

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

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?

You are a tasked with performing a code review. The business rule is the following:
-If INSERTs into the first table succeed, then INSERT into the second table.
-However, if the INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

The Entity Data Model file (.edmx file) must be updated to support inheritance mapping for Products and Componets.
You need to add the following code to the \Model\Model.edmx file:
-the code in line EX243 that maps the Product type
-the code in line EX250 that maps the Component type
What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Plain Old CLR objects (POCO) to model your entities.
The application communicates with a Windows Communication Foundation (WCF) Data Services service.
You need to ensure that entities can be sent to the service as XML. What should you do?

The application user interface displays part names or color names in many plases as '## Name ##'.
You need to provide a method named FormattedName() to format part names and color names throughout
the
application. What should you do?

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.

You use Microsoft .NET Framework 4.0 to develop an application that uses WCF Data Services to persist entities from the following Entity Data Model.

You create a new Blog instance named newBlog and a new Post instance named newPost as shown in the
following code segment.
(Line numbers are included for reference only.)
01 Blog newBlog = new Blog();
02 Post newPost = new Post();
03 ....
04 Uri serviceUri = new Uri("...");
05 BlogsEntities context = new BlogsEntities(serviceUri);
06 ....
You need to ensure that newPost is related to newBlog through the Posts collection property and that
newPost and newBlog are sent to the service.
Which code segment should you insert at line 06?