Exam MB-500 topic 6 question 1 discussion

Actual exam question from Microsoft's MB-500

Question #: 1
Topic #: 6

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 VehicleId from vehicle order by VehicleIdIdx asc;
B. select vehicle index VehicleId;
C. select vehicle order by VehicleIdIdx desc;
D. select vehicle index VehicleIdIdx;

Show Suggested Answer

Suggested Answer: D 🗳️

by yuri_rusanov at Dec. 9, 2022, 7:55 a.m.

Comments

Submit Cancel

DanSinbad

Highly Voted 2 years, 3 months ago

Selected Answer: D

D is correct

upvoted 6 times

...

8933e4c

Most Recent 10 months, 1 week ago

Selected Answer: D

D is correct, though I believe a select vehicle order by VehicleId asc is the preferred way to implement that.

upvoted 1 times

...

Blackword

2 years, 4 months ago

D is correct. A is not. Table xxx does not contain fild named 'xxxxxxIdx'

upvoted 4 times

...

TM22

2 years, 7 months ago

D is correct

upvoted 2 times

...

yuri_rusanov

2 years, 7 months ago

Page 20, Topic 4, Question 4 is absolutely identical to this one, answer options included, but has a different answer marked as correct. Can somebody please clarify this question for me?

upvoted 1 times

yuri_rusanov

2 years, 7 months ago

After 40 minutes of research I've came to the conclusion that no matter best practices and deprecation patch notes, at no point of time was it possible to say "order by <index>". Therefore I pick D for the correct answer in this scenario.

upvoted 2 times

...