Exam 70-461 topic 1 question 9 discussion

Actual exam question from Microsoft's 70-461

Question #: 9
Topic #: 1

You have a Microsoft SQL Server database that contains tables named Customers and Orders.
The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
✑ Returns the CustomerName for all customers and the OrderDate for any orders that they have placed.
✑ Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?

A. SELECT CustomerName, OrderDate FROM Customers RIGHT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
B. SELECT CustomerName, OrderDate FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID
C. SELECT CustomerName, OrderDate FROM Customers CROSS JOIN Orders ON Customers.CustomerID = Orders.CustomerID
D. SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
http://msdn.microsoft.com/en-us/library/ms177634.aspx

by Zviko at May 7, 2019, 3:21 p.m.

Comments

Submit Cancel

Tomprof

4 years, 6 months ago

Sorry. Use a left join

upvoted 2 times

...

Tomprof

4 years, 6 months ago

The correct answer is D. The question requires you to show al sutlers who haven't place any other yet which is in the customers Table (thus making it the right table). All you have to do is to use the right outer join to bring in a matching values from the Orders table (left table).

upvoted 2 times

...

Jaywalker

4 years, 6 months ago

Option D is correct because the second criteria states ----( Results must include customers who have not placed any orders) so we are expected to populate all Customers whether or not they have orders

upvoted 3 times