Tableau Desktop Specialist Test -1

Welcome to your Tableau Desktop Specialist - Test-1

Name

Phone

Q1. True or False : Bins can be created on dimensions

Select 1 option(s):

FALSE

TRUE

Q2. True or False: The Highlighting action can be disabled for the entire workbook.

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

Yes

Q4. By definition, Tableau displays measures over time as a ____________

Select 1 option(s):

Packed Bubble

Bar

Stacked Bar

Line

Q5. Which of the following would you use to connect to multiple tables in a single data source at once?

Select 1 option(s):

A Blend

A Hierarchy

A Set

A Join

Q6. What is the minimum amount of RAM recommended for any production use of Tableau Server?

Select 1 option(s):

8GB

16GB

32GB

64GB

Q7. Which of the following chart type makes use of ‘binned’ data?

Select 1 option(s):

Gantt Chart

Bullet chart

Histogram

Treemaps

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

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

TRUE

FALSE

Q10. Is SUM a table calculation?

Select 1 option(s):

Yes

Q11. By default, measures placed in a view are aggregated. The type of aggregation applied ______________

Select 1 option(s):

is always COUNT

is always AVERAGE

depends on the context of the view

is always sum

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

Select 1 option(s):

Data Cleanliness

Data granularity

Data connectivity

Data LOD

Q13. For Bullet Graphs we need at least ____________ measures

Select 1 option(s):

Q14. The default path for all supporting files, data sources, icons, logs etc is in ______________________

Select 1 option(s):

Documents -> Tableau Files

Documents -> Tableau

Documents -> My Tableau Repository

Downloads -> Tableau Support Files

Q15. Tableau auto-generates dimension(s) and _ measure(s) for us

Select 1 option(s):

1 , 4

2 , 2

2 , 3

1 , 2

Q16. We can join a maximum of ______ tables in Tableau

Select 1 option(s):

128

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

Select 3 option(s):

Improved Performance

Ability to use the data offline

Working with freshest data at all times

Faster to work with

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

Select 1 option(s):

Data source Filter

Extract Filter

Context Filter

None of the these

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

Select 1 option(s):

Save it as a .twm file

Save it as a .twb file

Save it as a .tds file

Save it as a .twbx file

Q20. True or False: It is possible to add a field to more than one hierarchy

Select 1 option(s):

TRUE

FALSE

Q21. How would you calculate GDP per capita in Tableau?

Select 1 option(s):

SUM([GDP]/[POPULATION])

SUM([Population]/[GDP]])

SUM([GDP]*[POPULATION])

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

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

Select 1 option(s):

Tableau Server

Tableau Prep

Tableau Public

Tableau myServer

Q23. Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing

Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

Select 1 option(s):

17-Sep

18-Mar

17-Dec

1/1/2018

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

Select 1 option(s):

111,060

1461

112,256

1,222

Q25. Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

Select 1 option(s):

96.46%

95.12%

97.12%

99.46%

Q26. Using the Orders Table (Sample Superstore ++ Dataset): Create a Map displaying all the States. Drag Sales to Label and Profit to Color on the marks Card. Find the State having the worst Profit in the Technology Category and the Ship Mode as Second Class. What is the Profit value of the State North to this State?

Select 1 option(s):

2854

$10,775

$19,683

$4,854

Q27. 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)?

Select 1 option(s):

592,593

293,202

416702

336,908

Q28. Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

Select 1 option(s):

16581

$147,950

$48,115

$33,768

Q29. Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

Select 1 option(s):

584

901

205

660

Q30. Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.

How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

Select 1 option(s):

Q31. Which of the following is not a Trend Line Model?

Select 1 option(s):

Linear Trend Line

Exponential Trend Line

Binomial Trend Line

Logarithmic Trend Line

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

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

Comparing the actual sales against the target sales

Analysing the trend over a given time period

Forecasting future sales

Displaying the year-on-year growth in sales

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

Select 1 option(s):

TRUE

FALSE

Q35. What does the box in a box plot represent?

Select 1 option(s):

Maximum value of the data

Minimum value of the data

The interquartile range

The median of the middle half of the data points

Q36. Which of the following are interactive elements that can be added to a dashboard for users?

Select 3 option(s):

URL Action

Filter Action

Highlight Action

Edit Tooltip Action

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

Select 1 option(s):

It is continuous

It is discrete

It is a dimension

It is a measure

Q38. For creating variable sized bins we use __________________

Select 1 option(s):

Calculated Fields

Table Calculations

Sets

Groups

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

Select 1 option(s):

TRUE

FALSE

Q40. True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

Python

Java

Javascript

