Tableau Quiz: Reducing Marks For Performance
10 questions · exam conditions
0:00
Reducing Marks For PerformanceQuestion 1 of 10

A worksheet shows monthly sales by region. The view contains 24 months and 4 regions. Customer ID is also placed on Detail, and each of 500 customers has sales in every region-month combination. The business needs only one aggregated sales mark for each region and month.

Which change most directly reduces the number of marks while preserving the required view, and approximately how many marks remain?

Remove Customer ID from Detail; approximately 24×4=9624 \times 4 = 96 marks remain.
Convert Customer ID to a discrete field; approximately 24×4=9624 \times 4 = 96 marks remain.
Hide the Customer ID header; approximately 24×4×500=48,00024 \times 4 \times 500 = 48{,}000 marks remain.
Change the mark type to Circle; approximately 24×4×500=48,00024 \times 4 \times 500 = 48{,}000 marks remain.
← Back to quizzes

Tableau Quiz

Tableau Quiz: Reducing Marks For Performance

Practice Reducing Marks For Performance in Tableau with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Reducing Marks For Performance, giving you a quick way to practice the rules, question types, and explanations that matter most for Tableau.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

A worksheet shows monthly sales by region. The view contains 24 months and 4 regions. Customer ID is also placed on Detail, and each of 500 customers has sales in every region-month combination. The business needs only one aggregated sales mark for each region and month.

Which change most directly reduces the number of marks while preserving the required view, and approximately how many marks remain?

  1. Remove Customer ID from Detail; approximately 24×4=9624 \times 4 = 96 marks remain. (correct answer)
  2. Convert Customer ID to a discrete field; approximately 24×4=9624 \times 4 = 96 marks remain.
  3. Hide the Customer ID header; approximately 24×4×500=48,00024 \times 4 \times 500 = 48{,}000 marks remain.
  4. Change the mark type to Circle; approximately 24×4×500=48,00024 \times 4 \times 500 = 48{,}000 marks remain.
Explanation: Whenever you see a question about marks in Tableau, remember the core rule: the number of marks equals the number of distinct combinations of fields on your Shelves (Rows, Columns, Color, Size, Shape, Detail, Tooltip). Detail is particularly tricky — it granularizes marks without visually encoding anything obvious, so students often overlook it as a source of mark inflation. Here, Customer ID on Detail forces Tableau to draw one mark per unique Customer ID per region-month combination: 24×4×500=48,00024 \times 4 \times 500 = 48{,}000 marks. The business only needs 24×4=9624 \times 4 = 96 aggregated marks. The most direct fix is simply removing Customer ID from the Detail shelf entirely. Without it, Tableau aggregates sales to the region-month level, leaving exactly 9696 marks — one per cell. That's answer A, and it's correct. Answer B is wrong because converting Customer ID to a discrete field changes how it's displayed (as a header rather than a continuous axis), but it does not remove it from the view. The field still granularizes marks, so you still get 48,00048{,}000 marks. Answer C is wrong because hiding a header is purely cosmetic — it affects what the viewer sees in the headers, not how Tableau computes marks. The 48,00048{,}000 marks remain in the view; they're just unlabeled. Answer D is wrong for the same cosmetic reason. Changing the mark type (Bar → Circle, etc.) never changes mark count; it only changes visual representation. Study tip: On Tableau exam questions, always trace every field in the view — especially Detail — when asked about mark count. Detail is the most common hidden culprit for unexpected mark inflation.

Question 2

A five-year sales trend uses Exact Date on Columns as a continuous field and contains one mark for every day. Users have confirmed that they analyze only month-to-month movement and do not need daily values.

Which modification is most likely to reduce marks without removing information required by the users?

  1. Change Exact Date from continuous to discrete while retaining the exact-date granularity.
  2. Change Exact Date to continuous MONTH(Date) and aggregate sales at the monthly level. (correct answer)
  3. Keep Exact Date and format the axis labels so that only month names are displayed.
  4. Keep Exact Date and reduce the Size setting for the marks on the Marks card.
