While optimizing a dashboard that currently uses a live connection to a corporate data warehouse, you consider switching to a Tableau extract. Which statement describes functionality you will gain with an extract that is unavailable when the connection remains live?
Row-level security rules defined in the source database are automatically enforced by Tableau without additional configuration.
Queries are processed in Tableau's high-performance in-memory engine rather than in the remote database.
Custom SQL statements can now be authored and edited directly on Tableau Server instead of in Tableau Desktop.
Data changes in the warehouse become visible to viewers immediately without any refresh process.
An extract is a snapshot of the source data stored in Tableau's columnar, compressed in-memory engine. Because queries run against the local extract, they no longer rely on the remote database for processing, which can improve speed and reduce load on the warehouse. A live connection, by contrast, always pushes every query to the underlying database, so it never benefits from Tableau's in-memory performance gains. Live connections do keep data instantly up to date, preserve database-level row security, and allow Custom SQL editing just as extracts do, but none of those features are gained specifically by creating an extract.
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 Tableau's in-memory engine and how does it improve performance?
Open an interactive chat with Bash
What are the trade-offs between using live connections and Tableau extracts?
Open an interactive chat with Bash
How do Tableau extracts handle compressed data, and why is it beneficial?
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 .