Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
Which of the following describes the purpose of a 'Data Extract' in Tableau?
⚠ Common exam trap
Candidates frequently mistake extracts for security permission settings or live database connectors, confusing performance optimization with live data streaming capabilities.
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
✓
To improve performance and enable local access.
Data extracts are local, optimized snapshots of data that allow Tableau to store data in a highly compressed and performant .hyper format. By moving data from a source (like a slow database) into an extract, you significantly improve query speed and offload processing from the source system. This is an essential technique for ensuring that end users have a fast, responsive dashboard experience, regardless of the latency of the underlying source.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
To keep data updated in real-time.
Why it's wrong here
Extracts are snapshots and do not provide real-time data connectivity. To achieve real-time reporting, a live connection is required. The primary purpose of an extract is to improve performance and provide offline access, but this comes at the cost of data freshness, which is a key architectural trade-off.
- ✓
To improve performance and enable local access.
Why this is correct
Extracts store data locally in a highly optimized file format (.hyper). This significantly improves the speed of visualizations by reducing the reliance on external database performance. It also allows for data analysis when the original database is offline or unreachable, providing a more robust and responsive environment.
- ✗
To automatically join different data sources.
Why it's wrong here
Extracts are a storage format, not a data preparation or joining tool. While you can create extracts from combined data, the extract itself does not perform the join operation. The joining of disparate data sources is handled by the Tableau data model, regardless of whether the final output is live or extracted.
- ✗
To increase the security of the data connection.
Why it's wrong here
While extracts can be embedded within a workbook, they do not intrinsically increase security. In some cases, they might even pose a risk if sensitive data is cached locally on a user's machine without proper encryption or governance controls, so security should be managed via permissions rather than connection types.
About these practice questions
This Tableau-Desktop-Found question is part of Courseiva's 126-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.