Exam 70-761 topic 1 question 114 discussion

Actual exam question from Microsoft's 70-761

Question #: 114
Topic #: 1

You have a database named DB1 that contains two tables named Sales.Customers and Sales.CustomerTransaction. Sales.CustomerTransactions has a foreign key relationship to column named CustomerID in Sales.Customers.
You need to recommend a query that returns the number of customers who never completed a transaction.
Which query should you recommend?

A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: A
Incorrect Answers:
B: The count should be on the Cust instance of Sales.Customers as it is to the right side of the join.
C: Need a WHERE statement with an IS NULL clause.
D: Must use a LEFT JOIN to obtain the NULL values.
References:
https://technet.microsoft.com/en-us/library/ms190014(v=sql.105).aspx

by TrungMyLanTJ at Oct. 15, 2020, 1:10 a.m.

Comments

Submit Cancel

Landraille

4 years, 4 months ago

B is wrong. You have to precise the table alias : COUNT(Cust.CustomerID) Indeed, the field CustomerID is present in both tables

upvoted 2 times

Djnailz

4 years, 4 months ago

Hi Landraille is the update you are doing part of the recent exam

upvoted 1 times

...

TrungMyLanTJ

4 years, 6 months ago

Typo error here. All the answers are the same

upvoted 1 times

BabyBee

4 years, 5 months ago

Only A and B are the exact same answers, the others are different.

upvoted 2 times

Andy7622

4 years, 4 months ago

Nope. All are different. A and B have different SELECT . No table aliases in B so it's wrong cause there is CustomerID in both tables and if you're using aliases you get error ambigious column name. Must be Select Count(Cust.CustomerID)

upvoted 3 times

Andy7622

4 years, 4 months ago

* Sorry. .... if you're not using aliases ....

upvoted 1 times

...

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 114 discussion

Comments

Landraille

Djnailz

TrungMyLanTJ

BabyBee

Andy7622

Andy7622

SY0-701