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

Otis

4 days ago

C) Left join, for sure. Anything else would be leaving me in the dark, and that's no way to manage an employee database.

upvoted 0 times

...

Chanel

17 days 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

19 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

Elmer

6 days ago

D) Right join could also work depending on the specific requirements.

upvoted 0 times

...

Germaine

8 days ago

I see where you're coming from, but I think B) Outer join might be the way to go.

upvoted 0 times

...

Leonora

13 days ago

Actually, I believe A) Inner join would be more appropriate in this case.

upvoted 0 times

...

Nadine

15 days ago

I think you're right, C) Left join would be the best choice for that.

upvoted 0 times

...

Arlen

28 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

...

Willetta

1 months ago

Definitely C) Left join. That's the way to go if I want to see all the employee data even if there's no match in the manager table.

upvoted 0 times

France

7 days ago

Left join it is, to include all employee data in the result.

upvoted 0 times

...

Vernell

10 days ago

I agree, using Left join will show all employee records regardless of a match in the manager table.

upvoted 0 times

...

Valene

18 days ago

C) Left join is the correct choice for that scenario.

upvoted 0 times

...

Junita

1 months ago

I'm not sure. Can someone explain why Inner join is the correct answer?

upvoted 0 times

...

Dino

1 months ago

I agree with Sunny. Inner join will only return matching records.

upvoted 0 times

...

Sunny

1 months ago

I think the answer is A) Inner join.

upvoted 0 times

...

Dong

1 months 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

Lilli

12 days ago

B) Outer join

upvoted 0 times

...

Rosio

21 days ago

A) Inner join

upvoted 0 times

...