Microsoft
DP-900 · Question #306
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 y
Sign in or unlock DP-900 to reveal the answer and full explanation for question #306. The question stem and answer options stay visible for context.
Submitted by eva_at· Mar 30, 2026Identify considerations for relational data on Azure
Question
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.
Options
- AINDEX
- BEXISTS
- CJOIN
- DORDERBY
- ESELECT
Unlock DP-900 to see the answer
You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#T-SQL#JOIN#ORDER BY#relational queries