Tableau Desktop Certified Professional Practice Exam
Verified Questions, Correct Answers, and Detailed
Explanations for Computer Science Students||Already
Graded A+
1. Which of the following is the best way to optimize a dashboard
for performance?
A) Use multiple large images for backgrounds
B) Limit the number of quick filters and use context filters
C) Use multiple worksheets on a single dashboard
D) Enable high-resolution rendering for all views
Using too many quick filters can slow performance; context filters
reduce the data Tableau must process.
2. When creating a complex visualization, which is a key principle of
effective design?
A) Use as many colors as possible
B) Simplify the view and focus on the story
C) Always use 3D charts for impact
D) Avoid using calculated fields
Clarity and focus are essential for professional dashboards;
overcomplicating visualizations confuses the user.
3. What is the most efficient method to handle large datasets in
Tableau?
A) Import all data into Tableau without aggregation
B) Use full outer joins for all tables
C) Use extracts and aggregate data at the source
D) Always blend data instead of joining
Extracts and pre-aggregation reduce the amount of data Tableau
processes, improving performance.
,4. You need to display sales trends by product category over time,
but also show the proportion of total sales. Which chart type is
best?
A) Bar chart
B) Scatter plot
C) Dual-axis chart with line and area
D) Pie chart
Dual-axis charts allow combining trend lines with proportion areas,
conveying both absolute and relative values.
5. Which calculation type is necessary for comparing each month’s
sales to the previous month?
A) Row-level calculation
B) Table calculation
C) Aggregate calculation
D) LOD expression
Table calculations like LOOKUP() or PREVIOUS_VALUE() are designed
for relative comparisons across rows.
6. You want to filter a dashboard based on a selection from one
sheet and have it affect multiple sheets. Which feature should you
use?
A) Parameter
B) Dashboard action filter
C) Context filter
D) Data blending
Dashboard action filters allow interactive filtering across multiple
views on a dashboard.
7. Which type of join can result in duplicated data if not handled
carefully?
A) Inner join
B) Left join
, C) Full outer join
D) Union
Left joins can duplicate rows if the right table has multiple matches
for a single row in the left table.
8. How can you handle null values in a calculation to avoid errors?
A) Ignore them
B) Use ISNULL() or ZN() functions
C) Use IFNULL() or ZN() functions
D) Convert to strings
IFNULL() replaces nulls with a specified value, and ZN() converts nulls
to zero, preventing calculation errors.
9. What is the main difference between a dimension and a
measure?
A) Dimensions are numeric
B) Measures are categorical
C) Dimensions categorize data; measures are aggregated values
D) There is no difference
Dimensions segment data, while measures are numeric values that
can be aggregated (SUM, AVG, etc.).
10. You want a parameter to dynamically switch between sales,
profit, and quantity on a chart. Which Tableau feature should you
use?
A) Calculated field with IF or CASE
B) Context filter
C) Quick filter
D) Parameter with calculated field
Parameters alone cannot change measures; combining them with
calculated fields allows dynamic measure switching.
11. When combining multiple data sources, which method allows
combining data at the row level?
Verified Questions, Correct Answers, and Detailed
Explanations for Computer Science Students||Already
Graded A+
1. Which of the following is the best way to optimize a dashboard
for performance?
A) Use multiple large images for backgrounds
B) Limit the number of quick filters and use context filters
C) Use multiple worksheets on a single dashboard
D) Enable high-resolution rendering for all views
Using too many quick filters can slow performance; context filters
reduce the data Tableau must process.
2. When creating a complex visualization, which is a key principle of
effective design?
A) Use as many colors as possible
B) Simplify the view and focus on the story
C) Always use 3D charts for impact
D) Avoid using calculated fields
Clarity and focus are essential for professional dashboards;
overcomplicating visualizations confuses the user.
3. What is the most efficient method to handle large datasets in
Tableau?
A) Import all data into Tableau without aggregation
B) Use full outer joins for all tables
C) Use extracts and aggregate data at the source
D) Always blend data instead of joining
Extracts and pre-aggregation reduce the amount of data Tableau
processes, improving performance.
,4. You need to display sales trends by product category over time,
but also show the proportion of total sales. Which chart type is
best?
A) Bar chart
B) Scatter plot
C) Dual-axis chart with line and area
D) Pie chart
Dual-axis charts allow combining trend lines with proportion areas,
conveying both absolute and relative values.
5. Which calculation type is necessary for comparing each month’s
sales to the previous month?
A) Row-level calculation
B) Table calculation
C) Aggregate calculation
D) LOD expression
Table calculations like LOOKUP() or PREVIOUS_VALUE() are designed
for relative comparisons across rows.
6. You want to filter a dashboard based on a selection from one
sheet and have it affect multiple sheets. Which feature should you
use?
A) Parameter
B) Dashboard action filter
C) Context filter
D) Data blending
Dashboard action filters allow interactive filtering across multiple
views on a dashboard.
7. Which type of join can result in duplicated data if not handled
carefully?
A) Inner join
B) Left join
, C) Full outer join
D) Union
Left joins can duplicate rows if the right table has multiple matches
for a single row in the left table.
8. How can you handle null values in a calculation to avoid errors?
A) Ignore them
B) Use ISNULL() or ZN() functions
C) Use IFNULL() or ZN() functions
D) Convert to strings
IFNULL() replaces nulls with a specified value, and ZN() converts nulls
to zero, preventing calculation errors.
9. What is the main difference between a dimension and a
measure?
A) Dimensions are numeric
B) Measures are categorical
C) Dimensions categorize data; measures are aggregated values
D) There is no difference
Dimensions segment data, while measures are numeric values that
can be aggregated (SUM, AVG, etc.).
10. You want a parameter to dynamically switch between sales,
profit, and quantity on a chart. Which Tableau feature should you
use?
A) Calculated field with IF or CASE
B) Context filter
C) Quick filter
D) Parameter with calculated field
Parameters alone cannot change measures; combining them with
calculated fields allows dynamic measure switching.
11. When combining multiple data sources, which method allows
combining data at the row level?
