PrepAway - Latest Free Exam Questions & Answers

What are three reasons to use joins instead of relationships?

What are three reasons to use joins instead of relationships? (Choose three.)

A. You need to use a specific join type.

B. You need to create an extract that will have multiple tables.

C. You need to use row-level security.

D. You need to use a data model that supports shared dimensions.

E. You need to connect to multiple databases.

Explanation:
You don’t define join types for relationships.
A very common use case where you would choose a join over relationship is the implementation of row-level-securit.
Joins are used to combine the rows from multiple tables using mutual columns. As an example, assume that you have two tables within a database.

Reference: https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm

Comparing Tableau’s New Relationships to Blends and Joins

A SQL join on multiple tables: overview and implementation


Leave a Reply

Your email address will not be published. Required fields are marked *