Exam 70-487 topic 1 question 107 discussion

Actual exam question from Microsoft's 70-487

Question #: 107
Topic #: 1

You are developing an order processing application that uses the Entity Framework against a SQL Server database. The application has a method that returns orders filtered by date.
The Order class is shown below.

You must filter the data on the SQL server before it is returned to the application server.
You need to return orders more recent than the entered date.
Which code segment should you use?
A.

B.

C.

D.

D -

Show Suggested Answer

Suggested Answer: Explanation
References:
https://docs.microsoft.com/en-us/dotnet/api/system.collections.generic.ienumerable-1?view=netframework-4.7.2

by bobtables at Nov. 28, 2019, 11:14 p.m.

Comments

Submit Cancel

bobtables

Highly Voted 5 years, 8 months ago

The answer is B.

upvoted 42 times

...

nfgmaia

Highly Voted 5 years, 8 months ago

Wrong. It's B.

upvoted 12 times

...

Dev666

Most Recent 4 years, 10 months ago

B is correct.

upvoted 5 times

...

Sanfour

5 years ago

While querying data from database, IEnumerable executes select query on server side, load data in-memory on client side and then filter data. Hence does more work and becomes slow. While querying data from database, IQueryable executes select query on server side with all filters. Hence does less work and becomes fast.

upvoted 3 times

...

supersunny

5 years, 6 months ago

B is correct.

upvoted 7 times

...