Tableau Certified Data Analyst Free Sample Questions

Description

Covers connecting to and preparing data sources, calculated and table calculation fields, building charts, dashboards and stories with interactivity, and publishing updates on Tableau Server.

20 free sample questions203 in the full practice test

Try simulator

TDA-C01 Sample Questions

  1. Question 1

    Intermediate

    Explore and Analyze Data · Create custom table calculations

    A financial services company is analyzing stock price volatility. An analyst has created a visualization showing daily stock prices. To measure volatility, they need to calculate the standard deviation of the stock price over a rolling 30-day window. Which function is the most appropriate and direct way to achieve this in Tableau?

    Answer and explanation

    Correct answer: C

    The WINDOW_STDEV function is a table calculation specifically designed to compute the standard deviation over a moving window of data. The arguments (SUM([Stock Price]), -29, 0) correctly define the aggregation and the window, which includes the current day and the 29 preceding days, making a 30-day rolling period. STDEV() is a regular aggregation and calculates the standard deviation for the entire partition. The FIXED LOD would calculate the standard deviation for each stock ticker across all time, not a rolling window.

  2. Question 2

    Beginner

    Connect to and Transform Data · Connect to data sources

    A marketing team uses Tableau to analyze campaign performance. They have a data source that is updated daily with new performance metrics. The team has a critical dashboard that must always show the latest data with minimal latency. The underlying database is a high-performance analytical database (e.g., Snowflake, Google BigQuery) optimized for fast queries. Which data connection type should be used for the data source to meet these requirements?

    Answer and explanation

    Correct answer: B

    A live connection queries the underlying database directly. This is the ideal choice when data freshness is critical and the database is performant enough to handle the query load from dashboard interactions. An extract, even if refreshed frequently, introduces latency as it is a snapshot of the data. A published data source on Tableau Server still requires a connection type, and a data blend is for combining different data sources, not for ensuring data freshness.

  3. Question 3

    AdvancedMultiple answers

    Explore and Analyze Data · Create and use filters

    An analyst is building a dashboard to compare the sales performance of different product categories. They want to allow users to dynamically select a category and see its sales trend line compared against the average sales trend of all other categories. Which features must be combined to achieve this interactivity? (Select TWO)

    Answer and explanation

    Correct answers: B, D

    Sets are necessary to group the selected category ('IN' the set) versus all other categories ('OUT' of the set). This grouping is fundamental to creating the two separate trend lines.

    Set Actions provide the interactivity, allowing a user's click or selection on the dashboard to dynamically change the members of the set. This action will drive which category is considered 'selected' for the comparison.

  4. Question 4

    Intermediate

    Publish and Manage Content on Tableau Server and Tableau Online · Publish content

    True or False: When you publish a workbook to Tableau Server with a live connection to a database that uses integrated authentication (e.g., Windows Authentication), you must configure a Run As User account on Tableau Server to enable successful data source access for all users.

    Answer and explanation

    Correct answer: A

    This is true. Tableau Server itself cannot use the credentials of the viewing user to connect to a data source that requires integrated authentication. Instead, an administrator must configure a specific 'Run As User' account. This account has the necessary permissions to the database, and Tableau Server will use this single account for all queries to that data source, acting on behalf of the end-users.

  5. Question 5

    Beginner

    Connect to and Transform Data · Perform data transformation in Tableau Prep

    A data analyst for a large e-commerce company is tasked with creating a Tableau Prep flow to clean and prepare sales data. The raw data comes from two different systems. One system provides order details in a CSV file where each row is a line item, including OrderID, ProductID, and Quantity. The other system provides product information in a separate CSV, including ProductID, ProductName, and Category. The goal is to produce a single, clean output file containing OrderID, ProductName, Category, and Quantity for all orders.

    The analyst builds a Tableau Prep flow. They add an Input step for the order details CSV and another Input step for the product information CSV. To combine the two data streams, they need to add another step. Which Tableau Prep step should the analyst use to correctly combine the product names and categories with their corresponding order line items?

    Answer and explanation

    Correct answer: D

    A Join step is used to combine data from two tables based on a common field. In this case, both the order details and product information tables contain the ProductID field. By joining on this common field, the analyst can append columns from the product table (like ProductName and Category) to the rows of the order details table, creating the desired wide-format output. A Union stacks rows on top of each other, which is incorrect here.

  6. Question 6

    Advanced

    Connect to and Transform Data · Prepare data for analysis

    Company Background:
    Global Logistics Inc. (GLI) manages a worldwide shipping network. They track shipments, carrier performance, and delivery times. Data is stored in a central data warehouse. Analysts at GLI use Tableau to monitor key performance indicators (KPIs) and identify bottlenecks in their supply chain.

    Current Situation:
    A senior analyst has been asked to create a new executive dashboard focused on carrier performance. The primary data source is a large, non-normalized table containing millions of shipment records. This table includes fields like CarrierName, OriginCity, DestinationCity, ShipmentDate, DeliveryDate, and ShipmentCost. A key requirement is to calculate the average delivery time for each carrier.

    Technical Challenge:
    The ShipmentDate and DeliveryDate fields include weekends and company holidays, but the business requirement is to calculate the average delivery time in business days only. The company maintains a separate table in the data warehouse named CompanyHolidays which lists all non-working dates. The analyst needs to incorporate this holiday list and exclude weekends from the delivery time calculation within Tableau.

    Question:
    Which approach is the most efficient and scalable for calculating the average delivery time in business days, correctly accounting for both weekends and the custom holiday list?

    Answer and explanation

    Correct answer: D

    This is the most robust solution. By performing a left join in the data source pane with a non-equi join condition (HolidayDate >= ShipmentDate AND HolidayDate <= DeliveryDate), you can identify all holidays that fall within a shipment's transit time. The DATEDIFF('weekday', ...) function correctly calculates the number of weekdays between two dates. Finally, subtracting the distinct count of holidays (COUNTD([HolidayDate])) from the weekday count gives the precise number of business days. This approach offloads the complex logic to the database layer and is more scalable than complex IF statements or data blending for this row-level task.

  7. Question 7

    Intermediate

    Explore and Analyze Data · Create quick table calculations

    An analyst needs to create a view that shows the percentage of total sales for each product Sub-Category within its parent Category. For example, they want to see that 'Chairs' account for X% of 'Furniture' sales, and 'Phones' account for Y% of 'Technology' sales. Which type of calculation is best suited for this requirement?

    Answer and explanation

    Correct answer: C

    When Category and Sub-Category are placed on the shelves (e.g., Rows), Tableau partitions the view into 'panes' for each Category. A quick table calculation for 'Percent of Total' with its scope set to 'Pane' will calculate the sum of sales for each Sub-Category as a percentage of the total sales within its pane (i.e., its parent Category). 'Table (Across)' would calculate the percentage based on the grand total for the entire table. An LOD would also work, but the table calculation is more direct for this specific visual layout.

  8. Question 8

    Beginner

    Create Content · Add interactivity to dashboards

    A Tableau user has created a dashboard with four different worksheets. They want to add a single filter for 'Region' that simultaneously filters all four worksheets on the dashboard. How can this be achieved most efficiently?

    Answer and explanation

    Correct answer: B

    The most efficient method is to add the filter from one of the worksheets to the dashboard. Then, by accessing the filter's context menu (the dropdown arrow), you can specify its scope. Choosing 'All Using This Data Source' will make this single filter control every other worksheet on the dashboard that is built from the same data source. This avoids creating redundant filters or complex filter actions.

  9. Question 9

    Intermediate

    Explore and Analyze Data · Create and use filters

    An analyst is troubleshooting a dashboard's performance. They suspect that the order in which filters are being applied is causing issues. The dashboard contains an extract filter, a data source filter, a dimension filter set to 'Context', and a standard dimension filter. Which diagram correctly illustrates the order in which Tableau applies these filters?

    graph TD A[Start] --> B(Extract Filter) B --> C(Data Source Filter) C --> D(Context Filter) D --> E(Dimension Filter) E --> F[View]

    Answer and explanation

    Correct answer: A

    The diagram accurately represents Tableau's filter order of operations. Filters are applied sequentially from the broadest to the most specific. Extract filters are applied first when the extract is created. Data source filters are next, restricting data at the source level. Context filters create a temporary table that all subsequent filters run against, so they come next. Finally, standard dimension filters are applied before the view is rendered.

  10. Question 10

    IntermediateMultiple answers

    Create Content · Create dashboards and stories

    A consultant is designing a mobile-first dashboard for sales representatives who will view it on their phones. Which of the following design choices are considered best practices for mobile dashboard design in Tableau? (Select THREE)

    Answer and explanation

    Correct answers: A, B, D

    Mobile users are accustomed to scrolling. A single vertical layout is easier to navigate on a small screen than a wide, multi-column layout.

    To provide information quickly, key metrics and summaries should be visible without requiring the user to scroll down.

    Screen real estate is limited on mobile devices. Minimizing filters and making the controls larger (e.g., single value lists instead of compact lists) improves usability.

Register free for 10 more questions

Or unlock all 203 TDA-C01 questions with explanations, timed mode and flashcards.