Tableau Desktop Specialist Test-2

Welcome to your Tableau Desktop Specialist - Test-2

Name

Phone

Q1. True or False: Tableau can create worksheet-specific filters

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

Using the Developer Community Forum

Contacting Salesforce using their website

Using the support option on the Tableau website

Using the Tableau learn website

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

Select 1 option(s):

Pareto Chart

Pie Chart

Gantt Chart

Stacked Bar Chart

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

Select 1 option(s):

TRUE

FALSE

Q5. The calculation [Ship Date] – [Order Date] will return _______________

Select 1 option(s):

Number of orders placed in that duration

Number of days between these dates

Number of unique orders placed between these dates

Number of orders shipped between these dates

Q6. What term is used to describe the following picture?

Select 1 option(s):

Parameter

Set

Hierarchy

Group

Q7. 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.

Select 1 option(s):

TRUE

FALSE

Q8. _________ is a technique in Tableau which will identify marks with similar characteristics

Select 1 option(s):

Clustering

Grouping

Sets

Union

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

Select 1 option(s):

Profit / Sales

Sales / Profit

SUM(Profit) / SUM(Sales)

SUM(Sales)/SUM(Profit)

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

Select 1 option(s):

ABS(Number)

CEILING(Number)

FLOOR(Number)

ZN(Number)

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

Select 2 option(s):

Measure Names

Number of Records

Measure Values

Calculated Fields

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

Select 1 option(s):

Tableau Data Extract (.tde)

Tableau Packaged Workbook (.twbx)

Tableau Bookmark (.tbm)

Tableau Workbook (.twb)

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

Select 1 option(s):

Tableau Reader

Tableau Desktop

Tableau Server

Tableau Public

Q14. What will the following function return?

Select 1 option(s):

LEFT("Tableau", 3)

An error

Tab

eau

ble

Q15. The row and column shelves contain ___________________

Select 1 option(s):

Pills

Grand Totals

Filters

Parameters

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

Select 1 option(s):

parameters

duplicates

copies

aliases

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

Select 1 option(s):

join

blend

concatenate

union

Q18.

What is this view referred to as in Tableau?

Select 1 option(s):

Analytics Pane

Window Pane

Data Pane

Dimensions & Measures

Q19. DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?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?

Select 1 option(s):

United States

France

United Kingdom

Canada

Q20. 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?

Select 1 option(s):

28.42%

23.50%

25.68%

22.40%

Q21. 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)

Select 1 option(s):

76.25

65.67

68.77

74.87

Q22. 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?

Select 1 option(s):

68,620

74,683

37455

46,493

Q23. 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?

Select 1 option(s):

25.79%

23.39%

27.73%

29.49%

Q24. 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?

Select 1 option(s):

Q25. 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?

Select 1 option(s):

0.783262

0.739284

0.759329

0.748472

Q26. Which of the following are valid ways of Grouping Data?

Select 3 option(s):

Using Labels in the View

Using Marks in the view

From the Analytics Pane

From the Dimensions Shelf

Q27. As a general best practice, how many categories can a pie chart display effectively?

Select 1 option(s):

3 to 5

2 to 5

3 to 7

2 to 8

Q28. Which of the following is NOT a new feature introduced in Tableau 2020.1?

Select 1 option(s):

Set Control

Dynamic Paramaters

Buffer Calculations

Viz Animations

Q29. 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?

Select 1 option(s):

Parameters

Calculation

Groups

Sets

Q30. A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Select 1 option(s):

Go to Hyperlink

Go to Web page

Go to URL

Go to Sheet

Q31. Dimensions containing and values cannot be continuous.

Select 2 option(s):

Date

Boolean

Date and Time

String

Q32. Which of the following is true about ‘Incremental refresh’ when creating Extracts in Tableau?

Select 1 option(s):

There is no difference, both are the same when using extracts. They are different when using live connections.

It only adds rows that are new since the previous refresh.

They can only be used with large datasets

It replaces all of the contents in the extract

Q33. Which of the following is an example of a Date Part?

Select 1 option(s):

Q4 2017

20-Sep

19-Mar

November

Q34. 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 dont have access to the original data.

Select 1 option(s):

.twb file

.twbx file

.tbm file

.tde file

Q35. _________________ 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.

Select 1 option(s):

.tde files

.twbx files

.twb files

.tbm files

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

Select 1 option(s):

Monitor, Default, Phone, Tablet

Phone, Tablet, Laptop, Desktop

Default, Phone, Tablet, Desktop

Phone, Monitor, Laptop, Default

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

Select 1 option(s):

In the Tableau Main Menu, Choose Worksheet and select Create > Set

In the Data pane, right-click a measure and select Create > Set.

In the Data pane, right-click a dimension and select Create > Set.

In the Tableau Main Menu, choose Dashboard and select Create > Set

Q38. You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Select 1 option(s):

In My Computer -> C: -> Tableau -> Shapes

In My Documents -> My Tableau Repository -> Shapes

In Program Files -> Tableau -> Shapes

In Downloads -> My Tableau Repository -> Shapes

Q39. What information is stored in a .tds file? Choose all that apply.

Select 3 option(s):

Metadata edits

Data extracts

Visualisations

Data Connection information

Calculated Fields

Q40. True or False: It is possible to blend axes for multiple measures into a single axis

Select 1 option(s):

FALSE

TRUE

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

Select 2 option(s):

Using the Data Pane

Using the Analytics Pane

Using the Marks shelf

From the Analysis Tab in the Menu bar on top

Q42. If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

Select 1 option(s):

disaggregate

aggregate

split

sort

Q43. How does Tableau know at which level to aggregate values?

Select 1 option(s):

Values are always aggregated at the level of the Date Part

Aggregation is always done by using Tableau special formulas