Explanation: When Tableau renders a view, every mark represents a row (or group of rows) at the granularity you've defined. If users only care about monthly trends, keeping daily granularity forces Tableau to render roughly 30× more marks than necessary — and that extra detail carries no analytical value for those users. The fix isn't cosmetic; it's structural: change the granularity itself. Choosing continuous MONTH(Date) — option B — collapses all daily rows within each month into a single aggregated mark, so a five-year view drops from ~1,825 marks to just 60. The trend line remains fully intact at the level users actually need, and performance improves because Tableau queries and renders far fewer data points. Option A is a trap: switching Exact Date from continuous to discrete changes how the axis is drawn (discrete headers instead of a continuous axis) but does not change granularity. You still get one mark per day — just styled differently. Option C is a purely cosmetic change: formatting axis labels to show only month names makes the chart look monthly, but all 1,825 marks are still being computed and rendered behind the scenes. Users might not see daily values, but Tableau is still doing all that work. Option D — shrinking mark size — is purely aesthetic and has zero effect on the number of marks or query load. It doesn't reduce information or processing at all. The key study takeaway: on Tableau exam questions about performance or mark reduction, always distinguish between visual changes (formatting, size, label display) and structural changes (granularity, aggregation). Only structural changes actually reduce marks and query overhead.

Question 3

A worksheet is intended to compare total sales across 12 product categories. Category is on Rows and SUM(Sales) is on Columns. Order Priority, which has five values, is on Color, creating stacked segments within each category. Stakeholders do not use priority in this worksheet.

Which change best improves performance while preserving the stated analytical purpose?

  1. Remove Order Priority from Color so that sales aggregate into one mark for each category. (correct answer)
  2. Keep Order Priority on Color but replace the five colors with a single-color palette.
  3. Move Order Priority from Color to Detail so that the segments are no longer visibly stacked.
  4. Hide the Order Priority legend while retaining the existing colored marks in the view.
Explanation: When a question asks about performance improvements, your first instinct should be to ask: what is doing unnecessary work? In Tableau, every field on a shelf forces the query engine to compute and render additional marks. More marks, more memory, more load time. Here, the stated purpose is comparing total sales across 12 categories — nothing about priority. That means Order Priority is pure overhead. Removing it entirely, as A does, collapses 60 marks (12 categories × 5 priority values) into 12 marks — one clean bar per category. The view becomes faster to query, faster to render, and fully aligned with the analytical goal. This is the correct answer. B is a visual change only. Swapping to a single-color palette doesn't eliminate the five marks per category — Tableau still computes and renders all 60 segments. Performance is unchanged. C is a subtle trap. Moving Order Priority to Detail removes the visible color stacking, but Detail still causes Tableau to disaggregate the data. You still get 60 marks; they're just unstyled. This actually preserves the performance problem while also making the view harder to read. D is the most deceptive distractor. Hiding a legend is purely cosmetic — the underlying marks and color encoding remain completely intact. No query changes, no mark reduction. This is a UI trick, not a performance fix. Study tip: On performance questions, focus on mark count reduction. Removing a field from the view entirely always outperforms cosmetic workarounds like hiding legends or changing palettes. Ask yourself: "Does this change reduce what Tableau has to compute?"

Question 4

A text view contains Region, Category, and Customer Segment on Rows, producing a mark for every existing combination. The requested summary requires only Region and Category. An analyst proposes combining all three dimensions into one discrete combined field to reduce the number of marks.

Which action actually reduces the view to the required level of detail?

  1. Create one combined Region-Category-Segment field and replace the three original dimensions with it, consolidating them into a single pill.
  2. Remove Customer Segment from the view while retaining Region and Category as the only dimensions on the Rows shelf. (correct answer)
  3. Hide the Customer Segment column headers while retaining all three dimensions on the Rows shelf.
  4. Nest Customer Segment below Category on Rows and sort segment values within each region to reorganize the display.
