Latest Tableau-Desktop-Specialist Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : Tableau-Desktop-Specialist
Exam Name : Tableau Desktop Specialist
Vendor Name : "Tableau"

Reference: https://www.tutorialspoint.com/tableau/tableau_data_blending.htm

Question: 92

Dates in Tableau are typically treated as

1. Dimensions

2. Measures

Answer: A
Explanation:

For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

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

Question: 93

True or False: It is possible to change the Geographic Role of a dimension

1. True

2. False

Answer: A
Explanation:

Explanation A geographic role associates each value in a field with a latitude and longitude value. Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names. To assign a geographic role to a field: In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.

When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated). These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.

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

Question: 94

To use a quick table calculation, which of the following programming languages do you need to know?

1. ython

2. Java

3. Javascript

4. None of these

Answer: D
Explanation:

You don’t need to know ANY programming language to use quick table calculations!

Follow along with the steps below to learn how to apply a quick table calculation to a visualization:

1. Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.

   
   

2. Navigate to a new worksheet.

   
   

3. From the Data pane, under Dimensions, drag Order Date to the Columns shelf.

   
   

4. From the Data pane, under Dimensions, drag State to the Rows shelf.

   
   

5. From the Data pane, under Measures, drag Sales to Text on the Marks Card.

   
   

6. From the Data pane, under Measures, drag Profit to Color on the Marks Card.

   
   

7. On the Marks card, click the Mark Type drop-down and select Square.

The visualization updates to look like this:

Apply the quick table calculation

1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.

Note: You can only perform quick table calculations on measures in the view. A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.

Reference: https://help.tableau.com/current/pro/desktop/enus/calculations_tablecalculations_quick.htm

Question: 95

How would you calculate GDP per capita in Tableau?

1. SUM([GDP]/[POPULATION])

2. SUM([Population]/[GDP]])

3. SUM([GDP]*[POPULATION])

4. SUM([GDP]) / SUM([Population])

Answer: D
Explanation:

GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

Question: 96

Which of the following are the options to export the data used to build the view / visualisations?

1. CSV file

2. PDF File

3. JSON format

4. MS Access Database

Answer: D
Explanation:

You can export the data in a Tableau data source, including all or part of the records from

your original data. Alternatively, you can export only the portion of data used to generate the view. Since the question mentions the data used to build the view, we’ll focus on that :

*Export data in the view to Microsoft Access or .csv* Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).

1. In Tableau Desktop, select Worksheet > Export > Data.

   
   

2. Select a location and type a name for your Access database or .csv file.

   
   

3. Click Save.

   
   

4. If you’re on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

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

Question: 97

True or False:

The Highlighting action can be disabled for the entire workbook.

1. True

2. False

Answer: A
Explanation:

Yes, it is possible to disable highlighting for the entire workbook.

For more information: https://help.tableau.com/current/pro/desktop/engb/actions_highlight.htm

Question: 98

Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK).

For the University of Manchester, what percent of the total publications were contributed in 2014? A. 28.415%

B. 23.497%

C. 25.683%

D. 22.404%

Answer: D
Explanation:

Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We’ll be using filters, as well as quick table calculations (percent of total) for this one.

1) Firstly, let’s drag Country and Institution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf.

The following is our view:

Question: 99

Which of the following are benefits of using Data Extracts in Tableau?

1. Improved Performance

2. Ability to use the data offline

3. Working with freshest data at all times

4. Faster to work with

Answer: A,B,D
Explanation:

Explanation Extracts are advantageous for several reasons:

1. Supports large data sets: You can create extracts that contain billions of rows of data.

   
   

2. Fast to create: If you’re working with large data sets, creating and working with extracts can be faster than working with the original data.

   
   

3. Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.

4. Support additional functionality: Extracts allow you to take advantage of Tableau functionality that’s not available or supported by the original data, such as the ability to compute Count Distinct.

   
   

5. Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

To work with the MOST up-do-date data, use a live connection instead! Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
Question: 100

True or False: A reference line cannot be added from the Analytics Pane

1. True

2. False

Answer: B
Explanation:

You can add a reference line to any continuous axis in the view. To add a reference line: Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view. In a simple case, the drop target area offers three options:

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