TDS-C01 Dumps (V11.03) – Check New Updated Exam Questions to Prepare for the Tableau Desktop Specialist Exam

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

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

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

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

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

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

7. Which of the following chart type makes use of 'binned' data?

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

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

10. Is SUM a table calculation?

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

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

13. For Bullet Graphs we need at least ____________ measures

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

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

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

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

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

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

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

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

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

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

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

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

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

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

28. What was the Store count in 2017 for Texas (TX)?

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

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

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

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

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

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

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

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

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

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

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

39. For creating variable sized bins we use __________________

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

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

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

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

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

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

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

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

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

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

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

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

52. Dates in Tableau are typically treated as ______________

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

54. Larger image

What is this entire view referred to as in Tableau?

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?

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

57. Create a Set containing Customer Names whose Sales are GREATER than 30,000.

Which customer had the LEAST sales in this set?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

76. Which of the following 2 columns CANNOT be deleted in Tableau?

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

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

79. What will the following function return?

LEFT("Tableau", 3)

80. The row and column shelves contain ___________________

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

82. You can _______________ your data to combine two or more tables by appending values (rows)

from one table to another

83. Larger image

What is this view referred to as in Tableau?

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

85. 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 the total publications were contributed in 2014?

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

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

88. 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 sales does this group contribute?

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

90. Question 30: Skipped

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?

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

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

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

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

95. You want to add Custom shapes to your visualisation.

Where can you add these new shapes?

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

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

98. If you see the following Filter, then you're working with _______________________ Larger image