An analyst is building a dashboard connected to a large, slow database and needs to maximize performance. What is the primary advantage of using a Tableau data extract instead of a live connection in this scenario?
Access to real-time data that is continuously updated from the source.
A reduced query load on the source database, which is the main performance factor.
The ability to work completely offline with no impact on data freshness.
Improved dashboard performance, as queries are processed by Tableau's high-performance data engine.
The correct answer is that extracts provide improved dashboard performance. A Tableau data extract is a snapshot of data stored as an optimized .hyper file, which uses Tableau's high-performance, in-memory data engine. This allows for much faster query processing compared to sending queries to a potentially slow live database, directly addressing the performance issue described in the scenario.
Access to real-time data is an advantage of a live connection, not an extract. Extracts are static snapshots and must be manually or scheduled to be refreshed to get updated data.
The ability to work offline is a benefit of using an extract, but in the context of a slow database causing performance issues, the most significant advantage is the improvement in query speed.
Reducing the query load on the source database is a secondary benefit of using an extract, but the primary advantage for the end-user and dashboard developer is the enhanced performance and responsiveness of the dashboard itself.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Why is Tableau's data extract faster than a live connection?
Open an interactive chat with Bash
How is a Tableau extract refreshed for updated data?
Open an interactive chat with Bash
What are scenarios where a live connection is better than an extract?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .