Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Analytics-101 Exam - Topic 1 Question 3 Discussion

When should a Tableau associate use a relationship instead of a join for two data sets?
D) The data sets include similar data aggregated at different levels of detail.
A) To use both data sets across multiple sheets in a visualization.
B) The data sets are in two separate tables within a single spreadsheet.
C) The data sets include similar data aggregated up to the highest level.

Salesforce Analytics-101 Exam - Topic 1 Question 3 Discussion

Actual exam question for Salesforce's Analytics-101 exam
Question #: 3
Topic #: 1
[All Analytics-101 Questions]

When should a Tableau associate use a relationship instead of a join for two data sets?

Show Suggested Answer Hide Answer
Suggested Answer: D

A relationship is particularly appropriate when the tables being combined contain data at different levels of detail, making D correct. Tableau relationships operate in the logical layer of the data model and preserve each logical table's native granularity. Tableau determines the necessary joins dynamically during analysis according to the fields used in the visualization. This behavior is materially different from a physical join. A join merges records into a single physical table before analysis. If tables have different granularities, a physical join can duplicate measure values or remove records depending on the join structure and matching keys. Relationships reduce that risk because Tableau aggregates relevant information according to each table's natural level of detail before combining results as required by the visualization. Official Tableau guidance explicitly recommends relationships for combining data from different levels of detail. Relationships also preserve independent logical tables rather than flattening them into a single physical table. Option B merely describes where tables reside and does not determine whether a relationship or join is preferable. Options A and C likewise do not identify the principal modeling scenario addressed by relationships. Relevant Tableau Desktop concepts include logical tables, physical tables, relationships, joins, aggregation behavior, and preservation of level of detail.


Contribute your Thoughts:

0/2000 characters
Maynard
1 day ago
I remember practicing a question about when to use relationships versus joins, and I think it had something to do with different levels of detail.
upvoted 0 times
...
Gianna
7 days ago
I think relationships are better when you want to use both data sets across multiple sheets, but I'm not entirely sure if that's the only reason.
upvoted 0 times
...

Save Cancel