TDS-C01 practice question 12 of 35

True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Full set: 316 questions
Answer options
A: True Correct answer
B: False
Correct Answer:
A. True
Explanation

Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_85_img_1.jpg Inner join https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_85_img_2.jpg Left Join Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm

Scroll to Top