How to pass Tableau Desktop-Specialist exam with the help of dumps?

Question # 1

When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

A. Monitor, Default, Phone, Tablet
B. Phone, Tablet, Laptop, Desktop
C. Default, Phone, Tablet, Desktop
D. Phone, Monitor, Laptop, Default

Show Answer

Question # 2

Is it possible to make a Measure discrete?

A. No
B. Yes

Show Answer

Question # 3

Which of the following calculations DO NOT need a quick table calculation?

A. Variance
B. Rank
C. Moving Average
D. Standard Deviation

Show Answer

Question # 4

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

A. 111,060
B. 1,461
C. 112,256
D. 1,222

Show Answer

Question # 5

What does it imply if a field has a blue background?

A. It is continuous
B. It is discrete
C. It is a dimension
D. It is a measure

Show Answer

Question # 6

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. 

A. Tableau Server
B. Tableau Prep
C. Tableau Public
D. Tableau myServer

Show Answer

Question # 7

Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?

A. 0.783262
B. 0.739284
C. 0.759329
D. 0.748472

Show Answer

Question # 8

To connect Tableau to a CSV data source what type of connection should you use?

A. Spatial
B. Excel
C. Text
D. JSON

Show Answer

Question # 9

Which of the following are valid ways to trigger actions for a Dashboard? 

A. Hover
B. Click
C. Select
D. Menu
E. Double click

Show Answer

Question # 10

True or False: Context Filters are executed after Data Source filters

A. True
B. False

Show Answer

Question # 11

Which of the following is a valid way to create Sets in Tableau?

A. In the Data pane, right-click a dimension and select Create > Set.
B. In the Tableau Main Menu, Choose Worksheet and select Create > Set
C. In the Tableau Main Menu, choose Dashboard and select Create > Set
D. In the Data pane, right-click a measure and select Create > Set.

Show Answer

Question # 12

Which of the following are valid ways to add Totals to a view?

A. Using the Data Pane
B. Using the Analytics Pane
C. From the Analysis Tab in the Menu bar on top
D. Using the Marks shelf

Show Answer

Question # 13

By default, measures placed in a view are aggregated by ______________

A. COUNT
B. AVERAGE
C. MEDIAN
D. SUM

Show Answer

Question # 14

True or False: Trend lines can only be used with numeric or date fields

A. True
B. False

Show Answer

Question # 15

Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.

A. role, type
B. Data type, Value
C. type, role
D. dimension, measure

Show Answer

Question # 16

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

A. 5,129 and 88,872
B. 52,678 and 311,404
C. 1,807 and 34,571
D. 4,888 and 17,817

Show Answer

Question # 17

Which of the following is a good reason for using a bullet graph?

A. Comparing the actual sales against the target sales
B. Analysing the trend over a given time period
C. Forecasting future sales
D. Displaying the year-on-year growth in sales

Show Answer

Question # 18

Which Sub-Category had the least Profit in the Office Supplies category?

A. Fasteners
B. Labels
C. Envelopes
D. Binders

Show Answer

Question # 19

A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. 

A. .twbx file
B. .tbm file
C. .twb file
D. .tde file

Show Answer

Question # 20

Which of the following are valid ways of Grouping Data?

A. Using Marks in the view
B. Using Labels in the View
C. From the Analytics Pane
D. From the Dimensions Shelf

Show Answer

Question # 21

Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

A. Discrete value, Continuous Value
B. Geographic Value, Discrete Value
C. Continuous Value, Discrete Value
D. Longitude, Latitude

Show Answer

Question # 22

True or False: Sets can be created on Measures 

A. True
B. False

Show Answer

Question # 23

When is an axis created for the visualisation in Tableau?

A. When we drag a measure to the row/column shelf 
B. When we drag a dimension to the row/column shelf 
C. When we drag a discrete field to the row/column shelf 
D. When we drag a continuous field to the row/column shelf 

Show Answer

Question # 24

Which of the following is NOT a valid official data source in Tableau Desktop?

A. PostgreSQL
B. SAP HANA
C. Google Firebase
D. Amazon Redshift

Show Answer

Question # 25

_________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

A. .twb files
B. .tbm files
C. .twbx files
D. .tde files

Show Answer

Question # 26

What will the following function return?LEFT("Tableau", 3)

A. An error
B. Tab
C. eau
D. ble

Show Answer

Question # 27

Which of the following is the correct way to calculate Profit Ratio in Tableau?

A. Profit / Sales
B. Sales / Profit
C. SUM(Profit) / SUM(Sales)
D. SUM(Sales)/SUM(Profit)

Show Answer

Question # 28

True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story. 

A. rue
B. False

Show Answer

Question # 29

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

A. Yes
B. No

Show Answer

Question # 30

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

A. Yes
B. No

Show Answer

Question # 31

How can you format an axis as Bold in Tableau?

A. By choosing the axis and selecting Command/Control + B on your keyboard
B. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
C. By right clicking on the axis, choosing format, and then setting its font to bold.
D. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.

Show Answer

