The database contains a table named Categories. The Categories table has a primary key identity column
named CategoryID.
The application inserts new records by using the following stored procedure.
CREATE PROCEDURE dbo.InsertCategory @CategoryName nvarchar(15), @Identity int OUT
AS INSERT INTO Categories (CategoryName) VALUES(@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You write the following code segment.
SqlDataAdapter adapter = new SqlDataAdapter("SELECT categoryID, CategoryName
FROM dbo.Categories",connection);
adapter.InsertCommand = new SqlCommand("dbo.InsertCategory", connection);
adapter.InsertCommand.CommandType = commandType.StoredProcedure;
adapter.InsertCommand.Parameters.Add(new SqlParameter("@CategoryName",
SqlDbType.NVarChar, 15,"CategoryName"));
You need to retrieve the identity value for the newly created record. Which code segment should you add?

• A. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.ReturnValue; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
• B. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;
• C. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int);
  parameter.Direction = ParameterDirection.Output;
  parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID");
  parameter.Direction = ParameterDirection.ReturnValue;
• D. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application that
connects to a database by using the Entity Framework.
You create an Entity Data Model (EDM) by using the Generate from database wizard for the following
tables.

You need to ensure that the EDM contains an entity type named Employee that contains all of the data from
both tables.
What should you do?

• A. Modify the .edmx file to include the following line of code. <NavigationProperty Name="Type" FromRole="EmployeeAccess" ToRole="Employee" />
• B. Create an inheritance relationship between the Employee and EmployeeAccess entities, and use CanAccessBuildings as an inheritance condition.
• C. Delete the EmployeeAccess entity, create a new property named CanAccessBuildings on the Employee entity, and add a mapping for the new property.
• D. Create a one-to-one association named CanAccessBuildingsAssociation between the EmployeeAccess entity and the Employee entity.

You are developing a new feature that displays an auto-complete list to users as the type color names. You
have an
existing ContosoEntities context object named contex.
To support the new feature you must develop code that will accept a string object named text containing a
user's
partial input and will query the Colors database table to retrieve all color names that begin with that input.
You need to create an Entity SQL (ESQL) query to meet the requirement.
The query must not be vulnerable to a SQL injection attack. Which code segment should you use?

• A. var parameter = new ObjectParameter("text", text + "%"); var result = context.CreateQuery<string>(
  "SELECT VALUE (c.Name) FROM Colors AS c WHERE c.Name LIKE '@text'", parameter);
• B. var parameter = new ObjectParameter("text", text + "%");
  var result = context.CreateQuery<string>( "SELECT (c.Name) FROM Colors AS c WHERE c.Name LIKE @text", parameter);
• C. var parameter = new ObjectParameter("text", HttpUtility.HtmlEncode(text) + "%"); var result = context.CreateQuery<string>(
  "SELECT (c.Name) FROM Colors AS c WHERE c.Name LIKE '@text'@, parameter);
• D. var parameter = new ObjectParameter("text", text + "%");
  var result = context.CreateQuery<string>(
  "SELECT VALUE (c.Name) FROM Colors AS c WHERE c.Name LIKE @text",
  parameter);

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 need to ensure that the model and mapping files are not deployed as application resources. What
should you do?

• A. Modify the connection string in the application's .config file to refer to the relative path to the .edmx file.
• B. Modify the connection string in the application's .config file to refer to the absolute physical path to the .edmx file.
• C. Set the value of the .edmx file's Build Action property to Copy to Output.
• D. Set the value of the .edmx file's Metadata Artifact Processing property to Copy to Output Directory.