Exam TDA-C01 Realistic Dumps Verified Questions Free [Jul 30, 2023]
Valid TDA-C01 Dumps for Helping Passing Tableau Exam!
NEW QUESTION # 31
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
Answer:
Explanation:
1 - Open Tableau Prep
2 - Union the sales data of both divisions
3 - Create a new column to concatenate the name for the Germany division
4 - Join the sales data and the population data by using Country as the join field
NEW QUESTION # 32
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:
1 - From the connections pane, connect to both data sources
2 - Join both datasets and select the join type
3 - Specify Employee Name as the join key
Reference:
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 # 33
in which throe formats can you export a worksheet from the Worksheet menu? Choose three
- A. .csv
- B. .xlsx
- C. .txt
- D. .html
- E. .pptx
- F. .png
Answer: A,C,D
NEW QUESTION # 34
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. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- B. SUM{[Sales]) IN (50000)
- C. [Sales] > 50000
- D. MAX< [Sales], 50000)
Answer: A,C
NEW QUESTION # 35
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 m order? (Place the three correct options in order.)
Answer:
Explanation:
1 - Specify Employee Name as the join key
2 - Open both data sources in Tableau Desktop
3 - Join both datasets and select the join type
NEW QUESTION # 36
You have the following chart that shows profits and discounts over time.
You need to combine the lines to appear as shown in the following chart.
What should you do?
- A. Convert Discount to Discrete
- B. Set Discount to Dual Axis
- C. Drag Discount to the Columns shelf
- D. Drag Discount to Color on the Marks card
Answer: B
Explanation:
To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.
In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.
The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. Reference: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm
NEW QUESTION # 37
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Rename the fields
- B. Create aliases
- C. Create groups
- D. Transforms 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".
NEW QUESTION # 38
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:
check the steps below in explanation
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 # 39
You have the following dataset
You need to create the following visualization.
Which quick table calculation should you drag to Text on the Marks card?
- A. Compound Growth Rate
- B. Percentile
- C. Percent of Total
- D. Percent Difference
Answer: C
Explanation:
we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:
Drag Category to Columns and Sub-Category to Rows.
Drag Sales to Text on the Marks card.
Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.
Right-click Sales on the Marks card again and select Compute Using > Category.
This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:
NEW QUESTION # 40
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?
- A. Add a tooltip
- B. Drag the growth rate to Text on the Marks card
- C. Enable captions
- D. Annotate March 2020
Answer: A
NEW QUESTION # 41
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 # 42
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. Convert the date to Continuous
- B. Convert the date to Attribute
- C. Convert the date to Exact Date
- D. Select Show Misting Values for the dale
Answer: A
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 # 43
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
- A. Condition filter
- B. Wildcard filter
- C. General filter
- D. Top filter
Answer: D
NEW QUESTION # 44
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. ISFULLNAMETableu_USER_NAME))=USERNAME()
- B. NAME Tableau-USER-NAME)
- C. NAMEUSERNAME()
- D. USERNAME()=(Tableau_USER_NAME)
Answer: B
NEW QUESTION # 45
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:
check the steps below in explanation
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 # 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
You publish a dashboard tut uses an attract. 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 Desktop, open the Publish Workbook dialog box and configure the schedule.
- B. From Tableau Server. select Schedules and change the priority of the existing schedule
- C. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh
- D. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month
Answer: C
Explanation:
To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm
NEW QUESTION # 48
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 # 49
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. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
- C. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
- D. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
Answer: D
NEW QUESTION # 50
You have the following dataset that contain null values in the Profits field.
You want the data to appear as shown in the following table.
Which two formulas achieve the goal? Choose two.
- A. IF [Profits] != null then [Profits] END
- B. IFNULL [(profits] ,0)
- C. IFNULL([Profits],0)
- D. IF [Profits] != null then [Profits] END
- E. ISNULL ([Profits])
- F. 2N ([Profits])
Answer: A,B
Explanation:
The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null.
The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement.
The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL Explanation:
The two formulas that will make the data appear as shown in the second table are:
NEW QUESTION # 51
......
TDA-C01 Exam Dumps For Certification Exam Preparation: https://www.testinsides.top/TDA-C01-dumps-review.html
Download Free Tableau TDA-C01 Exam Questions & Answer : https://drive.google.com/open?id=1TRJLuarwc_sUmluJVdaey9ZjFxD6o7o5