None of these

Q42. Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Select 1 option(s):

Profit, State, Number of Records, Sales

Region, Country, Profit, State

Longitude, Country, State, Sales

Sales, State, Country, Profit

Q43. When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Select 1 option(s):

Red, Blue

Orange, Blue

Blue, Red

Blue, Orange

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

Select 1 option(s):

TRUE

FALSE

Q45. Which data type in Tableau does this icon represent?

Select 1 option(s):

String

True or False

Boolean

Geographic

Q46. For a relative date filter, the default anchor is _________________

Select 1 option(s):

The current time

Today's date

The target date

The date we specify

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

Select 1 option(s):

TRUE

FALSE

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

Select 3 option(s):

Hover

Click

Select

Double click

Q49. _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

Select 1 option(s):

Tableau Packaged Workbook (.twbx)

Tableau Workbook (.twb)

Tableau Data Extract (.tde)

Tableau Data Source (.tds)

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

Select 1 option(s):

Tableau Reader

Tableau Online

Tableau Server

Tableau Desktop

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

Select 2 option(s):

CSV file

PDF File

JSON format

MS Access Database

Q52. Dates in Tableau are typically treated as ______________

Select 1 option(s):

Dimensions

Measures

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

Select 1 option(s):

Data cleaner

Data manager

Data interpreter

Data organiser

Q54.

What is this entire view referred to as in Tableau?

Select 1 option(s):

Data pane

Analytics Pane

Summary Pane

Distribution Pane

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

Select 1 option(s):

150

147

140

156

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

Select 1 option(s):

Fasteners

Labels

Envelopes

Binders

Q57. Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Select 1 option(s):

Tom Ashbrook

Sanjit Engle

Penelope Sewall

Tamara Chand

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

Select 1 option(s):

5,129 and 88,872

52,678 and 311,404

1,807 and 34,571

4,888 and 17,817

Q59. Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Select 1 option(s):

3.84

3.704

3.5

Q60. Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Select 1 option(s):

Brazil

Peru

Argentina

Mexico

Q61. Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the systems web browser?

Select 1 option(s):

YES, we can do this with the help of a plugin

NO, this is not currently possible in Tableau

YES, we can do this with the help of a Web-Page object

YES, we can do this with the help of Tableau Public

Q62. How do you identify a continuous field in Tableau?

Select 1 option(s):

It is identified by a blue pill in the visualization

It is identified by a green pill in a visualization

It is preceded by a '=#' symbol in the data window

It is preceded by a 'Abc' symbol in the data window

Q63. True or False: Sets can be created on Measures

True or False: Sets can be created on Measures

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

Paper Clip

Globe

Intersection

#ERROR!

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

Select 1 option(s):

A discrete date part dimension

A continuous date value dimension

A geographical dimension

An aggregated measure

Q1. True or False : Bins can be created on dimensions

Q2. True or False: The Highlighting action can be disabled for the entire workbook.

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

Q4. By definition, Tableau displays measures over time as a ____________

Q5. Which of the following would you use to connect to multiple tables in a single data source at once?

Q6. What is the minimum amount of RAM recommended for any production use of Tableau Server?

Q7. Which of the following chart type makes use of ‘binned’ data?

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

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

Q10. Is SUM a table calculation?

Q11. By default, measures placed in a view are aggregated. The type of aggregation applied ______________

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

Q13. For Bullet Graphs we need at least ____________ measures

Q14. The default path for all supporting files, data sources, icons, logs etc is in ______________________

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

Q16. We can join a maximum of ______ tables in Tableau

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

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

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

Q20. True or False: It is possible to add a field to more than one hierarchy

Q21. How would you calculate GDP per capita in Tableau?

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

Q23. Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing

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

Q25. Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

Q27. 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)?

Q28. Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

Q29. Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

Q30. Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.

Q31. Which of the following is not a Trend Line Model?

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

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

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

Q35. What does the box in a box plot represent?

Q36. Which of the following are interactive elements that can be added to a dashboard for users?

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

Q38. For creating variable sized bins we use __________________

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

Q40. True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

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

Q42. Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Q43. When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

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

Q45. Which data type in Tableau does this icon represent?

Q46. For a relative date filter, the default anchor is _________________

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

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

Q49. _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

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

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

Q52. Dates in Tableau are typically treated as ______________

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

Q54.

Q55. 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! )

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

Q57. Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

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

Q59. Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Q60. Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

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

Q62. How do you identify a continuous field in Tableau?

Q63. True or False: Sets can be created on Measures

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

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

Q15. Tableau auto-generates dimension(s) and _ measure(s) for us

Q61. Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the systems web browser?