Explanation: Whenever you see a question about level of detail in Tableau, ask yourself: what determines the granularity of a view? The answer is the dimensions on the Rows and Columns shelves (or in the view). Every unique combination of those dimensions produces a separate mark. Reducing the level of detail means reducing the number of dimensions driving that combination. If you want Region × Category as your summary, the only reliable path is to remove Customer Segment from the view entirely — which is exactly what B does. With only Region and Category on Rows, Tableau aggregates all segment data within each Region-Category combination, giving you precisely the requested level of detail. A is a common trap: combining all three dimensions into one pill doesn't reduce granularity at all. A combined field of Region + Category + Segment still produces one mark per Region-Category-Segment combination — you've just relabeled the axis. You haven't collapsed any data. C is another misconception. Hiding column headers or members changes what's visible, not what's computed. All three dimensions still define the view's marks behind the scenes, so the level of detail remains unchanged. D involves nesting and sorting, which are purely cosmetic reorganizations. Rearranging the order of pills on the Rows shelf affects the visual hierarchy but doesn't eliminate any dimension from the view — all three combinations still exist as individual marks. Study tip: On Tableau exam questions about granularity, always trace which dimensions are active in the view. Visual tricks like hiding, combining, or reordering never change what marks Tableau actually computes — only removing a dimension does.

Question 5

A dashboard shows 20 regional panes because Region is on Rows. Each pane contains a detailed time series. Users have confirmed that they compare metrics within only one selected region at a time and do not need simultaneous regional comparison.

Which redesign most directly reduces the number of marks displayed for the intended workflow?

  1. Keep all 20 regional panes on the dashboard but hide the Region row headers to increase available plotting space.
  2. Keep Region on Rows and reduce the pane height so that more regional views can fit on the dashboard simultaneously.
  3. Remove Region from Rows and apply a single-value Region filter so the view displays only the selected region's time series. (correct answer)
  4. Move Region from Rows to Color so all 20 regional time series are drawn together in one shared pane.
Explanation: When Tableau renders a view, every data point that appears as a visual element — a line segment, a dot, a bar — counts as a mark. The more marks on screen, the heavier the rendering load and the more cluttered the experience. When a question asks you to "reduce marks for the intended workflow," think about what the user actually needs to see at one time, then eliminate everything else. Here, users only ever examine one region at a time, so the 20-pane layout is doing unnecessary work. Option C — removing Region from Rows and applying a single-value Region filter — directly solves this. With only one region's data passing through the filter, Tableau renders exactly one time series instead of twenty. Marks drop by roughly 95%, which is precisely what the workflow demands. Option A fails because hiding row headers doesn't remove any marks — it just hides labels. All 20 panes and all their data points are still rendered. Option B makes the problem worse by trying to squeeze more panes into view simultaneously, increasing visible marks rather than reducing them. Option D moves Region to Color, which collapses 20 panes into one shared pane but still draws all 20 regional time series on top of each other — the total mark count stays the same, and the view becomes harder to read, not easier. The strategic takeaway: on questions about performance or visual clarity, distinguish between hiding information (cosmetic) and filtering information (actually reducing what Tableau computes and renders). A filter changes the data scope; formatting changes only change appearance.

Question 6

A dashboard contains a scatter plot with 300,000 marks. Selecting a product segment currently highlights that segment while dimming all other marks. Users care only about the selected segment and do not need the unselected marks to remain visible for context.

Which interaction should replace highlighting to most directly reduce the marks displayed after a selection?

  1. Use a filter action that retains only records belonging to the selected product segment. (correct answer)
  2. Use a highlight action with a darker selected color and lighter unselected colors.
  3. Use a parameter action that changes the selected segment's mark size and opacity.
  4. Use a set action that colors selected members while leaving nonmembers in gray.
Explanation: When a question asks how to reduce the number of marks displayed after a selection, the key distinction is between interactions that filter data versus those that merely style it. Filtering physically removes marks from the view; styling changes their appearance while keeping all marks rendered. A filter action — answer A — is the right tool here. When a user selects a product segment, the filter action sends that value to the target sheet as a filter, removing all non-matching records entirely. With 300,000 marks in play, dropping to only the selected segment's marks dramatically reduces rendering load and eliminates the visual clutter of dimmed marks — exactly what the scenario calls for. Answer B keeps all 300,000 marks on screen; it just adjusts colors to make unselected marks lighter. This is cosmetic change, not mark reduction — the dashboard still renders every single mark. Answer C uses a parameter action to change size and opacity, which again only restyls marks rather than eliminating them. All 300,000 marks remain in the view, just smaller or more transparent. Answer D describes a set action with color encoding: selected members get one color, nonmembers get gray. Once more, every mark stays visible — the unselected marks are still there, just gray. None of B, C, or D remove marks; they only change how marks look. A useful rule of thumb: if a question mentions users don't need context from unselected data, that's a signal that filtering is preferable to highlighting or styling. On the Tableau exam, watch for "reduce marks" or "improve performance" language — those phrases almost always point toward filter actions over visual-only interactions.

