Passing exam with 070-516 latest training materials

You use Microsoft Visual Studio 2010 to create a Microsoft .NET Framework 4.0 application. You create an Entity Data Model for the database tables shown in the following diagram.

You need to modify the .edmx file so that a many-to-many association can exist between the Address and
Customer entities.
Which storage Model section of the .edmx file should you include?

• A. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50" />
  </EntityType>
• B. <EntityType Name="CustomerAddress"> <Key>
  <PropertyRef Name="CustomerAddressID" /> </Key> <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>
• C. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false" />
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"
  DefaultValue="Home" />
  </EntityType>
• D. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerAddressID" />
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>

You use Microsoft .NET Framework 4.0 to develop an application that exposes a WCF Data Services
endpoint.
The endpoint uses an authentication scheme that requires an HTTP request that has the following header
format.
GET /OData.svc/Products(1)
Authorization: WRAP access_token "123456789"
You add the following method to your DataService implementation.
01 protected override void OnStartProcessingRequest(ProcessRequestArgs args)
02 {
03 ....
04 }
You need to ensure that the method retrieves the authentication token. Which line of code should you use?

• A. string token = args.OperationContext.RequestHeaders["WRAP access_token"];
• B. string token = args.OperationContext.ResponseHeaders["WRAP access_token"];
• C. string token = args.OperationContext.ResponseHeaders["Authorization"];
• D. string token = args.OperationContext.RequestHeaders["Authorization"];

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. You load records from the Customers table
into a DataSet object named dataset.
You need to retrieve the value of the City field from the first and last records in the Customers table.
Which code segment should you use?

• A. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count]["City"].ToString();
• B. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• C. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count - 1]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• D. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count - 1]["City"].ToString();

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 an association to the stored procedure.
• B. Add a code generation item that has the name of the stored procedure.
• C. Add a function import for the stored procedure.
• D. Add an entity that mirrors the properties of the complex type.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model your entities.
You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code
accesses the POCO entities directly.
You need to ensure that the state manager synchronizes when changes are made to the object graph.
Which ObjectContext method should you call?

• A. ApplyPropertyChanges
• B. SaveChanges
• C. DetectChanges
• D. Refresh