You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name="CPerson"> <Key> <PropertyRef Name="PersonId" /> </Key>
<Property Name="PersonId" Type="Int32" Nullable="false" />
<Property Name="CompanyName" Type="String" />
<Property Name="ContactName" Type="String" />
<Property Name="ContactTitle" Type="String" />
<Property Name="Address" Type="String" />
</EntityType>
You need to ensure that entities within the application are able to add properties related to the city, region,
and country of Person's address.
What should you do?

• A. Create a view named Name that returns city, region, and country along with person IDs. Add a WHERE clause to filter the results to display only the City, Region and Country properties for a specific Person entity.
• B. Create a new complex type named CAddress that contains the properties for city, region, and country. Change the Type of the Address property in CPerson to "Self.CAddress".
• C. Create a SubEntity named Address. Map the SubEntity to a stored procedure that retrieves city, region, and country.
• D. Create a new entity named Address. Add a person ID property to filter the results to display only the City, Region, and Country properties for a specific Person entity.

The application must be configured to run on a new development computer.
You need to configure the connection string to point to the existing named instance.
Which connection string fragment should you use?

• A. Initial Catalog= SQL01\INST01
• B. Data Source=INST01\SQL01
• C. Data Source=SQL01\INST01
• D. Initial Catalog= INST01\SQL01

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
You need to associate a previously deserialized entity named person1 to an object context named model
and persist changes to the database.
Which code segment should you use?

• A. model.People.ApplyChanges(person1) ; model.SaveChanges();
• B. person1.AcceptChanges(); model.SaveChanges();
• C. model.People.Attach(person1); model.SaveChanges();
• D. model.AttachTo("People", person1); model.SaveChanges();

You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The LINQ to SQL
model contains the Product entity.
A stored procedure named GetActiveProducts performs a query that returns the set of active products from
the database.
You need to invoke the stored procedure to return the active products, and you must ensure that the LINQ
to SQL context can track changes to these entities. What should you do?

• A. Add a property named GetActiveProducts to the Product entity.
• B. Select the Product entity, view the entity's property window, and change the Source for the entity to GetActiveProducts.
• C. Navigate to the GetActiveProducts stored procedure in Server Explorer, and drag the procedure onto the Product entity in the LINQ to SQL model designer surface.
• D. Select the Product entity, view the entity's property window, and change the Name for the entity to GetActiveProducts.

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);