nerdexam
Microsoft

70-516 · Question #108

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses the Entity Framework. The application has the entity model shown in the following diagram. The…

The correct answer is A. (from person in model.SalesPersons. See the full explanation below for the reasoning.

Question

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses the Entity Framework. The application has the entity model shown in the following diagram. The application must create a projection of the unique set of names and year-to-date sales for territories where at least one sales person had sales last year of more than $100,000. The projection must consist of properties named Sales and Name. You need to write a query that will generate the required projection. Which code segment should you use?

Exhibit

70-516 question #108 exhibit

Options

  • A(from person in model.SalesPersons
  • B(from person in model.SalesPersons
  • Cmodel.SalesTerritories.
  • Dmodel.SalesTerritories.

How the community answered

(38 responses)
  • A
    79% (30)
  • B
    3% (1)
  • C
    5% (2)
  • D
    13% (5)

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice