ANALYTICS-ARCH-201 practice question 15 of 30

If a performance recording indicates that query response times from external databases are the primary bottleneck in Tableau Server, what should be the first course of action?

Full set: 200 questions
Answer options
A: Upgrading the external database servers for faster processing
B: Reviewing and optimizing the database queries used in Tableau workbooks for efficiency Correct answer
C: Implementing caching mechanisms in Tableau Server to reduce the reliance on database queries
D: Restricting the size of data extracts to lessen the load on the external databases
Correct Answer:
B. Reviewing and optimizing the database queries used in Tableau workbooks for efficiency
Explanation

A performance recording in Tableau Server that identifies long query response times from an external database points directly to the "Executing Query" phase as the primary bottleneck. The most effective and logical first step is to address the efficiency of the queries themselves. This involves analyzing the workbook's design, filters, calculations, and level of detail to ensure Tableau generates the most optimal SQL queries. Optimizing the queries directly targets the root cause of the performance issue without incurring the cost of hardware upgrades or altering the data connection architecture.

Why Incorrect

A. Upgrading the external database servers for faster processing: This is a costly infrastructure change that should be considered only after software-level optimizations, like query tuning, have been exhausted.
C. Implementing caching mechanisms in Tableau Server to reduce the reliance on database queries: Caching helps with repeated queries but does not solve the underlying problem of a slow initial query, which will still create a bottleneck.
D. Restricting the size of data extracts to lessen the load on the external databases: This changes the data connection strategy from live to extract. It's a valid performance technique but does not fix the identified bottleneck for the existing live connection. ---

References

1. Tableau Official Documentation, "Designing Efficient Workbooks" Whitepaper. In the section "Data Strategy," under "Query Optimization," the paper states, "The most significant performance improvements for workbooks connected to live databases can often be realized by optimizing the queries." This establishes query optimization as the primary action for live connection bottlenecks. (See page 10).

2. Tableau Official Documentation, "Create a Performance Recording." In the section "Review the Performance Workbook," the documentation guides the user to interpret the timeline. It explains that a long bar for "Executing Query" indicates a performance issue with the data source. The recommended actions focus on the workbook and data source, such as reducing the number of marks or optimizing filters, which directly relate to query optimization.

3. Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Wiley. While not specific to Tableau, this foundational text on data warehousing and analytics architecture emphasizes that query performance is fundamentally tied to the query's structure and the underlying database design (e.g., indexing, aggregations). Chapter 18, "DW/BI System Performance and Tuning," prioritizes query tuning as a critical step before considering hardware scaling. This principle is directly applicable to the scenario.

Scroll to Top