Salesforce Certified Tableau Data Analyst Analytics-DA-201 Exam Questions

Page: 1 / 14
Total 174 questions
Question 1

You have the following table.

You need each record to alternate between grey and white.

What should you change in the Format Shading pane?



Answer : A

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.Reference:The answer can be verified through practical application within Tableau or by consulting Tableau's official learning resources, such asTableau Help: Format ShadingorTableau Training Pass: Formatting.


Question 2

A Data Analyst has a dataset that contains people and the awards they have won.

Which formula should the analyst use to get the number of different types of awards that have been won?



Answer : D


Question 3

In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.

Which function should the analyst use to remove the trailing spaces from the Category field?



Answer : A


Question 4

SIMULATION

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 : A

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.


Question 5

You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?



Answer : B

The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL


Question 6

You have the following dataset in Microsoft Excel.

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

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



Answer : C

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

Based on the Data Interpreter's results and the provided Excel dataset screenshot, the number of rows of data that will be ingested into Tableau as values is 17. The Data Interpreter has identified and excluded headers and footers, and the rows with actual data are considered for analysis.


Question 7

You plan to create a Tableau subscription for several users.

Which two formats can you use? Choose two.



Answer : A, B


Page:    1 / 14   
Total 174 questions