[May-2025] Tableau Certified TDA-C01 Exam Practice Dumps
2025 TDA-C01 Premium Files Test pdf - Free Dumps Collection
Tableau TDA-C01 Exam is a certification that validates an individual's knowledge and skills in using Tableau for data analysis. Tableau Certified Data Analyst certification is designed for data analysts who want to demonstrate their proficiency in using Tableau to visualize, analyze, and interpret data. TDA-C01 exam covers a wide range of topics, including data connections, data blending, data aggregation, data visualization, and dashboard creation.
NEW QUESTION # 25
You have a dashboard that contains a parameter named Start Date.
You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should you do?
- A. Create a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter
- B. Create a custom SOL query that references Stan Date in the WHERE clause.
- C. Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.
- D. Create a custom SOL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.
Answer: C
NEW QUESTION # 26
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
Answer:
Explanation:
Explanation:
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
Build a Scatter Plot
Understanding and Using Scatter Plots
Scatter plot in Tableau
NEW QUESTION # 27
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- B. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - C. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
Answer: B,D
Explanation:
End
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. Reference:
Logical Functions - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 28
You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
You want to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should you use?
- A. Left only
- B. Left
- C. Union
- D. Inner
- E. Full outer
Answer: A
Explanation:
To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. Reference:
Tableau Certified Data Analyst Exam Prep Guide, page 9, section "Preparing Data" Tableau Help: Join Your Data Tableau Help: Left Only Join
NEW QUESTION # 29
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the sales dashboard.
Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.
Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.
Right-click on Sales by State and select Add Show/Hide Button from the menu. This will add a button that allows you to show or hide the sheet on the dashboard. You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.
Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.
References: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm
https://help.tableau.com/current/pro/desktop/en-us/dashboards_showhide.htm
https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htm
NEW QUESTION # 30
You have the following chart that shows the cumulative of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
- A. Select Show Misting Values for the dale
- B. Convert the date to Attribute
- C. Convert the date to Continuous
- D. Convert the date to Exact Date
Answer: C
Explanation:
To make the months appear as shown in the second chart, you need to convert the date to Continuous. A continuous date is a green pill that shows a range of values on an axis. A discrete date is a blue pill that shows individual values as headers. In this case, you want to show a continuous range of months on the x-axis, instead of discrete headers.
To convert the date to Continuous, you need to do the following steps:
Right-click on the date field on the Columns shelf and select Convert to Continuous from the menu. This will change the date pill from blue to green and show a continuous range of dates on the x-axis.
Right-click on the date field again and select Month (January 2017) from the menu. This will change the level of detail of the date to month and year, instead of day.
Optionally, you can format the date axis by right-clicking on it and selecting Format from the menu. You can change the scale, tick marks, labels, and other options.
The other options are not correct for this scenario. Converting the date to Exact Date will show every single date as a header, which will be too crowded and unreadable. Selecting Show Missing Values for the date will fill in any gaps in the data with null values, but it will not change how the months appear. Converting the date to Attribute will return only one value for each partition of data, which will not show any variation over time. Reference: https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro/desktop/en-us/dates_continuous.htm https://help.tableau.com/current/pro/desktop/en-us/formatting.htm
NEW QUESTION # 31
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 32
You want to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should you use?
- A. Image
- B. Web page
- C. Horizontal
- D. Sheet
Answer: B
NEW QUESTION # 33
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 be stored as a hyper file.
- C. The credentials must be embedded.
- D. The data source must use a live connection.
Answer: A,C
NEW QUESTION # 34
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)
Answer:
Explanation:
Explanation:
The correct order of the three actions is:
From the connections pane, connect to both data sources
Join both datasets and select the join type
Specify Employee Name as the join key
The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table.
The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables.
The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets.
The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your data. References:
https://help.tableau.com/current/prep/en-us/prep_connect.htm
https://help.tableau.com/current/prep/en-us/prep_join.htm
https://help.tableau.com/current/prep/en-us/prep_join_types.htm
NEW QUESTION # 35
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
- A. December
- B. August
- C. November
- D. October
Answer: D
Explanation:
To find the month that had the biggest increase in average sales compared to the previous month in 2019, you need to compare the slopes of the line segments between each pair of months. The steeper the slope, the greater the increase. Based on the line chart, October had the steepest slope, meaning it had the biggest increase in average sales compared to September in 2019. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm https://www.mathsisfun.com/algebra/line-equation-slope.html
NEW QUESTION # 36
You have a table that contains the following data.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
NEW QUESTION # 37
You have the following table.
You need each record to alternate between grey and white.
What should you change in the Format Shading pane?
- A. the column banding size to 3
- B. the row banding size to 3
- C. the column banding size to 1
- D. the row banding size to 1
Answer: D
NEW QUESTION # 38
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
Answer:
Explanation:
Explanation:
The correct order of the three actions is:
Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
Aggregate the date to month and year.
From the Analytics pane, drag Forecast to the worksheet.
The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.
The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.
The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.
The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm
https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
NEW QUESTION # 39
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.
Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):
Student ID 4183: 39 (Rank 1)
Student ID 4220: 71 (Rank 6)
Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank) Student ID 4124: 75.5 Student ID 4050: 64 Student ID 4205: 67 Student ID 4056: 66 Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.
Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.
https://help.tableau.com/current/prep/en-us/prep_calculations.htm
NEW QUESTION # 40
You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?
- A. The My Content area of Tableau web pages
- B. The Data Source page of Tableau Desktop
- C. The Notifications area of Tableau Prep
- D. The Shared with Me page
Answer: A
Explanation:
To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message. References:
Create a Subscription to a View or Workbook - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 41
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 42
......
Get ready to pass the TDA-C01 Exam right now using our Tableau Certified Exam Package: https://www.itexamsimulator.com/TDA-C01-brain-dumps.html
A fully updated 2025 TDA-C01 Exam Dumps exam guide from training expert ITExamSimulator: https://drive.google.com/open?id=1YWbOGDl8ey1WmbyfH0qCd-CkGma81HF4
