Get instant access to TDA-C01 Practice Tests 2024 Free Updated Today!
Welcome to download the newest PassLeader TDA-C01 PDF dumps ( 100 Q&As)
Tableau TDA-C01 (Tableau Certified Data Analyst) certification exam is a globally recognized certification that validates an individual's skills and expertise in using Tableau for data analysis. Tableau Certified Data Analyst certification exam is designed for professionals who want to demonstrate their proficiency in Tableau and showcase their ability to work with data to solve complex business problems.
To be eligible for the Tableau TDA-C01 certification exam, candidates should have a good understanding of data analysis concepts and techniques, as well as a basic knowledge of statistics and data visualization. Candidates should also have experience using Tableau software to create reports, dashboards, and data visualizations. Additionally, candidates should be familiar with data preparation techniques such as data cleaning and data shaping.
NEW QUESTION # 33
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. FIRST ()
- B. WINDOW_SUM(SUM ([Quantity]))
- C. INDEX ()
- D. LOOKUP (SUM ([Quantity]))
Answer: D
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 # 34
You are the owner of an alert.
You receive an email notification that the alert was suspended
From where can you resume the suspended alert?
- A. The Notification area of Tableau Prep
- B. The Data Source page of Tableau Desktop
- C. The My Content area of Tableau web pages
- D. The Shared with Ma page
Answer: C
Explanation:
To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. References:
https://help.tableau.com/current/pro/desktop/en-us/alerts.htm
https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm
In Tableau, the "My Content" area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the "My Content" area to resume it.
NEW QUESTION # 35
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
- A. The padding
- B. The size
- C. The border
- D. The position
- E. The background
Answer: A
Explanation:
To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:
Format Dashboards - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 36
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Transforms the fields
- B. Create aliases
- C. Create groups
- D. Rename the fields
Answer: B
Explanation:
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest".
In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.
NEW QUESTION # 37
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.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
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:
1 - Aggregate the date to month and year.
2 - Create a calculated field that uses the MODEL_QUANTILE function.
3 - Add the date to the Columns sfelf. Add the segment and the sales to the Rows shelf.
NEW QUESTION # 39
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:
check the steps below in explanation
Explanation:
To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.
Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.
Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the existing data source.
Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
NEW QUESTION # 40
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 41
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. Change Population to a discrete dimension
- B. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
- C. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
- D. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
Answer: B
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. Reference: 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
NEW QUESTION # 42
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Manual Selection
- B. Pronunciation
- C. Spelling
- D. Common Characters
Answer: A
NEW QUESTION # 43
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, 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 Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
References: https://help.tableau.com/current/pro/desktop/en-us/maps.htm
https://help.tableau.com/current/pro/desktop/en-us/maps_howto_filled.htm
https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm
NEW QUESTION # 44
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 # 45
You have the following dataset.
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
Answer:
Explanation:
NEW QUESTION # 46
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 row banding size to 1
- B. the column banding size to 3
- C. the column banding size to 1
- D. the row banding size to 3
Answer: A
Explanation:
To have each record alternate between grey and white, you should change the row banding size to 1 in the Format Shading pane. This setting will ensure that each row has a different shading from the one above and below it, creating an alternating pattern of grey and white rows. References: The answer can be verified through practical application within Tableau or by consulting Tableau's official learning resources, such as Tableau Help: Format Shading or Tableau Training Pass: Formatting.
NEW QUESTION # 47
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
- A. check the steps below in explanation
Answer: A
Explanation:
To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.
NEW QUESTION # 48
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. NAME Tableau-USER-NAME)
- B. ISFULLNAMETableu_USER_NAME))=USERNAME()
- C. USERNAME()=(Tableau_USER_NAME)
- D. NAMEUSERNAME()
Answer: C
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 # 49
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?
- A. A table calculation filter used on Sheet
- B. A dimension filter on all the sheets
- C. A context filler on a dimension m Sheet3
- D. A top N condition filer on a dimension in Sheet 1 and Sheet2
Answer: B
Explanation:
A data source filter is a filter that applies to all the worksheets that use the same data source. It filters the data before any other filters or calculations are applied. You can add a data source filter from the Data Source page by clicking on the Add button next to Filters.
The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all the sheets. This means that you can choose a dimension from your data source and filter it by values, range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension.
The other types of filters are not data source filters and will not appear in the Edit Data Source Filters dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a measure or dimension based on a condition. A context filter is a filter that creates a subset of data that other filters can use.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_tablecalculations.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm Data source filters in Tableau apply to the entire data source, affecting all sheets that use that data source. The Edit Data Source Filters dialog box allows you to add filters that operate at the data source level, which is different from context filters, top N filters, or table calculation filters that are applied at the worksheet level.
NEW QUESTION # 50
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
- A. COVAR({Award})
- B. COUNTD {(NAME])
- C. MAX {(Award})
- D. COUNTD({Award})
- E. INDEX()
Answer: D
Explanation:
To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.
The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau.
MAX({Award}) will return the maximum value in the Award field, which may not be a type of award.
INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards.
References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.
NEW QUESTION # 51
You create the following worksheet
The Pick Measure parameter contains the following list of values
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?
- A. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit])
END - B. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END - C. Case AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END - D. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i
Answer: A
Explanation:
https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm
This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects '1', it shows Sales, and when '2' is selected, it shows Profit. This dynamic switching is enabled by the Case function.
NEW QUESTION # 52
......
Apr-2024 Latest ActualPDF TDA-C01 Exam Dumps with PDF and Exam Engine: https://braindumps2go.actualpdf.com/TDA-C01-real-questions.html
