Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
You are connecting to a large database and only need a small subset of the data based on a specific geographic region. How can you limit the amount of data brought into Tableau?
⚠ Common exam trap
Candidates confuse Data Source Filters with standard worksheet filters, failing to realize that only data source filters restrict the actual volume of data brought into the file.
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
✓
Use a Data Source Filter.
Using a Data Source Filter allows you to restrict the data at the connection level, meaning only the relevant subset is loaded into Tableau's memory. This is a critical performance optimization technique, as it prevents the unnecessary processing of large volumes of irrelevant data, resulting in faster dashboard load times and a more streamlined user experience for regional-specific reporting tasks.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a Context Filter.
Why it's wrong here
Context filters are applied at the sheet level to control the order of operations for filters on a specific visualization. They do not prevent the full data set from being loaded into memory, so they do not help with reducing the initial data load size.
- ✓
Use a Data Source Filter.
Why this is correct
Data Source Filters are applied immediately upon connection, before any data is loaded into the workbook. By filtering at the source, you reduce memory consumption and speed up query performance, which is ideal for limiting data to specific regions or time periods.
- ✗
Use a Global Filter.
Why it's wrong here
Global filters apply to multiple sheets but are still applied after the data has been loaded into the workbook. They do not reduce the amount of data being processed by the underlying data engine, providing no performance benefit for the initial data connection process.
- ✗
Use a Hide field option.
Why it's wrong here
Hiding a field only removes the column from view within the interface. It does not exclude the data from the source, meaning the entire dataset is still processed by the system. This does not help in limiting the volume of data loaded into memory.
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.