QUESTION: 29 Exam Topic: 2, Section 2

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

See Explanation section for answer.

Answer(s): 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.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_create.htm https://help.tableau.com/current/pro/desktop/en-
us/calculations_tablecalculations_percentoftotal.htm

Reveal Solution Next Question

QUESTION: 30 Exam Topic: 2, Section 2

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.

See Explanation section for answer.

Answer(s): 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.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_range.htm

Reveal Solution Next Question

QUESTION: 31 Exam Topic: 3, Section 3

You have the following bar chart.

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

What should you add?

A reference band
A reference line
An average line
A distribution band

Answer(s): A

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.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_referenceband.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_referenceband_edit.htm

Reveal Solution Next Question

QUESTION: 32 Exam Topic: 3, Section 3

DRAG DROP (Drag and Drop is not supported)

You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned
How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

See Explanation section for answer.

Answer(s): A

Explanation:

Select
Where
The correct way to complete the query is:
SELECT * FROM [dbo] . [Students]
WHERE [Students].[City] = `Berlin'
The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name. The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] = `Berlin', which means that only rows where the City column of the Students table is equal to `Berlin' will be returned.
The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server- ver15 https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server- ver15 https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server- ver15#join https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union- transact-sql?view=sql-server-ver15

Reveal Solution Next Question

Free TDA-C01 Exam Braindumps (page: 8)

QUESTION: 29 Exam Topic: 2, Section 2

Explanation:

Reference:

QUESTION: 30 Exam Topic: 2, Section 2

Explanation:

Reference:

QUESTION: 31 Exam Topic: 3, Section 3

Explanation:

Reference:

QUESTION: 32 Exam Topic: 3, Section 3

Explanation:

Reference: