Tableau Desktop Specialist Certification Practice Tests Set 1

Measure Names means

If ZIP-98007 is a string and ZIP- is used as separator then outcome is

Below is not an dashboard sizing options available in Tableau to visualize.

Which of the following property types have equal number of total reviews. Use airbnb.xlsx sheet.

Is it possible to change the datatype of fields in tableau ?

Y = b0 + b1 * ln(X) defines the below trend model.

Which of the following can be used to include more than one set.

Which of these objects help you to integrate Tableau Dashboards with applications outside Tableau.

Which of the following URL prefixes is not allowed in Dashboard Actions

Size of the marks is not significant in one of these charts

Which of the following can be used to increase the performance when dataset is large or there are too many filters

Which of the following sports has equal sum of number of records measure. Please use Global Sports Finances.

Which of the following options are used to italicize the content in tooltip.

Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?

How do you identify a continuous field in Tableau?

True or False: Sets can be created on Measures

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

A field that shows average home values for the United States in 2016 is most likely :

True or False: Tableau can create worksheet-specific filters

A Tableau Support case can be opened in which of the following valid ways?

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

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

The calculation [Ship Date] - [Order Date] will return _______________

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.

__________  is a technique in Tableau which will identify marks with similar characteristics

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

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

Which of the following 2 fields CANNOT be deleted in Tableau?

_____________   contains the visualisations, info needed to build the visualisations, and a copy of the data source.

________________ is hosted by Tableau to share our visualisations publically with the world.

What will the following function return?

LEFT("Tableau", 3)

The row and column shelves contain ___________________

You can create _______________ for members in a dimension so that their labels appear differently in the view.

You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

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 its total publications were contributed in 2014?

Using the atheletes table:

i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)

ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.  (Sheet 2)

Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?

(Ignore any nulls / unknowns)

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?

Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view.  Now group the states of New York, California and Washington. What percent of the total expense does this group contribute?

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?

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?

Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________

True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.

Default aggregation in Tableau is ? Can it be changed ?

Can we apply the filter or selections on one graph and treat it like a filter for all the other visuals on the dashboard ?

The Average function does not treat null values as zeros.

To switch a set to list the individual members:

"Show Me" option helps to check the following parameters for each of the charts

To visualize all the data rows in an data source you have to use following option

Which of the following is a snapshot of your data.

Shortcut to create a new worksheet is

The filters that we have created are restricted to the current worksheet are called as

Which of the following are not Tableau Auto Generated Fields.

Which of the following Sub-Categories have huge loss when total profit is considered. Use Sample- Superstore data.

If we are to compare measures that have the same scale and unit of measurement, then we use

Data Pane may conditionally accommodate these sections -

When the values are computed using specified dimensions without reference to any other dimensions in the view are called as

To bin a measure, we have to create a new

Which of the following may be called as Pre-computed filters

You can add a dimension or a measure by

Which of the following will have captions option.

Which of the following allows a conditional formatting which lets you compare a column or row with rest of the table