exam questions

Exam MB-500 All Questions

View all questions & answers for the MB-500 exam

Exam MB-500 topic 4 question 22 discussion

Actual exam question from Microsoft's MB-500
Question #: 22
Topic #: 4
[All MB-500 Questions]

You are a Dynamics 365 Finance developer.

You have a table named FMVehicle that contains a field named VehicleId. The table has an index named VehicleIdIdx on the VehicleId field. You declare a table buffer named vehicle to refer to the table.

You need to select all records from the FMVehicle table in ascending order based on VehicleId field in the vehicle variable.

Which embedded-SQL statement should you use?

  • A. select vehicle order by VehicleIdIdx desc;
  • B. select vehicle order by VehicleId;
  • C. select vehicle order by vehicleIdIdx asc;
  • D. select vehicleId from vehicle order by vehicleId asc;
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
8933e4c
8 months, 2 weeks ago
Selected Answer: B
B is correct.
upvoted 1 times
...
Quentin_86
1 year, 6 months ago
Selected Answer: B
Answer is B
upvoted 4 times
...
_Test
1 year, 9 months ago
B is correct
upvoted 2 times
...
TGDrughino
1 year, 9 months ago
B is the correct answer. You cannot order by an index and the request is to select all the records so, no D but B.
upvoted 2 times
...
Dob64
1 year, 11 months ago
B is the correct answer
upvoted 2 times
...
Abrantie
2 years, 2 months ago
Answer is D
upvoted 2 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
Loading ...