Free TDA-C01 Sample Questions — Tableau Certified Data Analyst

A Data Analyst is creating a map that includes multiple data layers at country, state, and city levels. Users want to customize their map by turning layers on and off as needed. How should the analyst provide this functionality?

• A. Add a parameter to toggle layer visibility
• B. Use dual-axis maps to overlay different layers
• C. Enable the Layer Control in the Map Options
• D. Use the Filter shelf to allow users to filter layers

A Data Analyst decides to add custom shapes to some key performance indicators (KPIs) in order to indicate their performance. How should the analyst make the custom shapes available in a workbook?

• A. Drag and drop the shapes into the Tableau workbook
• B. Copy the new shapes to the Shapes directory in My Tableau Repository
• C. Add the URL to the shapes in the Workbook Format menu
• D. Copy the new shapes to the Shapes directory in My Tableau Prep Repository

You have a Tableau workbook that contains three worksheets named Sheet1, Sheet2, and Sheet3. You create several filters. From the Data Source page, you plan to add data source filters. Which type of filter will appear in the Edit Data Source Filters dialog box?

• A. context filter on a dimension in Sheet3
• B. table calculation filter used on Sheet2
• C. top N condition filter on a dimension in Sheet1 and Sheet2
• D. dimension filter on all the sheets

You have a data source that contains 20 tables. You want the tables to be organized within the Data pane based on the type of data contained within the tables. What should you use?

• A. Groups
• B. Hierarchies
• C. Sets
• D. Folders

A Data Analyst plans to add a top N filter. Which field type should the analyst use to filter by in the top N filter?

• A. discrete dimension
• B. continuous measure
• C. table calculation
• D. set

A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region. Which calculation should the analyst use to do this?

• A. {FIXED (State): SUM([Sales])
• B. {FIXED [Region]: TOTAL([Sales])}
• C. {FIXED [State], [Region]: SUM([Sales])}
• D. {FIXED [Region]: SUM{[Sales])}

A Data Analyst applied a dimension filter to a worksheet with FIXED Level of Detail (LOD) calculations. How does this filter affect the worksheet?

• A. The dimension filter alters the data displayed in the worksheet along with the FIXED LOD calculation
• B. The dimension filter alters the data displayed in the worksheet before computing the FIXED LOD calculation
• C. The dimension filter is carried out first before computing the FIXED LOD calculation
• D. The dimension filter alters the data displayed in the worksheet but does not influence the FIXED LOD calculation

A Data Analyst has a Tableau workbook with multiple worksheets. The analyst created several filters on those sheets. From the data source page, the analyst plans to add additional data source filters. Which type of filter appears automatically in the Edit Data Source Filters dialog box?

• A. All filters that were applied to all worksheets using the data source
• B. All table calculation filters
• C. All dimension filters
• D. All context filters any filters that were applied to all worksheets

A Data Analyst is using containers on a dashboard. How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?

• A. Float the objects and manually adjust the size
• B. Use the distribute evenly option
• C. Use the Layout tab to set the size of each object
• D. Adjust the size of each object individually

A colleague provides you with access to a folder that contains the following files: • Sales.csv • Book1.json • Sales.tds • Export.mdb Which file contains an extract?

• A. Sales.csv
• B. Export.mdb
• C. Book1.json
• D. Sales.tds

From Tableau Desktop, you sign in to a Tableau Server site. What appears in the list of available data sources when you search for a published data source?

• A. All the data sources published to the Tableau Server
• B. All the data sources published to the site within the folders to which you have access
• C. All the data sources published to the Tableau Server within the folders to which you have access
• D. All the data sources published to the site

A colleague provides a Data Analyst with access to a folder that has the following files. • Sales.csv • Book1.json • Sales.tds • Export.mdb Which file can contain information for connecting to an external data source, such as an SQL Server database?

• A. Sales.tds
• B. Sales.csv
• C. Book1.json
• D. Export.mdb

A Data Analyst is creating a new dashboard. The analyst needs to add a button to the dashboard that allows users to export the dashboard as an image. Which type of object should the analyst use?

• A. Navigation
• B. Download
• C. Image
• D. Extension

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database. You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public. What are two ways to ensure that all the users can view the worksheets in the workbook? (Choose two.)

• A. Remove all the data source filters before you publish
• B. Configure the local file permissions to the workbook file and then publish the workbook
• C. Export the data to a csv before you publish
• D. Change the data source to an extract before you publish
• E. Embed the credentials when you publish the workbook

You have a workbook that connects to a database. The database requires authentication. You plan to publish the workbook and schedule a daily refresh of the data. Which two conditions must be met to schedule the refresh? (Choose two.)

• A. The data must be extracted
• B. The data source must use a live connection
• C. The data source must be stored as a hyper file
• D. The credentials must be embedded

A Data Analyst is frequently asked to report on events that have a single row per day but may have missing days in the dataset. The analyst needs to fill the gaps in the data between two dates. What should the analyst use to do this in Tableau Prep?

• A. Union
• B. Pivot
• C. Aggregate
• D. Now Rows

A Data Analyst needs to calculate the first Tuesday of each month in the data. Which set of functions should the analyst use to perform this calculation?

• A. DATETRUNC, DATEPART
• B. DATEADD, DATENAME
• C. DATEDIFF, DATEPART
• D. DATETRUNC, DATEADD

You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00. You need to ensure that the extract also refreshes on the last day of the month at 18:00. What should you do?

• A. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh
• B. From Tableau Server, select Schedules, and change the priority of the existing schedule
• C. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule
• D. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month

Which series of functions contains only string functions?

• A. MIN, CONTAINS, LEN
• B. PROPER, CEILING, COUNT
• C. FIND, DATEADD, NOW
• D. LEFT, FIRST, LAST

What should a Data Analyst use to visualize the distribution and variability of measure values along an axis?

• A. Bullet Graph
• B. Box Plot
• C. Histogram
• D. Scatter Plot