ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 55 - TDA-C01 discussion

Report
Export

You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.

DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.

You want to combine the tables to meet the following requirements:

. Each record in Employeelnfo must be retained in the combined table.

. The records must contain the Department Name, Size, and VP fields.

* Every record must have a full name.

Which type of join should you use?

A.
Inner
Answers
A.
Inner
B.
Left
Answers
B.
Left
C.
Full outer
Answers
C.
Full outer
D.
Union
Answers
D.
Union
Suggested answer: B

Explanation:

To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:

Join Your Data - Tableau

Join Types in Tableau

asked 23/09/2024
Andrew Chan
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first