Friday 8 February 2019

Tableau - VII

The questions in this article and series of posts are oriented more towards Desktop Specialist accreditation that is the first of the Tableau Desktop Exams series. However, these questions may be helpful for preparation for other Tableau Certification Exams as well

Answers to previous post are given below:

76. d
77. a
78. c
79. b
80. b,d
81. c
82. a
83. c
84. b
85. d
86. a
87. c
88. b
89. d
90. c

The next batch of question are given below:

91. Which of the following is not a valid member of Marks card?











92. Context filters can be used to: (Choose all that apply)

a) improve performance
b) improve deployment across the enterprise
c) act as a dependent filter
d) help in testing of sheets

93. Which of the following are valid Dashboard actions? (Choose all that apply)

a) Highlight
b) Go to URL
c) Change Set Values
d) Filter

94. It is possible to disaggregate measures in Tableau by

a) Setting the data type of a measure to default
b) Using Replace References on Measure values
c) Using Aggregate Measures under Analysis
d) Setting Percentage Of to None under Analysis

For all the below questions, use data file:

95. The Profit Ratio for Corporate Segment for 2012 is

a) 0.1626
b) 0.1526
c) 0.2471
d) 0.1497

96. If we create a histogram of Sales showing the number of Sales using bin size $2500, the number of bins having a single member is

a) 7
b) 8
9) 9
d) 10

97. If we create a histogram of Sales showing the number of Sales using bin size $2000, the number of bins having 4 members is

a) 1
b) 2
9) 3
d) 4

98. If we create a histogram of Sales showing the number of Sales using bin size $2000, the number of bins having 2 members is

a) 1
b) 2
9) 3
d) 4

99. If we create a histogram of Sales showing the number of Sales using bin size $2000, the Profit of bins having second highest members is

a) 261964
b) 184938
9) 136243
d) 295579

100. Which customer contributed to maximum Sales in October 2010?

a) Nina Home Kelly
b) Luis Kerr
c) Penny Leach
d) Sally Liu

101. For Region South, the least profitable Product Sub-Category contributed to the highest Sales

a) True
b) False

102. For regions South and East put together, the least profitable Product Sub-Category contributed to the second highest Sales

a) True
b) False

103. What is the number of regions in which at least two Product Categories are above the Overall Average Profit?

a) 1
b) 2
c) 3
d) 4

104. The Region having the second highest median of Quantity ordered new for the different Product Categories is

a) Central
b) West
c) South
d) East

105. The percentage of Sales of products ordered with High and Critical Priority for Customer Segments Home Office and Small Business is

a) 12.83
b) 15.95
c) 17.41
d) 16.93

All luck to solving ...