Exam Analytics-Con-301 Topic 5 Question 4 Discussion

Comprehensive and Detailed Explanation From Exact Extract:
When optimizing performance with live connections, Tableau documentation emphasizes minimizing the workload passed to the database. Key principles include:
* Databases resolve numeric and Boolean fields significantly faster than strings and dates.
* Using simpler data types reduces query parsing time and improves join and filter performance.
* This is a standard Tableau recommendation for live query optimization.
Why the other answers are incorrect:
* B: Table calculations add workload on Tableau, but live performance depends on database efficiency; granular table calc processing worsens performance.
* C: Custom SQL often hurts performance because it disables query optimization, increases load times, and prevents Tableau from generating efficient queries.
* D: Compute Calculations Now applies only to extracts, and has no effect on live connections.
Thus, the documented performance best practice for live sources is to use numbers and Booleans instead of strings and dates.
* Live connection optimization guidance: prefer numeric and Boolean fields over strings/dates.
* Best practices cautioning against Custom SQL for performance.
* Documentation stating Compute Calculations Now applies only to extracts.