Values are always aggregated at the level of granularity of the worksheet.

Tableau doesn't aggregate values, we do!

Q44. According to Tableau’s ‘Order of Operations’, which of the following filters is applied FIRST?

Select 1 option(s):

Measure Filter

Context Filter

Extract Filter

Dimension Filter

Q45. If you see the following Filter, then you’re working with _______________________

Select 1 option(s):

Date Functions

Grouped Dates

Date Values

Date Parts

Q46. When using the manage metadata option, we can create custom names for columns where _ is the original name of the column whereas _ is the custom name we created in Tableau.

Select 1 option(s):

Local Name, Actual Name

Remote Field Name, Field Name

Column Name, Actual Name

Local Field, Global Field

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

Select 1 option(s):

Edit the labels

Change the colours

Hide the axis

Synchronise the axis

Q48. ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

Select 1 option(s):

.twb

.tbm

.tde

.tds

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

Select 1 option(s):

1 dimension

2 measures

2 dimensions

1 measure

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

Select 1 option(s):

Manual

Random

Topological

Hierarchical

Q51. True or False: You get different filtering options for categorical and quantitative data

Select 1 option(s):

FALSE

TRUE

Q52. When using Animations in a Tableau, which of the following is the default duration for animations?

Select 1 option(s):

0.3s

0.4s

0.2s

0.5s

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

Select 1 option(s):

By double clicking on the measure, and then choosing Window -> Default Aggregation

By changing its properties manually every time we need to use it

By right clicking the dimension -> Default properties and choosing Aggregation

By right clicking the measure -> Default properties and choosing Aggregation

Q54. If you use a percent difference Quick Table Calculation, what value will be the first data value?

Select 1 option(s):

-1

null

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

Select 1 option(s):

dimension, measure

Data type, Value

ID, Key

type, role

Q56. Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Select 1 option(s):

Using 1 measure

Using 2 dimensions and 3 measures

Using 2 dimensions

Using 2 measures

Q57. Which of the following shapes does a Heat Map use by default?

Select 1 option(s):

Text

Square

Circle

Line

Q58. Which of the following are valid objects when creating a dashboard in Tableau?

Select 4 option(s):

Image

Text

Extension

Web Page

Video

Q59. What does the following icon do in Tableau?

Select 1 option(s):

Create a Dashboard

Create a Story and Dashboard both

Create a Worksheet

Create a Story

Q60. Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

Select 3 option(s):

SMTP

FTP

HTTP

HTTPS

Q61. The View Data window displays as much of the data as possible by default, up to _______________ rows.

Select 1 option(s):

10000

15,000

5,000

20,000

Q62. Most viewers scan content starting at the _____________ of a page.

Select 1 option(s):

top left

center

bottom left

top right

bottom right

Q63. In Tree maps, the size begins with the largest rectangle on the and the smallest rectangle on the .

Select 1 option(s):

top left, bottom right

top right, bottom left

top right, bottom right

top left bottom left

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

Select 1 option(s):

Dimensions and Measures

Rows and Columns

Labels and Values

Numbers and Headers

Q65. You may create a context filter to:

Select 2 option(s):

To create a dependent filter

Improve performance

To replace a data source filter

Create a dependent numerical or top N filter

Tableau Desktop Specialist Test-2

Q1. True or False: Tableau can create worksheet-specific filters

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

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

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

Q5. The calculation [Ship Date] – [Order Date] will return _______________

Q6. What term is used to describe the following picture?

Q7. 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.

Q8. _________ is a technique in Tableau which will identify marks with similar characteristics

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

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

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

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

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

Q14. What will the following function return?

Q15. The row and column shelves contain ___________________

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

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

Q18.

Q19. DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven’t already)

Q20. 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?

Q21. Using the atheletes table:

Q22. 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?

Q23. 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?

Q24. 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?

Q25. 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?

Q26. Which of the following are valid ways of Grouping Data?

Q27. As a general best practice, how many categories can a pie chart display effectively?

Q28. Which of the following is NOT a new feature introduced in Tableau 2020.1?

Q29. 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?

Q30. A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Q31. Dimensions containing ____________ and ____________ values cannot be continuous.

Q32. Which of the following is true about ‘Incremental refresh’ when creating Extracts in Tableau?

Q33. Which of the following is an example of a Date Part?

Q34. 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.

Q35. _________________ 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.

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

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

Q38. You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Q39. What information is stored in a .tds file? Choose all that apply.

Q40. True or False: It is possible to blend axes for multiple measures into a single axis

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

Q42. If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

Q43. How does Tableau know at which level to aggregate values?

Q44. According to Tableau’s ‘Order of Operations’, which of the following filters is applied FIRST?

Q45. If you see the following Filter, then you’re working with _______________________

Q46. When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

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

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

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

Q51. True or False: You get different filtering options for categorical and quantitative data

Q52. When using Animations in a Tableau, which of the following is the default duration for animations?

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

Q54. If you use a percent difference Quick Table Calculation, what value will be the first data value?

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

Q56. Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Q57. Which of the following shapes does a Heat Map use by default?

Q58. Which of the following are valid objects when creating a dashboard in Tableau?

Q59. What does the following icon do in Tableau?

Q60. Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

Q61. The View Data window displays as much of the data as possible by default, up to _______________ rows.

Q62. Most viewers scan content starting at the _____________ of a page.

Q63. In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________ .

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

Q65. You may create a context filter to:

Q31. Dimensions containing and values cannot be continuous.

Q34. 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 dont have access to the original data.

Q46. When using the manage metadata option, we can create custom names for columns where _ is the original name of the column whereas _ is the custom name we created in Tableau.

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

Q63. In Tree maps, the size begins with the largest rectangle on the and the smallest rectangle on the .