Data Analyst Tableau practice questions
10 free questions with answers and explanations. Try each one, then tap “Show answer”.
- Data
1. A left join between Orders and Returns keeps
- A. no orders without returns
- B. only returns
- C. only returned orders
- D. all orders, with return details where they exist
Show answer
Answer: D. all orders, with return details where they exist
Unmatched returns columns are null.
- Data
2. A Tableau extract (.hyper) is
- A. a calculated field
- B. a saved snapshot of data for fast performance
- C. a dashboard
- D. a live connection
Show answer
Answer: B. a saved snapshot of data for fast performance
Live connections query the source directly.
- LOD results
3. Data: Region | Category | Amount | Units East | Toys | 300 | 3 East | Toys | 400 | 5 South | Toys | 200 | 4 South | Home | 250 | 8 South | Home | 400 | 9 East | Food | 400 | 5 For a row where Region is East, what does {FIXED [Region] : SUM([Amount])} return?
- A. 3
- B. 300
- C. 1950
- D. 1100
Show answer
Answer: D. 1100
FIXED sums Amount for all East rows: 1100.
- Publishing
4. Tableau Public workbooks are
- A. encrypted extracts
- B. only on your computer
- C. private by default
- D. saved publicly and visible to anyone
Show answer
Answer: D. saved publicly and visible to anyone
Use Tableau Cloud or Server for private sharing.
- Visuals
5. The Marks card controls
- A. colour, size, label, detail and tooltip for the marks in a view
- B. user permissions
- C. data refresh
- D. the data source
Show answer
Answer: A. colour, size, label, detail and tooltip for the marks in a view
It is central to building visuals.
- Dashboards
6. A dashboard's 'Fixed' size is useful because
- A. it can't be published
- B. it refreshes faster
- C. it hides filters
- D. the layout looks the same on every screen
Show answer
Answer: D. the layout looks the same on every screen
Automatic size can rearrange or crop content.
- Calculations
7. Which function ranks values in the view?
- A. SIZE()
- B. INDEX() only
- C. ATTR()
- D. RANK()
Show answer
Answer: D. RANK()
RANK_DENSE and RANK_UNIQUE are variants.
- Calculations
8. ZN([Sales]) returns
- A. the zone of Sales
- B. null always
- C. 0 when Sales is null, otherwise Sales
- D. the absolute value
Show answer
Answer: C. 0 when Sales is null, otherwise Sales
Useful for filling gaps in calculations.
- Visuals
9. Reference lines are used to
- A. connect data sources
- B. rename fields
- C. show averages, targets or constants on an axis
- D. filter data
Show answer
Answer: C. show averages, targets or constants on an axis
Bands and distributions are similar options.
- Fields
10. Dimensions in Tableau usually contain
- A. only numbers to aggregate
- B. only calculations
- C. colours
- D. qualitative values like names, dates or categories
Show answer
Answer: D. qualitative values like names, dates or categories
Measures contain quantitative values that are aggregated.
Get fresh questions every day, focused on your weak topics, plus timed mock tests. Free to start.
Practise free in the web app Practise on TelegramMore Data Analyst practice
About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.