ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam
Go to 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 🗳️
by SIH007 at March 10, 2025, 1:29 p.m.

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
Submit Cancel
Roy34
3 weeks, 1 day ago
Selected Answer: CE
Select for listing and join for joining
upvoted 2 times
...
OnlineCH
3 weeks, 4 days ago
Selected Answer: CE
SELECT * FROM Orders o JOIN Customers c ON o.CustomerId=c.Id
upvoted 2 times
...
SIH007
1 month, 4 weeks 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago