DAC Data Tools and Visualization 2 — Questions and Answers
Question 1: In Tableau, which object type is used to combine multiple worksheets and filters into a single interactive view?
- Dashboard (Correct answer)
- Story
- Workbook
- Extract
Correct answer: Dashboard
A dashboard combines multiple worksheets, filters, and objects into one interactive layout.
Question 2: Which chart type best displays the correlation between two continuous numeric variables?
- Pie chart
- Scatter plot (Correct answer)
- Gauge
- Word cloud
Correct answer: Scatter plot
A scatter plot maps two numeric variables on the X and Y axes to reveal correlation.
Question 3: In Power BI, which language is used to create calculated columns and measures?
- DAX (Correct answer)
- M
- SQL
- R
Correct answer: DAX
DAX (Data Analysis Expressions) creates calculated columns and measures in Power BI.
Question 4: What is the primary purpose of a treemap visualization?
- Show trends over time
- Show hierarchical part-to-whole relationships (Correct answer)
- Compare two variables
- Display geographic data
Correct answer: Show hierarchical part-to-whole relationships
A treemap uses nested rectangles to show hierarchical part-to-whole proportions.
Question 5: Which color practice most improves accessibility for colorblind users in dashboards?
- Using red and green together
- Relying on color alone to encode data
- Using colorblind-safe palettes with patterns or labels (Correct answer)
- Maximizing color saturation
Correct answer: Using colorblind-safe palettes with patterns or labels
Colorblind-safe palettes plus patterns or labels avoid reliance on color alone.
Question 6: In Power BI, what does Power Query (the M engine) primarily handle?
- Data transformation and cleaning during load (Correct answer)
- Rendering visuals
- Row-level security
- Publishing to the service
Correct answer: Data transformation and cleaning during load
Power Query transforms, cleans, and shapes data during the load/ETL step.
Question 7: Which visualization is most appropriate for showing a single value against a target?
- Heatmap
- KPI or gauge card (Correct answer)
- Boxplot
- Sankey diagram
Correct answer: KPI or gauge card
A KPI or gauge card shows one metric compared against a defined target.
DAC Data Tools and Visualization 2
In Tableau, which object type is used to combine multiple worksheets and filters into a single interactive view?