Halloween Sale Special Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Salesforce Certified Tableau Data Analyst Analytics-DA-201 Question # 5 Topic 1 Discussion

Salesforce Certified Tableau Data Analyst Analytics-DA-201 Question # 5 Topic 1 Discussion

Analytics-DA-201 Exam Topic 1 Question 5 Discussion:
Question #: 5
Topic #: 1

A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:

    EmployeeInfo is the first table that is dragged to the canvas,

    The records must contain the Full Name, and the Department Name, Size, and VP fields if available,

    Not all records have an exact match.

Which type of join should the analyst use?


A.

Inner


B.

Union


C.

Full outer


D.

Left


Get Premium Analytics-DA-201 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.