exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 299 discussion

Actual exam question from Microsoft's DP-900
Question #: 299
Topic #: 1
[All DP-900 Questions]

You have an Azure SQL database that contains tables for customers and orders.

You need to create a query that will return the orders placed by each customer.

Which two Transact-SOL statements should you include in the query? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

  • A. INDEX
  • B. EXISTS
  • C. JOIN
  • D. ORDERBY
  • E. SELECT
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️

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
SIH007
5 days, 10 hours ago
Selected Answer: CD
If you want to see the customers' orders you should use ORDERBY, using SELECT would not meet the requirement to return the orders by customer.
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago