ExamGecko
Home / Tableau / TDA-C01 / List of questions
Ask Question

Tableau TDA-C01 Practice Test - Questions Answers, Page 3

List of questions

Question 21

Report
Export
Collapse

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.

Tableau TDA-C01 image Question 21 76244 09232024004731000000

check the steps below in explanation
check the steps below in explanation
Suggested 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.

asked 23/09/2024
Mark Chow
43 questions

Question 22

Report
Export
Collapse

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.

Tableau TDA-C01 image Question 22 76245 09232024004731000000

check the steps below in explanation
check the steps below in explanation
Suggested answer: A

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.

asked 23/09/2024
Christopher Harden
46 questions

Question 23

Report
Export
Collapse

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.

Tableau TDA-C01 image Question 23 76246 09232024004731000000

check the steps below in explanation
check the steps below in explanation
Suggested answer: A

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.

asked 23/09/2024
Patrick Cheung
37 questions

Question 24

Report
Export
Collapse

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.

Tableau TDA-C01 image Question 24 76247 09232024004731000000

check the steps below in explanation
check the steps below in explanation
Suggested answer: A

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.

asked 23/09/2024
Craig Reid
36 questions

Question 25

Report
Export
Collapse

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%.

Tableau TDA-C01 image Question 25 76248 09232024004731000000

check the steps below in explanation
check the steps below in explanation
Suggested 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.

asked 23/09/2024
frederic dohen
36 questions

Question 26

Report
Export
Collapse

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.

Tableau TDA-C01 image Question 26 76249 09232024004731000000

check the steps below in explanation
check the steps below in explanation
Suggested answer: A

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.

Topic 3, Section 3

asked 23/09/2024
Alajauan Adams
35 questions

Question 27

Report
Export
Collapse

You have the following bar chart.

Tableau TDA-C01 image Question 27 76250 09232024004731000000

You want the chart to appear as shown in the Mowing exhibit.

Tableau TDA-C01 image Question 27 76250 09232024004731000000

What should you add?

A reference band
A reference band
A reference line
A reference line
An average line
An average line
A distribution band
A distribution band
Suggested answer: D

Explanation:

A reference band is a shaded area that shows a range of values on an axis. You can use a reference band to highlight a target range, a confidence interval, or a standard deviation. In this case, you want to add a reference band that shows the range of values from 0 to 100 on the y-axis. This will create a shaded area behind the bars that indicates the percentage of sales.

To add a reference band, you need to do the following steps:

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 Reference Band from the Analytics pane to Y-Axis on the worksheet. This will add a reference band on the y-axis that shows the average and confidence interval for all values.

Click on the Edit button on the reference band to open the Edit Reference Band dialog box. You will see options to customize your reference band.

Change the Band From value to 0 and the Band To value to 100. This will change the reference band to show the range of values from 0 to 100 on the y-axis.

Click OK to apply the changes. You will see that the reference band now shows a shaded area behind the bars.

asked 23/09/2024
Brent Varona
25 questions

Question 28

Report
Export
Collapse

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 table calculation filter used on Sheet
A table calculation filter used on Sheet
A top N condition filer on a dimension in Sheet 1 and Sheet2
A top N condition filer on a dimension in Sheet 1 and Sheet2
A context filler on a dimension m Sheet3
A context filler on a dimension m Sheet3
A dimension filter on all the sheets
A dimension filter on all the sheets
Suggested answer: D

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.

asked 23/09/2024
Muhammad Gul
41 questions

Question 29

Report
Export
Collapse

From Tableau Desktop you sign in lo a Tableau Server site.

What appears in the list of available data sources when you search for a published data source?

All the data sources published to the site
All the data sources published to the site
All the data sources published to the Tableau Server
All the data sources published to the Tableau Server
All the data sources published to the site within the folders to which you have access
All the data sources published to the site within the folders to which you have access
All the data sources published to the Tableau Server within the folders to which you have access
All the data sources published to the Tableau Server within the folders to which you have access
Suggested answer: C

Explanation:

When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag.

Reference: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm

asked 23/09/2024
corey shields
27 questions

Question 30

Report
Export
Collapse

You have the following dataset in Microsoft Excel.

Tableau TDA-C01 image Question 30 76253 09232024004731000000

You are using interpreter to cleans the dataset. Data interpreter provides the following results.

Tableau TDA-C01 image Question 30 76253 09232024004731000000

How many rows of data will be ingested into Tableau as values?

10
10
20
20
17
17
15
15
Suggested answer: C

Explanation:

Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:

It removes the first three rows and the last two rows that contain headers and footers.

It splits the merged cells in column A and fills in the missing values with ''Fiction'' or ''Non-Fiction''.

It does not remove or change any other rows or cells.

Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers.

Reference: https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htm

asked 23/09/2024
Sivakumar Balasundram
41 questions
Total 120 questions
Go to page: of 12
Search

Related questions