Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
What is the primary difference between a Data Extract and a Live connection in Tableau?
⚠ Common exam trap
Candidates often confuse the purpose of an extract, thinking it is only for offline use. They miss that the primary benefit is performance optimization through local, columnar data storage.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Extracts provide a local, optimized snapshot of the data.
A Live connection queries the source database directly each time a view is updated, ensuring data is always current but potentially slow. An Extract is a local copy of data that provides faster performance and offloads processing from the source database. Choosing between them is a fundamental decision that balances the need for real-time data against the requirement for system responsiveness.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Extracts are always faster but cannot be scheduled for refresh.
Why it's wrong here
Extracts are indeed faster, but they can absolutely be scheduled for refresh using Tableau Server or Tableau Cloud. The claim that they cannot be refreshed is factually incorrect and misrepresents the core functionality of Tableau's extract management features.
- ✗
Live connections automatically aggregate data at the source.
Why it's wrong here
Live connections transmit queries to the source; they do not automatically aggregate data unless that logic is built into the underlying database views. The database remains responsible for execution, and Tableau simply acts as the interface for displaying the result sets returned by that database.
- ✓
Extracts provide a local, optimized snapshot of the data.
Why this is correct
Extracts create a high-performance, compressed file that is stored locally. This snapshot allows for rapid visualization updates by offloading the workload from the source database, which is the defining characteristic that distinguishes extracts from live connections in an analytical workflow.
- ✗
Live connections are only available for cloud-based sources.
Why it's wrong here
Live connections are supported for a wide variety of sources, including local relational databases like SQL Server, Oracle, and MySQL. Limiting live connections to cloud sources is incorrect, as the architecture supports any connection where a driver and network connectivity exist.
About these practice questions
One of 126 original Tableau-Desktop-Found practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.