exam questions

Exam MB-500 All Questions

View all questions & answers for the MB-500 exam

Exam MB-500 topic 4 question 39 discussion

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

DRAG DROP
-

You use Dynamics 365 Finance.

You must loop through the customers table and display in the UI the customer account numbers that meet the following requirements:

• Include the first 100 customers.
• The account numbers must be greater than 1,000.
• Order the results from larger to smaller by the customer account number.

You need to write the SQL statement by using SQL in X++.

Which four statements should you include in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

Show Suggested Answer Hide Answer
Suggested Answer:

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
kself
Highly Voted 10 months, 2 weeks ago
"where custTable.AccountNum > 1000" is not correct - it will not compile because AccountNum is a str. The correct option would be "where custTable.AccountNum > '1000'".
upvoted 7 times
a50dc84
9 months, 4 weeks ago
Fully agree
upvoted 1 times
...
...
abhig535
Most Recent 2 weeks, 5 days ago
3 - 4 - 8 - 1 3. while select firstonly100 AccountNum from custTable 4. where custTable.AccountNum > "1000" 8. order by AccountNum desc 1. { info(custTable.AccountNum); }
upvoted 2 times
globeearth
2 weeks ago
Agreed
upvoted 2 times
...
...
DANNYEXAMMB500
2 months ago
3 - 8 - 4 - 1 Cannot user 7, Account num is type string code wont compile.
upvoted 2 times
abhig535
2 weeks, 5 days ago
Should be 3 - 4 - 8 - 1. "ORDER BY" always comes after the "WHERE" clause.
upvoted 1 times
MsPandiPanda
2 weeks, 4 days ago
In SQL, not in X++
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
Loading ...