Question 7

A monthly sales line chart uses a dual axis. One Marks card draws the sales line, and the second draws a circle at the same target value for every month. The target is a single constant threshold, and users do not need to interact with individual target circles.

Which redesign reduces unnecessary marks while preserving the target comparison?

  1. Reduce the target circles to the smallest Size setting and keep the dual-axis design.
  2. Synchronize the two axes and retain one target circle for every displayed month.
  3. Hide the target axis header while retaining the target circles on the second axis.
  4. Replace the target-circle axis with a constant reference line across the sales view. (correct answer)
Explanation: When a visualization contains a constant value repeated across every data point, ask yourself: does this require individual marks, or could a single visual element communicate the same thing? That question is at the heart of this redesign problem. A constant reference line in Tableau draws one horizontal line across the entire view at a fixed value — exactly what a static target threshold is. It requires no second axis, no extra Marks card, and no repeated circles. The comparison between sales and target remains perfectly clear, but the visual clutter of redundant marks disappears entirely. That makes D the right choice: it eliminates the unnecessary dual-axis structure while preserving the target comparison in the most direct way possible. The distractors each address a symptom rather than the root cause. A makes the circles smaller but keeps every single one of them — you still have N redundant marks cluttering the view, just harder to see. B synchronizes the axes, which is good practice for dual-axis charts generally, but it does nothing to reduce the number of target marks; you still have one circle per month. C hides the axis header, which is a cosmetic fix — the redundant marks and the unnecessary second axis both remain, meaning the underlying inefficiency is untouched. A useful rule of thumb for the Tableau exam: when a value is constant across all points, a reference line almost always beats repeated marks. Reference lines are built for exactly this purpose and keep your Marks cards lean. Whenever you see a dual-axis design used solely for a flat threshold, flag it as a candidate to be replaced by a reference line.

Question 8

A symbol map displays Sales by State, but ZIP Code is on Detail and State is on Color. The map therefore renders thousands of ZIP-code marks. The required output is one sales symbol for each state; ZIP-level analysis is available in another worksheet.

Which change most appropriately simplifies this map?

  1. Move ZIP Code from Detail to Tooltip so each state can list its underlying ZIP codes.
  2. Keep ZIP Code on Detail and hide the ZIP Code field from the Data pane.
  3. Keep ZIP Code on Detail and increase the symbol size until ZIP marks visually overlap.
  4. Remove ZIP Code from Detail and use State as the geographic level for the sales marks. (correct answer)
Explanation: When working with Tableau maps, the level of detail on the view determines how many marks are rendered. Every field on the Marks card — including Detail — creates a separate mark for each unique value. That's the core concept being tested here. Since ZIP Code is on Detail, Tableau draws one symbol per ZIP code, producing thousands of marks even though the goal is one mark per state. The fix is straightforward: remove ZIP Code from Detail entirely, leaving State as the sole geographic dimension. With only State driving the view, Tableau aggregates Sales to the state level and renders exactly one symbol per state — which is precisely what answer D describes. The ZIP-level analysis lives in a separate worksheet, so nothing is lost analytically. Answer A is tempting because moving ZIP Code to Tooltip feels like a clean compromise — you'd still "see" ZIP data on hover. But ZIP Code on Tooltip without being on Detail doesn't create extra marks, so if ZIP Code is still on Detail, the marks problem persists. More importantly, the solution requires removing ZIP from Detail, not relocating it elsewhere while keeping it there. Answer B is ineffective because hiding a field from the Data pane doesn't remove it from the view — the marks are still drawn, just harder to manage. Answer C is a visual patch, not a structural fix; overlapping symbols mislead the viewer and don't reduce the actual mark count. Study tip: When a Tableau question involves too many marks, always ask "what's on the Marks card?" Any field on Detail, Color, Size, Shape, or Label can inflate the mark count — removing the field is almost always the correct structural solution.

Question 9

