Microsoft Azure Data Fundamentals — Question 192

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.

Answer options

• A. INDEX
• B. EXISTS
• C. JOIN
• D. ORDERBY
• E. SELECT

Correct answer: C, E

Explanation

The correct options are C and E because a JOIN is needed to combine the customer and order tables based on a common field, while SELECT is necessary to specify which columns to return in the result set. INDEX, EXISTS, and ORDERBY are not required for the basic retrieval of orders by customers in this scenario.