Exam QSDA2018 topic 1 question 8 discussion

It is answer C, I tried it. Left Keep "keeps" the first table (Sales) complete while reducing the target table to only those entries that exist in 'Sales' (key field is EmployeeID). Furthermore, "Keep" does not create one single table, it leaves you with two tables. Thus, as you have no 'joining', you won't multiply your target values, ans Sum(Sales) still works correctly. Try it out :-)

It would resolve the "Remove employees with no sales" section of the question, but wouldn't resolve the "too higher sales figures" section. Based on the answers available I think they assume you would aggregate the Sales Table first and then use the inner join to ensure you only have employees that have sales and targets. With only the partial answer there, its the closest to being 'correct' and fulfilling some of the requirements. SalesExcel: Load * From [lib://User/Files/Sales.xlsx] ; Sales: Load EmployeeID, Sum(Sales) as Sales Resident SalesExcel Group by EmployeeID; Drop table SalesExcel; Inner Join (Sales) Load * From [lib://User/Files/Targets.xlsx]; (or something to that effect!)

Why is a Inner Join Correct ? can someone explain ?