Desktop-Specialist Exam Questions and Answers

QUESTION: 51

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

CSV file
PDF File
JSON format
MS Access Database

Answer(s): A,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

Reveal Solution Next Question

QUESTION: 52

Dates in Tableau are typically treated as ______________

Dimensions
Measures

Answer(s): 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

Reveal Solution Next Question

QUESTION: 53

You can use the __________________ in Tableau to clean / organise your data.

Data cleaner
Data manager
Data interpreter
Data organiser

Answer(s): C

Explanation:

When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.

Reference:

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

Reveal Solution Next Question

QUESTION: 54

Larger image

What is this entire view referred to as in Tableau?

Data pane
Analytics Pane
Summary Pane
Distribution Pane

Answer(s): B

Explanation:

Distribution Pane

This is the Analytics pane! Read more from the official documentation below:

Reference:

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

Reveal Solution Next Question

QUESTION: 55

DOWNLOAD THE DATASET FROM - https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv- SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! )

How many different countries are present in the dataset?

150
147
140
156

Answer(s): B

Explanation:

To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!

2) Or, you can simply go to Data Source -> Country Tab -> Describe

As you can see, 147 members exist in this Country column!