An analyst working with a transactional database notices slow queries during business hours. They require up-to-the-minute figures for today's orders but will accept overnight latency for historic trend views. Which Tableau strategy satisfies both needs while lessening daytime database load?
Replace the live connection with a full extract that users refresh on demand.
Schedule an hourly full extract for all tables and remove the live connection.
Create a daily extract for historical data and keep a live connection only for the current-day orders table.
Maintain a single live connection for all worksheets.
Using a daily extract for the historical tables removes the majority of queries that strain the production database, because the extract is stored in Tableau's fast, columnar format and is only refreshed overnight. Keeping a separate live connection exclusively for today's orders retains real-time visibility where it is required. Relying solely on live connections keeps all queries hitting the database, while full extracts-whether hourly or on-demand-either introduce unnecessary refresh overhead or prevent real-time monitoring altogether.
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.
What is a live connection in Tableau?
Open an interactive chat with Bash
What is a Tableau data extract, and how does it work?
Open an interactive chat with Bash
Why is a combination of live connection and data extract a good strategy?
Open an interactive chat with Bash
What is the difference between a live connection and an extract in Tableau?
Open an interactive chat with Bash
Why is Tableau’s extract format faster than querying a live database?
Open an interactive chat with Bash
How does a daily extract reduce database load compared to refresh-on-demand extracts?
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 .