Question # 32

Is SUM a table calculation?

A. Yes
B. No

Show Answer

Question # 33

You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

A. Save it as a .twm file
B. Save it as a .twb file
C. Save it as a .tds file
D. Save it as a .twbx file

Show Answer

Question # 34

Which one of the following is a dimension?

A. Longitude
B. Measure Names
C. Number of records
D. Latitude

Show Answer

Question # 35

Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

A. 68,620
B. 74,683
C. 37,455
D. 46,493

Show Answer

Question # 36

Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

A. 592,593
B. 293,202
C. 416,702
D. 336,908

Show Answer

Question # 37

True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

A. True
B. False

Show Answer

Question # 38

True or False: To concatenate fields, they must be of same data type

A. True
B. False

Show Answer

Question # 39

Which of the following are valid ways to copy a worksheet visualisation as an image?

A. By simply clicking Control + V on the keyboard
B. By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
C. Using the Marks shelf and choosing Copy->Image
D. By right clicking on the worksheet visualisation and selecting Copy->Image

Show Answer

Question # 40

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth? 

A. October
B. September
C. July
D. June

Show Answer

Question # 41

True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

A. True
B. False

Show Answer

Question # 42

Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

A. 9
B. 7
C. 10
D. 8

Show Answer

Question # 43

What is a story point in Tableau?

A. A single worksheet or dashboard
B. A collection of dashboards
C. A collection of both worksheets and dashboards
D. A collection of worksheets

Show Answer

Question # 44

If you have a dashboard and are displaying its filter, how can you rearrange it?

A. By clicking on the 2 lines on top and dragging the filter.
B. By clicking on the dropdown and dragging the filter
C. By clicking on the filter title and dragging it.
D. By clicking anywhere inside the filter and dragging it.

Show Answer

Question # 45

______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

A. Joining
B. Blending
C. Combining
D. Unioning

Show Answer

Question # 46

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth? 

A. October
B. September
C. July
D. June

Show Answer

Question # 47

Which of the following charts types always includes bars sorted in descending order?

A. Pareto Chart
B. Pie Chart
C. Gantt Chart
D. Stacked Bar Chart

Show Answer

Question # 48

How can you change the Default Aggregation for a measure in Tableau? 

A. By changing its properties manually every time we need to use it
B. By right clicking the dimension -> Default properties and choosing Aggregation
C. By right clicking the measure -> Default properties and choosing Aggregation
D. By double clicking on the measure, and then choosing Window -> Default Aggregation

Show Answer

Question # 49

We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

A. Tableau Reader
B. Tableau Online
C. Tableau Server
D. Tableau Desktop

Show Answer

Question # 50

Which of the following can you use to create a Histogram?

A. 2 measures
B. 1 measure 
C. 2 dimensions
D. 1 dimension

Show Answer

Question # 51

Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

A. 1 , 4
B. 2 , 2
C. 2 , 3
D. 1 , 2

Show Answer

Question # 52

For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

A. Random
B. Manual
C. Topological
D. Hierarchical

Show Answer

Question # 53

DOWNLOAD THE DATASET FROM:https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ574wld4InEplyKT8RP?usp=sharing (if you haven't already)Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

A. United States
B. France
C. United Kingdom
D. Canada 

Show Answer

Question # 54

Which of the following are valid ways to show Mark Labels in the visualisation?

A. Click on the Show mark labels icon in the Toolbar
B. Drag the measure to the Text label in the Marks Card
C. Click on Data in the Menu bar and Choose Show Mark Labels
D. Click on Analysis in the Menu bar and choose Show Mark Labels

Show Answer

Question # 55

You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

A. Sets
B. Groups
C. Calculation
D. Parameters

Show Answer

Question # 56

Download the Dataset from:https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharingUsing the Time Series Table, create a line chart to show Sales over time. Which Month andYear witnessed the lowest Sales?

A. September 2017
B. March 2018
C. December 2017
D. January 2018

Show Answer

Question # 57

What is the one most important thing you should do after creating a Dual-axis chart?

A. Synchronise the axis
B. Change the colours
C. Edit the labels
D. Hide the axis

Show Answer

Question # 58

Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

A. To support additional functionality such as count distinct
B. Fast to create
C. Help improve performance
D. To have access to the freshest possible data at all times

Show Answer

Question # 59

The icon associated with the field that has been grouped is a ______________

A. Paper Clip
B. Globe
C. Intersection
D. =#

Show Answer

Question # 60

______________ refers to the level of detail for a piece of data, wherever you are looking.

A. Data Cleanliness
B. Data granularity
C. Data connectivity
D. Data LOD

Show Answer

Question # 61

Which of the following returns the Absolute Value of a given number?

A. ABS(Number)
B. CEILING(Number)
C. FLOOR(Number)
D. ZN(Number)

Show Answer

Question # 62

When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

A. Data source Filter
B. Extract Filter
C. Context Filter
D. None of the these

Show Answer

Question # 63

True or False: All rows from both tables are returned in an INNER JOIN 

A. True
B. False

Show Answer