Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
You are connecting to a large Excel file with 20 sheets. You need to combine data from three sheets that share the same structure into a single table. Which method is most efficient for data preparation?
⚠ Common exam trap
Candidates frequently try to use joins or relationships to combine multiple sheets with the exact same structure, leading to complex models instead of a simple vertical append.
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 the Union feature to append the sheets.
The Union feature in Tableau is designed specifically to append data from multiple tables with identical structures into a single, longer table. This is the standard approach for normalized data stored across multiple tabs. Using relationships or joins would create unnecessary complexity or data duplication, whereas unions preserve the integrity of the original structure while providing a singular set of rows for downstream analysis in your worksheets.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create a cross-database join on all three sheets.
Why it's wrong here
Joins are meant for combining disparate data sources based on shared keys. Using a join for identical table structures causes column proliferation and data duplication, which is inefficient and leads to incorrect analysis. Unions are the correct mechanism for stacking rows of data from similar table structures.
- ✗
Use the Data Interpreter to automatically merge the sheets.
Why it's wrong here
The Data Interpreter is a tool designed to clean up messy formatting in Excel files, such as subheaders or merged cells. It does not possess the functional capability to perform a union or merge operation on separate sheets, making this an inappropriate choice for combining structural data sets.
- ✓
Use the Union feature to append the sheets.
Why this is correct
The Union feature allows you to stack rows from multiple tables that share identical headers. This is the most efficient method for preparing data stored in separate sheets with the same columns, ensuring a single continuous data set for analysis without duplicating rows or requiring complex join logic.
- ✗
Create a relationship between the three sheets.
Why it's wrong here
Relationships are designed to manage data at different levels of detail while preserving the original context of each table. While useful for linking disparate tables, they are not intended for simple row-level stacking of identical structures, as they would still treat the data as distinct tables during analysis.
About these practice questions
Courseiva writes every Tableau-Desktop-Found question from scratch — 126 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.