Salesforce Certified Tableau Data Analyst - Analytics-DA-201 Exam Practice Test

Question 1

A Data Analyst has a workbook that uses an extracted data source.
The analyst publishes the workbook to Tableau Server.
Which three actions can the analyst perform from the Extract Refresh page in Tableau Server? (Choose three.)

A. Run a refresh

B. Delete the refresh

C. Modify the frequency of the refresh

D. Change the priority of the refresh

E. Change the refresh from full to incremental

Correct Answer: A,C,D

Question 2

You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?

Correct Answer:

Explanation:
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. References:
* Text File - Tableau
* Tableau Certified Data Analyst Study Guide

Question 3

A Data Analyst has a data source that contains the following columns:

he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?

A. Right-click the State dimension filter, and then click Attribute.

B. Right-click the State dimension filter, and then click Add to Context.

C. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.

D. Drag the LOD expression to the Filters shelf.

Correct Answer: B

Question 4

A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.
How should the analyst enable this formatting across the workbook?

A. Click on the Format tab and select Workbook Theme.

B. Right-click on the measure in the data pane, then click on Default Properties and Number Format.

C. Right-click on the measure in the data pane, then click on Create and Calculated Field to convert to a string and add the $ symbol.

D. Click on the Analysis tab and select Forecast.

Correct Answer: B

Question 5

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?

A. All the data sources published to the Tableau Server within the folders to which you have access

B. All the data sources published to the site within the folders to which you have access

C. All the data sources published to the Tableau Server

D. All the data sources published to the site

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

A Data Analyst has the following dashboard.

Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?

A. Select Ignore Actions from the drop-down menu of Sales over time.

B. Deselect Use as Filter from drop-down menu of Profits by State

C. Select Deselect from the drop-down menu of Sales over time.

D. Select Remove Dashboard Item from the drop-down menu of Sales over time.

Correct Answer: A

Question 7

You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?

A. Print

B. Page Setup

C. Export As Version

D. Share

E. Export As PowerPoint

Correct Answer: B

Question 8

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

A. Export the data to a .csv before you publish.

B. Remove all the data source filters before you publish.

C. Change the data source to an extract before you publish.

D. Configure the local file permissions to the workbook file, and then publish the workbook.

E. Embed the credentials when you publish the workbook.

Correct Answer: C,E

Question 9

You have the following map.

You need the map to appear as shown in the following visualization.

What should you do?

A. Change the opacity to 75%

B. Drag Location to Size on the Marks card

C. Change the mark type to Density

D. Drag Population to Size on the Marks card

E. Change the mark type to Map

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 10

You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

A. the row banding size to 1

B. the column banding size to 1

C. the row banding size to 3

D. the column banding size to 3

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 11

You create the following worksheet

The Pick Measure parameter contains the following list of values

Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?

A. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END

B. Case AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END

C. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i

D. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit])
END

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 12

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?

A. From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.

B. From the context menu of Sales over lime, select Filters and then select Enable Auto Update.

C. From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

D. From the context menu of Detail table, select Ignore Actions.

Correct Answer: A

Salesforce Certified Tableau Data Analyst - Analytics-DA-201 Exam Practice Test

Latest Update

Useful Links

Contact Us