Tableau Exam Desktop-Certified-Associate Topic 5 Question 27 Discussion

Actual exam question for Tableau's Desktop-Certified-Associate exam

Question #: 27
Topic #: 5

[All Desktop-Certified-Associate Questions]

You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table. Which join type will you use?

AInner join

BOuter join

CLeft join

DRight join

Show Suggested Answer

Suggested Answer: C

When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.

Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

by Felicitas at Nov 19, 2024, 12:17 AM

Limited Time Offer

25%

Off

Get Premium Desktop-Certified-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Chanel

24 hours ago

C) Left join, easy peasy. Unless you're a manager trying to hide something, then you'd probably go for D) Right join.

upvoted 0 times

...

Andra

3 days ago

Hmm, this is a tough one. I'm going to go with C) Left join. Sounds like the best option to get the full employee data.

upvoted 0 times

...

Arlen

12 days ago

C) Left join is the way to do it. I don't want to miss any employee records, even if the manager data isn't there.

upvoted 0 times

...

22 days ago

I think the answer is C) Left join. That will give me all the records from the employee table and only the matching records from the employee manager table.

upvoted 0 times

Rosio

5 days ago

A) Inner join

upvoted 0 times

...