New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam MB-500 Topic 7 Question 30 Discussion

Actual exam question for Microsoft's MB-500 exam
Question #: 30
Topic #: 7
[All MB-500 Questions]

You are a Dynamics 365 Finance developer.

You have a table named FMVehicle that contains a field named Vehicleld. The table has a clustered index named Vehicleldldx on the Vehicleld 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 Vehicleld field in the vehicle variable.

Which embedded-SQL statement should you use?

Show Suggested Answer Hide Answer
Suggested Answer: C

All select statements use a table variable to fetch records. The results of a select statement are returned in a table buffer variable, here vehicle.


https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data-query

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel