Tableau Certified Data Analyst Practice Exam

What the Tableau Certified Data Analyst exam covers

• Connect to and Transform Data178 questions
• Explore and Analyze Data303 questions
• Create Content192 questions
• Publish and Manage Content on Tableau Server and Tableau Online67 questions

Free Tableau Certified Data Analyst sample questions

A sample of 10 questions with answers and explanations. Sign up free to practice all 740.

1. Question 1Explore and Analyze Data

   An analyst wants to create a new field that divides Sales by Quantity for every order line. Where do they build this?

   • AUse a quick table calculation on the Sales pill
   • BAdd a reference line for Sales divided by Quantity
   • CCreate a parameter and set its value to Sales/Quantity
   • DCreate a calculated field with the formula [Sales]/[Quantity]Correct
   ✓ Correct answer: D

   Calculated fields are created from the Data pane (right-click > Create > Calculated Field) or the Analysis menu, and support arithmetic directly on database fields. Since Sales and Quantity are both row-level here, the result is a row-level calculation that Tableau will aggregate later depending on the view.

   Why the other options are wrong

   • ATable calculations operate on values already in the view (like running totals), not on raw database fields.
   • BReference lines annotate a chart with a statistical line; they do not create a reusable field.
   • CParameters hold a single input value a user controls; they cannot reference two data fields to divide row by row.
2. Question 2Explore and Analyze DataSelect all that apply

   An analyst wants users to choose, via a parameter, whether a bar chart of Sub-Categories sorts by Sales or by Profit. Which two components are required? (Choose TWO)

   • AA context filter set to the parameter's current value
   • BA string parameter listing the sort options, such as "Sales" and "Profit"Correct
   • CA dual-axis chart combining both measures on separate axes
   • DA FIXED LOD expression with an empty dimension list
   • EA CASE calc on the parameter, returning Sales or Profit to drive the sortCorrect
   ✓ Correct answer: B, E

   The parameter gives the user-facing toggle between "Sales" and "Profit", while the CASE calculated field evaluates that choice and returns the corresponding measure's value, which is then used to control the sort order of Sub-Category on the chart.

   Why the other options are wrong

   • AA context filter changes which rows are included in the view; it does not control how the chart is sorted.
   • CA dual-axis chart displays both measures simultaneously rather than letting the user choose one to sort by.
   • DAn LOD expression fixes a level of aggregation and has no role in enabling a dynamic sort toggle.
3. Question 3Explore and Analyze Data

   Where does an analyst go to edit the Compute Using setting or add a nested calculation for a table calculation already placed in the view?

   • ARight-click the pill in the view, choose Edit Table CalculationCorrect
   • BRight-click the worksheet tab, choose Edit Table Calculation
   • COpen the Data Source page, click the field's data type icon
   • DRight-click the Marks card, choose Format
   ✓ Correct answer: A

   Right-clicking the table calculation's field pill wherever it sits in the view and selecting Edit Table Calculation opens the dialog for Compute Using, quick calculation type, and any nested calculation settings.

   Why the other options are wrong

   • BThe worksheet tab's right-click menu offers sheet-level actions like renaming or duplicating, not table calculation editing.
   • CThe Data Source page controls field data types and table joins, not a view's table calculation settings.
   • DThe Marks card's Format option controls formatting of marks, not the logic of a table calculation.
4. Question 4Explore and Analyze Data

   An analyst sets the bin size for Profit to 100, but the resulting histogram has too many thin bars to read clearly. What should they do?

   • ASwitch the measure to a discrete blue pill instead
   • BDelete the bin field and use a group instead
   • CAdd a trend line to smooth the bars
   • DIncrease the bin size so each bucket spans a wider rangeCorrect
   ✓ Correct answer: D

   Editing the bin and increasing its size makes each numeric bucket span a wider range of Profit values, which reduces the number of bars in the histogram and makes it easier to read.

   Why the other options are wrong

   • AMaking the measure discrete does not change the bin width or reduce the number of bars.
   • BA group manually merges specific labels; it is not a substitute for adjusting numeric bin width.
   • CA trend line fits a regression model, it does not change how many histogram bars are shown.
5. Question 5Explore and Analyze Data

   An analyst notices Order Date values are being parsed in month-day-year order, causing dates like 03/04/2024 to be read as March 4th rather than April 3rd. Which setting controls this parsing behavior for a text-based date field?

   • AThe field's date format or locale settingCorrect
   • BThe Context Filters shelf setting
   • CThe Fiscal Year Start property only
   • DThe Show Filter toggle option
   ✓ Correct answer: A

   When Tableau converts a text field to a date, the interpretation of ambiguous formats like 03/04/2024 depends on the data source's locale and the date format applied via Change Data Type or a custom date format, which the analyst can adjust to correctly parse day versus month order.

   Why the other options are wrong

   • BContext filters restrict which rows are used; they do not affect date parsing.
   • CFiscal Year Start affects which month a fiscal year begins, not day/month parsing order.
   • DShow Filter only controls whether a filter card is displayed.
