Saturday 23 February 2019

Tableau - X

This will be the last post on questions for Tableau Certification. In all, there are a total of 150 questions across 10 posts. I am pleased to inform that I have completed the Tableau Desktop Specialist Certification. The best part about this certification is that it has no expiry

Like in last 9 posts, the questions in this article 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:

121. a,b
122. b,c,d
123. a,b,c,d
124. a,c,d
125. d
126. a
127. b
128. a,c
129. d
130. b,c
131. a,d
132. b
133. a,c,d
134. b
135. a

The last batch of questions are below:

136. Legend highlighting can be used to to draw users' attention on specific marks in a view

a) True
b) False

137. Two modes of highlighting are

a) Default highlighting
b) One-way highlighting
c) Two-way highlighting
d) Three-way highlighting

138. The steps to creating a visual group does not involve: (Choose all that apply)

a) Click on paperclip icon
b) Select marks in view
c) Click View Data icon in Data Pane
d) Describe Sheet... using Worksheet menu

139. Continuous fields in below list are: (Choose all that apply)

a) 1970
b) June
c) Q3
d) Week 1, 2013

140. Size property on Marks card gives the user to control size of Shapes in view

a) True
b) False

141. Multiple copies of same dashboard suited to each device have to be created for viewing on different mobile devices:

a) True
b) False

142. Multiple URLs of same dashboard have to be created for viewing on different mobile devices:

a) True
b) False

143. Parameters are constant values that can replace variable values in calculations, filters, and reference lines or bands

a) True
b) False

144. It is not possible to prefix a currency field with a custom currency notation like EUR in a sheet

a) True
b) False

For all the below questions, use data file:

145. With the available data, the Manager contributing to maximum returns is:

a) Chris
b) Erin
c) Sam
d) William

146. With the available data, the percentage of returned orders is

a) 2.51%
b) 0.24%
c) 1.04%
d) 3.45%

147. The combination of Dimensions: Region, Product Category, and Product Sub-Category that contributed to 5th highest sales for the entire period is:

a) East, Technology, Telephones and Communication
b) Central, Technology, Telephones and Communication
c) East, Furniture, Chairs & Chairmats
d) West, Technology, Telephones and Communication

148. Create a sheet with States versus Sales showing the lowest 5 states by Sales and another sheet with States versus Product Base Margin. Then, create a dashboard with both these sheets. The state having third largest Sales has ______ largest Product Base Margin

a) first
b) second
c) third
d) fourth

149. Two states that are diametrically opposite to each other but having the top sales are: (Choose all that apply)

a) Texas and Washington
b) Florida and Washington
c) New York and California
d) California and New York

150. The least quantity has been ordered by:

a) Michigan
b) Wyoming
c) Delaware
d) North Dakota

The answers to above questions are below:

136. a
137. b,c
138. c,d
139. a,d
140. a
141. b
142. b
143. b
144. b
145. d
146. c
147. a
148. b
149. c,d
150. c

This concludes the last of this series

Wishing All Luck for Tableau Certification!!!