Analytics-DA-201 Free Practice Test

- (Topic 3)
You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?

1. A. From the context menu of Sales over lime, select Filters and then select Enable Auto Update.
2. B. From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.
3. C. From the context menu of Detail table, select Ignore Actions.
4. D. From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

Correct Answer: B

- (Topic 1)
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet. What should you do from Tableau Desktop?

1. A. From the Data menu select New Data Source
2. B. From the Data menu select Replace Data Source
3. C. From the File menu select Import Workbook
4. D. From the File menu select New

Correct Answer: A

- (Topic 3)
You have the following dataset.


When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?

1. A. Change the data type of the Sates field to Siring
2. B. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
3. C. Change the default number format of the Sales told
4. D. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).

Correct Answer: C

- (Topic 3)
When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?

1. A. Fonts and Lines
2. B. Fonts and Color Palette
3. C. Number format and Shading
4. D. Dashboard Height and Width pixel settings

Correct Answer: A

- (Topic 1)
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

1. A. Right-click a in the chat, select Annotate and then select Mark.
2. B. Right-click a bar in the chart select Mark Label and then select Always show.
3. C. Edit the aliases for City.
4. D. Drag Region to Tooltip on the Marks card

Correct Answer: D