You are designing a public-facing workbook. Dashboard users do not need second-by-second updates, and the database administrator wants to reduce query load on the production system. Which data connection approach best meets these needs in Tableau Desktop?
Use a live connection so every dashboard interaction retrieves the newest rows directly from the database.
Keep the connection live to avoid any file-size limits or refresh scheduling tasks.
Create an extract so the workbook queries a local .hyper snapshot instead of the production database.
Stay live to inherit all row-level security rules defined in the source system without extra setup.
A Tableau extract stores a snapshot of the source data in a local .hyper file. Because the workbook reads from this file instead of sending every query to the operational database, dashboard interaction is typically faster and the production system experiences less load. Live connections, in contrast, run queries directly against the source each time a user opens or interacts with the view, preserving real-time data and database-level security but increasing query traffic. Therefore, using an extract is the most appropriate choice for the stated scenario, while the other options describe characteristics or advantages of live connections that are not required here.
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 Tableau extract and how does it work?
Open an interactive chat with Bash
What are the differences between live connections and extracts in Tableau?
Open an interactive chat with Bash
Why does Tableau use the .hyper file format for 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 .