What is the most performant approach to model the data for a live connection?

For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.

What is the most performant approach to model the data for a live connection?
A . Relating the tables in Tableau Desktop
B . Blending the first two tables with the third
C . Joining the tables in Tableau Prep
D . Joining the tables in Tableau Desktop

View Answer

Answer: A

Explanation:

For a performant live connection in Tableau Cloud, especially when dealing with large datasets that preclude the use of extracts, relating the tables in Tableau Desktop is the recommended approach. This method allows for flexibility in how the data is queried and can improve performance by leveraging Tableau’s relationships feature, which optimizes queries for the underlying database.

References: The best practices for live connections in Tableau Cloud suggest using relationships to manage complex data models efficiently1.Additionally, Tableau’s documentation on connecting data sources recommends using relationships for better performance with live connections2.