Microsoft
DP-900 · Question #305
You have the following T-SQL statement. SELECT o.OrderNo, o.OrderDate, c.Address, c.City FROM Order AS o JOIN Customer AS c ON o.Customer = c.ID; What is the function of the ON clause?
Sign in or unlock DP-900 to reveal the answer and full explanation for question #305. The question stem and answer options stay visible for context.
Submitted by hassan_iq· Mar 30, 2026Identify considerations for relational data on Azure
Question
You have the following T-SQL statement. SELECT o.OrderNo, o.OrderDate, c.Address, c.City FROM Order AS o JOIN Customer AS c ON o.Customer = c.ID; What is the function of the ON clause?
Options
- Ato update data in the Customer table
- Bto match data in the Customer table to data in the Order table
- Cto define an alias for the Customer table
- Dto update data in the Order table
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
#SQL JOIN#ON clause#T-SQL#relational queries