A data analyst is creating a dashboard that must display near real-time sales data from a rapidly changing transactional database. The primary requirement is that the visualizations reflect the most current data at all times. Which connection type should be used?
A live connection, because it sends queries directly to the database, providing up-to-the-minute data.
An extract, because it can be scheduled to refresh automatically on Tableau Server.
A live connection, because it packages the data within the workbook file for offline access.
An extract, because it will improve the performance and speed of the dashboard.
The correct choice is a live connection. Live connections query the database directly each time a view is loaded or updated, ensuring that the data displayed is the most current available from the source. An extract is a snapshot of the data taken at a specific point in time and would require frequent refreshes to stay current, making it less suitable for real-time needs. While extracts can improve performance, the scenario's primary requirement is data freshness, which is the main advantage of a live connection. A live connection does not embed data in the workbook for offline use; that is a characteristic of 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 the difference between a live connection and an extract in Tableau?
Open an interactive chat with Bash
What are the potential drawbacks of using a live connection in Tableau?
Open an interactive chat with Bash
When should you use an extract instead of a live connection in Tableau?
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 .