6. Question 6Connect to and Transform DataSelect all that apply

   Which TWO statements correctly describe the physical layer of the Tableau data model? (Choose TWO)

   • AIt is where tables are combined using joinsCorrect
   • BIt is where data sources are combined with an orange linking icon
   • CIt is accessed by opening (double-clicking) a logical table boxCorrect
   • DIt always requires a live connection, never an extract
   • EIt is where dashboard filter actions are configured
   ✓ Correct answer: A, C

   The physical layer sits inside each logical table and is where individual tables are joined together; an analyst reaches it by double-clicking a logical table box on the canvas.

   Why the other options are wrong

   • BThat describes data blending, which is a worksheet-level concept, not the physical layer.
   • DThe physical layer works with either live connections or extracts, not only live.
   • EDashboard filter actions are a dashboard-level feature unrelated to the data model layers.
7. Question 7Connect to and Transform Data

   A field stores product codes with inconsistent spacing, like ' ABC123' and 'ABC123 '. Which function removes the leading and trailing spaces?

   • ALEFT([Product Code], 6), fixed length
   • BSPLIT([Product Code], ' ', 1), first token
   • CTRIM([Product Code]), strips whitespaceCorrect
   • DREPLACE([Product Code], 'ABC', ''), strip text
   ✓ Correct answer: C

   TRIM() is purpose-built to strip leading and trailing spaces from a string, without needing to know the field's length or content, making it the reliable choice for cleaning inconsistent spacing.

   Why the other options are wrong

   • ALEFT with a fixed length would cut off valid characters if the code length varies, and doesn't address trailing spaces reliably.
   • BSPLIT on a space would break apart codes that legitimately contain no delimiter, and doesn't specifically target leading/trailing whitespace.
   • DREPLACE targets a specific substring like 'ABC', it does not generically remove whitespace.
8. Question 8Create Content

   An analyst drags Profit, a measure, onto Color and notices a gradient legend rather than distinct swatches. What does this indicate?

   • AThe field was converted to a dimension
   • BThe field is continuous, producing a gradientCorrect
   • CThe mark type is set to Density
   • DA context filter is active on the view
   ✓ Correct answer: B

   When a continuous (green) field drives Color, Tableau renders a gradient scale from low to high values instead of a set of distinct swatches, which only appear for discrete fields. This behavior is unrelated to the mark type or any active filter.

   Why the other options are wrong

   • AThe field's role as measure or dimension did not change; it simply remains continuous.
   • CThe Density mark type is a separate setting and does not by itself explain a gradient legend.
   • DA context filter changes which data is included, not whether the Color legend is a gradient.
9. Question 9Create Content

   Which dashboard object is used to place a company logo or other static picture file onto a dashboard?

   • AExtension
   • BNavigation
   • CImageCorrect
   • DWeb Page
   ✓ Correct answer: C

   The Image object lets an analyst insert a saved picture file, such as a company logo, and optionally link it to a URL. A Web Page object shows a live external page rather than a static file, a Navigation object is a button that jumps between sheets, and an Extension embeds an interactive application.

   Why the other options are wrong

   • AAn Extension embeds an interactive web application, not a static picture.
   • BA Navigation object is a clickable button for moving between sheets or dashboards.
   • DA Web Page object renders a live webpage, not a locally inserted picture file.
10. Question 10Create Content

    A worksheet's Caption, the text element shown beneath the view, is best described as which of the following?

    • AA required element that can never be hidden at all
    • BText with inserted fields that updates as filters changeCorrect
    • CAn annotation anchored to the first mark drawn in the view
    • DA fixed piece of text that can never include a field reference
    ✓ Correct answer: B

    Like the worksheet title, the Caption supports the Insert menu for field references, so its wording can update automatically to reflect the current filter or selection state. It is not restricted to static text, is not anchored to any single mark, and can be shown or hidden via the Worksheet menu's Show Caption option.

    Why the other options are wrong

    • AShow Caption can be toggled off from the Worksheet menu, so it is not a mandatory element.
    • CThe Caption is a workbook-level text element under the view, not an annotation tied to a mark.
    • DThe Caption fully supports inserted field references, just like the Title does.

Who this Tableau Certified Data Analyst practice exam is for

This practice set is for anyone preparing for the Tableau Certified Data Analyst exam at the intermediate level - from first-time candidates building a foundation to experienced Data practitioners doing a final review before test day. If you learn best by working through realistic questions and reading why each answer is right or wrong, it is built for you.

How to use this Tableau Certified Data Analyst practice exam

1. Start with the free sample questions above to gauge your current baseline.
2. Read the full explanation on every question, including why each wrong option is wrong.
3. Track your weak domains and focus your study where you are losing the most marks.
4. Once you are scoring consistently well, take a timed, full-length mock exam.
5. Use your readiness score to decide when you are ready to book the real Tableau Certified Data Analyst exam.

Related Data resources

• Tableau Certified Data Analyst study guideKey concepts
• Data practice examsAll Data
• Certification pathWhere this fits
• Certification exam guides & tipsBlog
• Plans & pricingFree & paid
• MongoDB Associate Developer practice examRelated
• Databricks Certified Data Engineer Associate practice examRelated
• Databricks Certified Machine Learning Associate practice examRelated

Tableau Certified Data Analyst practice exam FAQ