Tableau : Joins & Union

Fullname

Email ID

Student Id

What is the difference between a logical layer and a physical layer in Tableau?

• Logical layer is for Unions, while physical layer is for relationships

• Logical layer is for data visualization, while physical layer is for data storage

• Logical layer is for creating joins, while physical layer is for creating relationships

• Logical layer is for creating relationships, while physical layer is for creating joins

Can we create multiple clause while Joining the two tables?

• Yes

• No

When creating a union in Tableau, what is the best practice for selecting multiple files?

• Put all the files in one folder and select the folder

• Select each file individually and drag them into the union

• Create a new folder for each file and select the folders

• Put all the files in one folder and select each file individually

When creating a join in Tableau, what is the default type of join that is created?

• Left join

• Full outer join

• Right join

• Inner join

You have four years of sales data kept in individual files, all stored within a folder. In order to analyze this data, we created a union of all the files. Now, we have received sales data for an additional year, aiming to include this fifth year in the union listing

• Create a relationship between the new file and the existing data

• Append the new file to the existing union

• Refresh the data source

• Union the new file with the existing union

What is the purpose of using a wildcard when creating unions?

• To specify the exact order of fields in the resulting union

• To filter out specific rows from the combined dataset

• To define a pattern for matching multiple files or tables with similar names or structures

• To perform mathematical operations on the combined data