Free Practice Questions for Tableau Desktop-Specialist Exam

Explanation

Trend lines have become popular questions in recent Tableau examinations. Follow along:

1) First drag Sales to the Rows shelf and Profit to the Columns shelf:

c

You will only see a single mark since the view is aggregated.

2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):

3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:

4) The following is our view. Hover over the trend line to see the R-squared value:

Explanation

Measures contain numeric quantitative values hence that option is incorrect.

Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm

Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm

If you’ve created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you’ve added joined tables, default properties, or custom fields—such as groups, sets, calculated fields, and binned fields—to the Data pane.

Visualisations and Data extracts are NOT saved in a .tds file!

Explanation

According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :

1) Linear Trend Line

2) Logarithmic Trend Line

3) Exponential Trend Line

4) Polynomial Trend Line

5) Power Model

Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.

See the following image:

For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm

1) Right click on Rows or Columns, and choose format. In the Font option click on Bold. (CORRECT) - this will modify only the selected axis (row or column)

2) Choose Format then Font from the Menu bar, and select Bold under the Header option (INCORRECT) - this modifies both rows and columns at the same time

3) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option (CORRECT) -  this will modify only the selected axis (row or column)

4) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. (INCORRECT) - no such option exists

Explanation

From the official Tableau website:

Explanation

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

This is a tricky question. We are talking about story POINTS, and not entire stories in the question.

To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.

I can simply drag the dashboard into the view to create a new story point.

Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:

The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.

Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htm

A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs.

Graphical user interface, text, application Description automatically generated

Graphical user interface, application, Word Description automatically generated

Graphical user interface, text, application Description automatically generated

Graphical user interface, text, application Description automatically generated

When you click Salt Lake City in the view, the URL action will direct you to https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City. A URL action is a hyperlink that points to a web page or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data.  To customize links based on your data, you can automatically enter field values as parameters in URLs3 In this case, the URL action uses https://en.wikipedia.org/wiki/ as the URL target, where is a field value from the view. When you click Salt Lake City in the view, Tableau will replace with Salt Lake City in the URL target. However, since spaces are not allowed in URLs, Tableau will encode them as + signs instead. Therefore, the final URL will be https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City 3 The other options are not correct because they do not reflect how Tableau encodes field values in URL actions.