Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
You are preparing a data source and need to pivot multiple columns representing 'Month' into a single column. What is the primary requirement for this action?
⚠ Common exam trap
Candidates often think they can pivot columns with mixed data types, such as integers and strings, forgetting that the resulting pivoted column must have a single consistent data type for all rows.
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
✓
The columns must have the same data type
Pivoting is essential for reshaping wide data into tall data, which Tableau prefers for visualization. Ensuring data types are consistent is the most critical constraint because the new field generated by the pivot must hold values from all participating columns uniformly. Mastering this process is vital for converting Excel-style cross-tab data into a format that allows for flexible analysis, filtering, and aggregation in Tableau.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The columns must be adjacent in the data source
Why it's wrong here
While Tableau makes it easy to select adjacent columns, they do not strictly need to be side-by-side to perform a pivot. You can select multiple non-adjacent columns by using the Ctrl or Command key, then right-click and select Pivot to combine them into a single row-based format.
- ✓
The columns must have the same data type
Why this is correct
Pivoting requires that the selected columns share a consistent data type because the resulting single column will hold all the values from those original columns. If types differ, Tableau cannot successfully flatten them into a single coherent field without creating inconsistencies that violate database structure integrity rules.
- ✗
The data must be in a live connection
Why it's wrong here
Pivoting is a feature available in the Data Source page regardless of whether you are using an extract or a live connection. Tableau performs the pivot during the query process or extract creation, so the connection type does not restrict your ability to reshape your data accordingly.
- ✗
The columns must contain only numeric values
Why it's wrong here
Pivoting works on various data types, not just numeric ones. Whether you are pivoting string-based categories or dates, the primary requirement is consistency in the data type, not the specific nature of the content itself, to ensure the new 'Pivot Field Values' column is correctly typed.
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.