ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-487 All Questions

View all questions & answers for the 70-487 exam
Go to Exam

Exam 70-487 topic 3 question 8 discussion

Actual exam question from Microsoft's 70-487
Question #: 8
Topic #: 3
[All 70-487 Questions]

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 Hide Answer
Suggested Answer: C 🗳️
by SvM at Dec. 10, 2019, 11:48 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
MaverickCalibre
Highly Voted 5 years, 4 months ago
Correct answer is C. Verified from other dumps and sources.
upvoted 14 times
MaverickCalibre
5 years, 4 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
4 years, 11 months 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
4 years, 11 months ago
Entity SQL, my friend
upvoted 3 times
...
...
...
tiger25
5 years, 2 months ago
This is EntitySql so sure the answer is C.
upvoted 7 times
majco333
5 years, 1 month 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, 4 months ago
The correct answer is A
upvoted 7 times
LeSpam
4 years, 7 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, 4 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, 7 months ago
I think it should be B. Why not B?
upvoted 1 times
zimzimzimma
4 years, 7 months ago
Nvm, C is correct. The VALUE statement removes the implicit row wrapper.
upvoted 1 times
...
...
Dreamchaser1980
4 years, 8 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, 8 months ago
The correct answer is C! Svm is wrong
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago