Exam 70-761 topic 1 question 47 discussion

The one and only correct answer A for everyone to try out: CREATE TABLE #CRM ( CustomerID INT NOT NULL, CustomerCode char(4) NULL, CustomerName varchar(50) NOT NULL ); CREATE TABLE #HR ( CustomerID INT NOT NULL, CustomerCode char(4) NULL, CustomerName varchar(50) NOT NULL ); INSERT INTO #CRM(CustomerID, CustomerCode, CustomerName) VALUES (1, 'CUS1', 'Roya'), (2, 'CUS9', 'Almundena'), (3, 'CUS4', 'Jack'), (4, NULL, 'Jane'), (5, NULL, 'Francisco'); INSERT INTO #HR(CustomerID, CustomerCode, CustomerName) VALUES (1, 'CUS1', 'Roya'), (2, 'CUS2', 'Jose'), (3, 'CUS9', 'Almundena'), (4, NULL, 'Jane'); SELECT c.CustomerCode, c.CustomerName, h.CustomerCode, h.CustomerName FROM #CRM c INNER JOIN #HR h ON c.CustomerCode = h.CustomerCode AND c.CustomerName = h.CustomerName; DROP TABLE #CRM; DROP TABLE #HR;

I checked it. Both A and B is correct answer

A is correct. B incorrect see comment Bartek. D isncorrect: The T-SQL EXCEPT operator, added in SQL Server 2005, returns only distinct rows that appear in one set and not the other. Specifically, EXCEPT returns rows from the input set listed first in the query.

Both A and B is incorrect man. The correct answer is "SELECT CustomerCode, CustomerName FROM Customer_CRMSystem EXCEPT SELECT CustomerCode, CustomerName FROM Customer_HRSystem"

I think correct answer is both A and B.