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

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

Wei

1 months ago

D) Right join

upvoted 0 times

...

Kristofer

1 months ago

C) Left join

upvoted 0 times

...

Tammara

2 months ago

B) Outer join

upvoted 0 times

...

Alyssa

2 months ago

A) Inner join

upvoted 0 times

...

Kati

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

...

Melvin

2 months ago

A) Inner join

upvoted 0 times

...

Chanel

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

Lorrine

2 months ago

D) Right join

upvoted 0 times

...

Lamar

2 months ago

C) Left join

upvoted 0 times

...

Ronald

2 months ago

B) Outer join

upvoted 0 times

...

Robt

2 months ago

A) Inner join

upvoted 0 times

...

Andra

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

2 months ago

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

upvoted 0 times

...

Germaine

2 months ago

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

upvoted 0 times

...

Leonora

3 months ago

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

upvoted 0 times

...

Nadine

3 months ago

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

upvoted 0 times

...

Arlen

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

3 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

2 months ago

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

upvoted 0 times

...

Vernell

3 months ago

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

upvoted 0 times

...

Valene

3 months ago

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

upvoted 0 times

...

Junita

3 months ago

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

upvoted 0 times

...

Dino

3 months ago

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

upvoted 0 times

...

Sunny

3 months ago

I think the answer is A) Inner join.

upvoted 0 times

...

Dong

3 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