Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
You have a dataset where each row represents a student's final grade in a class. You want to calculate the average grade per department, but you discover that the data is at the individual student level. What is the most efficient way to prepare this for your view?
⚠ Common exam trap
Candidates often create a calculated field using an LOD expression or a fixed calculation, not realizing that simply changing the measure aggregation to 'Average' is the most efficient, native solution.
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 default aggregation 'Average' within the view.
Tableau's aggregation capabilities allow you to perform calculations like averages at any level of detail without needing to pre-aggregate the data. By simply dragging the 'Grade' measure onto the view and selecting the 'Average' aggregation, Tableau handles the math dynamically. This is the most efficient approach because it maintains the granularity of the underlying data for further exploration or drill-downs.
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 new table in the source database containing averages.
Why it's wrong here
Creating pre-aggregated tables is unnecessary and creates maintenance overhead. Tableau's engine is designed to handle aggregations on the fly. Modifying the source database specifically for a single visualization is a poor practice that limits the flexibility of your analysis and consumes unnecessary resources.
- ✗
Use the 'Group' function to combine student grades.
Why it's wrong here
Grouping is for creating custom categories or combining dimension members, not for performing mathematical aggregations like averaging student grades. While it might visually bundle students, it does not provide the numerical 'Average' calculation that is required for the analytical requirement mentioned.
- ✓
Use the default aggregation 'Average' within the view.
Why this is correct
Tableau is built to aggregate data dynamically based on the dimensions in the view. By using the default 'Average' aggregation on the measure, you let Tableau perform the calculation based on the department dimension, which is the most efficient and standard way to handle this requirement.
- ✗
Use an LOD expression to fix the average for each student.
Why it's wrong here
An LOD expression like {FIXED [Student] : AVG([Grade])} would calculate the average grade for each student, but that is not the goal. The goal is to calculate the average per department, and using an LOD for this would be unnecessarily complex compared to simple aggregation.
About these practice questions
One of 126 original Tableau-Desktop-Found practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.