VendorsExamsEnterprise
Support
Request an ExamContact UsFAQ
Tableau

Tableau Certified Data Analyst Free Sample Questions

Create a free account to browse all 20 sample questions. The full practice test includes 203 questions. Use the simulator for timed and flashcard mode.

Try Simulator

TDA-C01 Sample Questions

  1. Q1

    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?

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  2. Q2

    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?

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  3. Q3Multiple answers

    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)

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  4. Q4

    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.

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  5. Q5

    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?

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  6. Q6

    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?

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  7. Q7

    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?

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  8. Q8

    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?

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  9. Q9

    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]

    Show answer & 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.

    Timed and flashcard mode in the Simulator
  10. Q10Multiple answers

    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)

    Show answer & 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.

    Timed and flashcard mode in the Simulator

Register free to unlock 10 more sample questions

Create a free account to continue with the rest of the TDA-C01 sample set.

Lifetime One

Own this practice test forever.

$79.99
$75.99
one-time
  • Full access to 203 questions
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • Brainy AI Assistant
  • Lifetime updates

Two

Any 2 exams per month.

$20.00/exam
$39.99
/month
  • 2 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 1,000 Brainy AI Credits
  • Cancel anytime
Popular

Pro Four

Any 4 exams per month.

$17.50/exam
$69.99
/month
  • 4 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 5,000 Brainy AI Credits
  • Dedicated support

Premium Twelve

Any 12 exams over 3 months.

$15.00/exam
$179.99
/3 months
  • 4 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 15,000 Brainy AI Credits
  • Dedicated support
  • Friend seat included — full access

Trusted by professionals at

NvidiaSupabaseGitHubOpenAITursoClerkClaude AIAmazon