exam questions

Exam QSDA2018 All Questions

View all questions & answers for the QSDA2018 exam

Exam QSDA2018 topic 1 question 8 discussion

Actual exam question from QlikView's QSDA2018
Question #: 8
Topic #: 1
[All QSDA2018 Questions]

Refer to the exhibit.

A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?

  • A. Left Join
  • B. Inner Join
  • C. Left Keep
  • D. Outer Join
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
d7d49fe
7 months ago
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 :-)
upvoted 1 times
...
BenOmetisParker
1 year, 2 months ago
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!)
upvoted 1 times
...
ypolat
1 year, 2 months ago
Why is a Inner Join Correct ? can someone explain ?
upvoted 2 times
...
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.

SaveCancel
Loading ...