Exam 70-487 All Questions

View all questions & answers for the 70-487 exam

Exam 70-487 topic 3 question 8 discussion

Actual exam question from Microsoft's 70-487

Question #: 8
Topic #: 3

The GetExternalOrder() method in the ExternalQueueService service is throwing a runtime error. The method must query the database for a record that matches the orderNum parameter passed to the method.
You need to modify the queryString string to retrieve the record.
With which code segment should you replace line EQ64?

A. Option A
B. Option B
C. Option C
D. Option D

Show Suggested Answer

Suggested Answer: C 🗳️

by SvM at Dec. 10, 2019, 11:48 a.m.

Comments

Submit Cancel

MaverickCalibre

Highly Voted 5 years, 6 months ago

Correct answer is C. Verified from other dumps and sources.

upvoted 14 times

MaverickCalibre

5 years, 6 months ago

Refer below link in support of my comment. https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/entity-sql-quick-reference

upvoted 5 times

Gorilla

5 years, 1 month ago

Okay, but how do you understand: "Only one item can be specified in a SELECT VALUE clause. When such a clause is used, no row wrapper is constructed around the items in the SELECT clause, and a collection of the desired shape can be produced, for example: SELECT VALUE a." Answer C gives whole entity as a "value", which does not seem valid for me.

upvoted 1 times

exgam_20

5 years, 1 month ago

Entity SQL, my friend

upvoted 3 times

...

tiger25

5 years, 4 months ago

This is EntitySql so sure the answer is C.

upvoted 7 times

majco333

5 years, 3 months ago

C -> see example: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/select-entity-sql#example

upvoted 2 times

...

SvM

Highly Voted 5 years, 6 months ago

The correct answer is A

upvoted 7 times

LeSpam

4 years, 9 months ago

A is definitely incorrect. We are querying by EntitySql so C is correct. https://www.entityframeworktutorial.net/Querying-with-EDM.aspx

upvoted 4 times

...

Sviato

Most Recent 4 years, 6 months ago

Consumer of GetExternalOrder() needs OrderNum, OrderValue and VectorId. So it cannot be C or D. It shild be A

upvoted 1 times

...

zimzimzimma

4 years, 8 months ago

I think it should be B. Why not B?

upvoted 1 times

zimzimzimma

4 years, 8 months ago

Nvm, C is correct. The VALUE statement removes the implicit row wrapper.

upvoted 1 times

...

Dreamchaser1980

4 years, 9 months ago

I think C is correct, similar code can be found here: https://docs.microsoft.com/en-us/dotnet/api/system.data.objects.objectcontext.createquery?view=netframework-4.8#examples

upvoted 1 times

...

Dev666

4 years, 10 months ago

The correct answer is C! Svm is wrong

upvoted 1 times

...