ANALYTICS-ARCH-201 practice question 21 of 30
After reviewing observability data, you find that Tableau Server’s data extract refreshes are significantly impacting performance during business hours. What architectural change should be made to address this issue?
Full set: 200 questionsThe problem states that extract refreshes are impacting performance specifically "during business hours." This indicates a resource contention issue where background tasks (refreshes) are competing with interactive user sessions for CPU, memory, and I/O. The most direct and architecturally sound solution is to manage this workload by scheduling the resource-intensive extract refreshes to run during off-peak hours (e.g., overnight). This separates the workloads, ensuring that server resources are dedicated to user-facing activities during the day, thereby resolving the performance degradation without altering the data strategy or incurring unnecessary hardware costs.
A. Moving all data extracts to live connections is a drastic change that shifts the performance burden to the underlying database and may not be optimal for complex dashboards.
C. Completely disabling extract refreshes is not a viable solution as it would result in stale, outdated data, rendering the analytics useless for decision-making.
D. Upgrading the server's CPU is a reactive, "brute-force" approach. While it might shorten refresh times, it doesn't solve the fundamental problem of resource contention during peak hours.
1. Tableau Server Documentation: In the "Performance Tuning" section
a key recommendation is workload management. It states
"Schedule extract refreshes for off-peak hours. Refreshes are resource-intensive jobs. Therefore
it is best to run them outside of business hours."
Source: Tableau Help
"Performance Tuning
" Section: "Tune for Extracts."
2. Tableau Whitepaper: The official "Best Practices for a Performant and Stable Tableau Server Environment" whitepaper explicitly advises on this scenario. It highlights the role of the Backgrounder process
which handles extract refreshes
and recommends scheduling these tasks to avoid conflict with user activity.
Source: Tableau Whitepaper
"Tableau Server Scalability
" Section: "Workload Management
" Page 12.
3. University Courseware: Materials on Business Intelligence systems architecture from institutions like the University of Washington explain the different processes within Tableau Server. They detail how the Backgrounder process handles asynchronous jobs like extract refreshes
while the VizQL Server process handles interactive user requests. To optimize performance
these competing workloads should be segregated by time.
Source: University of Washington
"Tableau Server Architecture & Administration
" Section: "Tableau Server Processes
" Slide on "Backgrounder."
Keep practicing
Take the free ANALYTICS-ARCH-201 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ANALYTICS-ARCH-201 practice questions
- Question 1What is the best practice for setting up a log analysis strategy for a large Tableau Serv…
- Question 2When managing a Tableau Server environment on a Linux system, which method is recommended…
- Question 3In the context of a Tableau Server high-availability setup, what is a crucial considerati…
- Question 4A company is transitioning to Tableau Cloud but still has critical data in on-premises da…
- Question 5A Tableau workbook with multiple complex dashboards is experiencing slow loading times. W…
- Question 6For a Tableau administrative dashboard designed to monitor user engagement, which metric …