A scatter plot contains one circle for each transaction because Transaction ID is on Detail. It renders more than one million marks. Stakeholders now require only a comparison of average discount and average sales for each product category; transaction-level distribution is no longer required.

Which revision best addresses the new requirement and the performance issue?

  1. Keep Transaction ID on Detail and lower the mark opacity so that overlapping transactions become less visually prominent.
  2. Keep Transaction ID on Detail and change the mark type from Circle to Density to visualize concentration rather than individual points.
  3. Remove Transaction ID from Detail and plot AVG(Discount) against AVG(Sales) with Product Category defining the marks. (correct answer)
  4. Keep Transaction ID on Detail and fix both axes to narrower ranges so that out-of-range transactions are excluded from the visible plot area.
Explanation: Whenever you see a question about performance and changing analytical requirements in Tableau, think about what's actually driving the mark count and whether the current view level of detail still matches the business question. The stakeholders no longer need transaction-level distribution — they want a single aggregated comparison per product category. That means Transaction ID on Detail is the root of both problems: it forces Tableau to render one mark per transaction (over a million marks), and it answers a question nobody is asking anymore. The correct fix is C: remove Transaction ID from Detail entirely, place AVG(Discount) on one axis, AVG(Sales) on the other, and put Product Category on Color or Label. Now Tableau renders only as many marks as there are product categories — likely fewer than twenty — which is fast and precisely answers the new requirement. A is wrong because lowering opacity is purely cosmetic. It makes the chart look less cluttered but does nothing to reduce the million-mark render load or aggregate the data to the category level the stakeholders actually need. B is wrong for the same root reason — keeping Transaction ID on Detail still forces Tableau to process every individual transaction. Switching to a Density mark type changes how marks are displayed, not how many rows are being computed. D is wrong and introduces a subtle data integrity problem: fixing axis ranges doesn't remove transactions from the computation — Tableau still aggregates all rows and then clips the view. You'd be hiding data without actually reducing workload or answering the category-level question. Your study tip: when a question mentions both a changed requirement and a performance problem, the right answer almost always attacks the source — the level of detail — rather than applying a visual band-aid on top of it.

Question 10

A bar chart must show the number of distinct customers in each region. The current worksheet places Region on Rows and Customer ID on Detail, generating thousands of marks. No customer-level marks need to be selected or displayed.

Which redesign best preserves the intended result while simplifying the view?

  1. Remove Customer ID from Detail and use COUNTD(Customer ID) as the measure, yielding one aggregated mark per region. (correct answer)
  2. Keep Customer ID on Detail and use COUNT(Customer ID) as the measure, yielding one counted mark per customer per region.
  3. Move Customer ID from Detail to Color so that each regional bar is segmented by individual customer.
  4. Move Customer ID from Detail to Filters and select all customers before displaying the regional bars.
Explanation: Whenever you see a question about simplifying a Tableau view while preserving an aggregated result, the core concept being tested is the difference between Detail-level granularity and aggregate measures. Placing a dimension on Detail forces Tableau to draw one mark per unique value of that dimension — so Customer ID on Detail creates thousands of individual marks, one per customer, even though you only want one bar per region. The cleanest fix is option A: remove Customer ID from Detail and instead use COUNTD(Customer ID) as the measure. COUNTD (count distinct) computes the number of unique customers per region at the aggregate level, giving you exactly one mark per region — a clean, simple bar chart showing the right number without any unnecessary granularity. Option B is tempting but flawed. Keeping Customer ID on Detail still produces one mark per customer; COUNT(Customer ID) just counts rows, and the per-mark granularity problem remains completely unsolved. Option C makes things worse, not better. Moving Customer ID to Color segments every bar into thousands of individual color slices — one per customer — creating visual chaos and preserving the same over-granulated mark structure. Option D is a common trap. Filtering to "all customers" does nothing to reduce granularity; you're still drawing customer-level marks, just with none removed. Filters control which data appears, not how it's aggregated. Study tip: On Tableau exam questions, always ask yourself: "What controls granularity?" Dimensions on Rows, Columns, Detail, and Color all increase mark count. Aggregated measures alone don't — so when you want fewer marks, remove dimensions from the view and compute the answer with an aggregate like COUNTD.