A business analyst is using a client table and an invoice table to create a database view that shows clients who have not made purchases yet. Which of the following joins is most appropriate for the analyst to use to create this database view?
A.
INNER JOIN ON Client.Key = Invoice.Key
B.
RIGHT JOIN ON Client.Key = Invoice.Key WHERE BY Client.Key IS NULL
C.
LEFT JOIN ON Client.Key = Invoice.Key
D.
LEFT JOIN ON Client.Key = Invoice.Key WHERE BY Invoice.Key IS NULL
D Without filtering (WHERE), the LEFT JOIN will return all Clients and their Invoices. For those clients without Invoices NULL will be returned for invoice details.
The WHERE (without the "BY") clause will filter only those Clients without Invoices. It is unclear why the answer contains the "BY" (WHERE BY) as it will fail in SQL Server.
Assuming that "BY" was mistakenly added by the "examinator", answer D will be correct.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.DS0-001 Exam Questions
Log in to ExamTopics
Sign in:
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.
LtCmrData
2 months, 3 weeks ago