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 index VehicleId;

B. select vehicle index VehicleIdIdx;

C. select VehicleId from vehicle order by VehicleIdIdx asc;

D. select vehicle order by VehicleId desc;








 

Suggested Answer: B

The 'index VehicleIdIdx' statement will cause an Order By Asc of the fields contained in the index.  In this case, that means an Order By Asc of the VehicleID field.

This question is in MB-500 Microsoft Dynamics 365 Finance and Operations Apps Developer Exam
For getting Microsoft Certified: Dynamics 365 Finance and Operations Apps Developer Associate Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.