For a new report, a consultant needs to build a data model with three different...

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.