TDA-C01 PDF Dumps Real 2025 Recently Updated Questions
Released Tableau TDA-C01 Updated Questions PDF
NEW QUESTION # 32
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.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 33
You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
- A. USERNAME()=(Tableau_USER_NAME)
- B. ISFULLNAMETableu_USER_NAME))=USERNAME()
- C. NAMEUSERNAME()
- D. NAME Tableau-USER-NAME)
Answer: A
Explanation:
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau.
ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]
/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of
"S". References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.
tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.
com/current/pro/desktop/en-us/calculations_calculatedfields.htm
In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user's username.
NEW QUESTION # 34
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 # 35
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the Data menu select Replace Data Source
- B. From the Data menu select New Data Source
- C. From the File menu select Import Workbook
- D. From the File menu select New
Answer: B
NEW QUESTION # 36
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
- A. WINDOW_SUM(SUM ([Quantity]))
- B. LOOKUP (SUM ([Quantity]))
- C. INDEX ()
- D. FIRST ()
Answer: B
Explanation:
The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position. References: The information is inferred from general Tableau knowledge as well as the following sources:
Tableau Functions (Alphabetical)
LOOKUP
Tableau Certified Data Analyst Exam Guide
NEW QUESTION # 37
You have the following dataset:
Which grouping option should you use in Tableau Prep to group all five names automatically?
- A. Pronunciation
- B. Common Characters
- C. Manual Selection
- D. Spelling
Answer: B
Explanation:
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.
NEW QUESTION # 38
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 # 39
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
- A. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
- B. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
- C. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
- D. Change Population to a discrete dimension
Answer: C
Explanation:
To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References: https://help.tableau.com/current/pro/desktop/en-us
/multiplemeasures_dualaxes.htm https://help.tableau.com/current/pro/desktop/en-us
/marks_markproperties_size.htm
In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.
NEW QUESTION # 40
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 41
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.
- A. check the steps below in explanation
Answer: A
Explanation:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.
Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.
NEW QUESTION # 42 
How are the colors configured for the map?
- A. A diverging color palette that has five stepped colors
- B. A sequential color gradient
- C. A diverging color palette that has six stepped colors
- D. A single color gradient
Answer: A
NEW QUESTION # 43
You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
- A. Datetime
- B. Boolean
- C. Integer
- D. Date
- E. Float
- F. String
Answer: C,F
Explanation:
In the context of filtering data in Tableau, both string and integer parameters can be used to dynamically filter data. A string parameter can be used to filter text-based values, while an integer parameter is suitable for numerical values. In the provided dataset and result URLs, it appears that a unique identifier or key (which could be a string or integer) is being used to filter specific data entries. Reference: The information is based on the following sources:
An Introduction to Parameters in Tableau
Create Parameters - Tableau
NEW QUESTION # 44
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
- A. From the More actions menu of Materials, select Valid in the Show values section.
- B. For the data type of the Material field, select Custom, and then select Role1.
- C. From the More actions menu of Materials, filter the selected values.
- D. From the More actions menu of Materials, select Group Values, and then select Spelling.
Answer: B,D
Explanation:
To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
Use Data Roles to Validate your Data - Tableau
New in Tableau Prep: Automatically identify data quality issues with Data Roles
NEW QUESTION # 45
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:
To modify the chart to show only min and max values of both measures in each region, 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 Line worksheet.
Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.
NEW QUESTION # 46
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?
Answer:
Explanation:
NEW QUESTION # 47
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
check the steps below in explanation
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.
Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
NEW QUESTION # 48
A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.
Which technique should the analyst use as the first step to achieve this in Tableau Prep?
- A. A wildcard search to pivot in the Pivot step
- B. A wildcard search for multiple tables in the Input step
- C. A Rows to Columns Pivot step
- D. An Aggregate step to reshape the data
Answer: A
NEW QUESTION # 49
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. Full outer
- B. Left only
- C. Left
- D. Union
- E. Inner
Answer: B
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. References:
Tableau Certified Data Analyst Exam Prep Guide, page 9, section "Preparing Data" Tableau Help: Join Your Data Tableau Help: Left Only Join
NEW QUESTION # 50
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. October
- B. November
- C. December
- D. August
Answer: A
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 # 51
You have the following:
Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.
- A. Bookcases
- B. Furnishings
- C. Machines
G Phones - D. Accessories
- E. Tables
- F. Copiers
- G. Chairs
Answer: C,D,E
Explanation:
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
* Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1).
Therefore, its rank remains the same.
* Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
* Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
* Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
* Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
* Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
* Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
* Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.
NEW QUESTION # 52
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. Folders
- B. Groups
- C. Sets
- D. Hierarchies
Answer: A
Explanation:
To organize the tables in the Data pane based on the type of data contained within the tables, you should use folders. Folders are a way to manually group fields, parameters, sets, or tables in the Data pane according to your preference. You can create folders by right-clicking on the fields or tables you want to group and selecting Folders > Create Folder. You can also drag and drop fields or tables into existing folders. You can name the folders according to the type of data they contain, such as sales, customer, product, etc. Folders can help you find and access the fields or tables you need more easily and efficiently. References:
Organize and Customize Fields in the Data Pane - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 53
You want to create the following dashboard that will contain two sheets.
What should you do?
- A. Add both sheets lo a horizontal container and add a border to the container.
- B. Drag both sheets to the dashboard and add a border to each sheet.
- C. Add a border to both sheets and add both sheets to a horizontal object.
- D. Drag both sheets to the dashboard and add a background lo each sheet.
Answer: A
NEW QUESTION # 54
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?
Answer:
Explanation:
NEW QUESTION # 55
You have a dataset that contains sates dat
a. The following is a sample of the data.
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
- A. SUM{[Sales]) IN (50000)
- B. [Sales] > 50000
- C. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- D. MAX< [Sales], 50000)
Answer: B,C
NEW QUESTION # 56
......
Tableau TDA-C01 exam covers a wide range of topics such as data connections, data preparation, data analysis, and visualization. TDA-C01 exam is designed to test an individual's understanding of Tableau Desktop and Tableau Prep Builder. TDA-C01 exam consists of multiple-choice and multiple-response questions, and it is proctored to ensure that the integrity of the certification is maintained.
TDA-C01 Dumps and Practice Test (178 Exam Questions): https://dumpstorrent.actualpdf.com/TDA-C01-real-questions.html
