Thursday, 21 February 2019

Tableau - IX

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:

106. a
107. b
108. b,c
109. a,b,c
110. d
111. a,d
112. a,b,c,d
113. a,c,d
114. d
115. c
116. a
117. a,b,c,d
118. b
119. d
120. b,c,d

The next set of questions are below:

121. Which of the following are relevant to a measure: (Choose all that apply)

a) They are numeric and measurable quantitative values
b) They can either be discrete or continuous
c) They cannot be aggregated
d) They affect level of detail in view

122. Which of the following are relevant to a dimension:  (Choose all that apply)

a) They do not affect the level of detail in a view
b) They can either be discrete or continuous
c) They are qualitative in nature
d) They can be use to segment data

123. A date function like DATEDIFF can be used to calculate: (Choose all that apply)

a) Difference between two dates in terms of weeks
b) Difference between two dates in terms of days
c) Difference between two dates in terms of years
d) Difference between two dates in terms of months

124. A .tds datasource file contains information about: (Choose all that apply)

a) connection details
b) measures data
c) default field properties like formats, sort order, etc
d) sets, bins, groups, calculated fields

125. Which of the following can have aliases: (Choose all that apply)

a) Measure Values
b) Measures
c) Date Field
d) Discrete Dimension
e) Number of Records

126. It is possible to print a workbook as PDF

a) Yes
b) No

127. Adobe Acrobat should be installed for a view to printed as PDF

a) Yes
b) No

128. Which of the following is not a table calculation or is not obtained by a calculated expression: (Choose all that apply)

a) Percentile 50
b) Difference
c) Variance
d) Percentage of Cell

129. If we wish to see the percentage of each component in a stacked bar as a percentage, the computation has to be at the level of:

a) Table (across)
b) Table (down)
c) Table
d) Cell

130. Dropping the Number of Records on the Rows Shelf contributes to: (Choose all that apply)

a) 2 marks
b) The same number of Marks if Number of Records is dropped on the Column Shelf
c) 1 mark
d) 3 marks

131. If Tableau perceives that there is a field that can be assigned a Geographical role: (Choose all that apply)

a) It automatically adds Latitude and Longitude under Measures
b) It automatically adds Latitude and Longitude under Measures only if data is about states
c) It automatically adds Latitude and Longitude under Measures only if data contains cities
d) The Latitude and Longitude though not part of data are called Latitude (generated) and Longitude (generated)

132. While setting up a Filter, the result of  filter condition set up on General tab and Wildcard tab is equivalent to:

a) the filter conditions are acted upon by an or operator
b) the filter conditions are acted upon by an and operator
c) the filter conditions and acted upon by minus operator
d) the filter conditions are acted upon by an or followed by an or operator

133. It is possible to invoke external URLs from Dashboards in Tableau but: (Choose all that apply)

a) When a URL is called from a Web Page object embedded in a dashboard, the URL is rendered within the dashboard
b) When a URL is called from a Web Page object embedded in a dashboard, the URL is rendered in an external browser
c) When a URL is called from a Web Page object embedded in a dashboard, this object can be set up as a floating object
d) When a URL is called as part of action, the URL is rendered in an external browser

134. Continuous fields add headers to a sheet and discrete fields add axes to a sheet

a) Yes
b) No

135. Format Font can be used to format font on Worksheet, Pane, Header, etc

a) Yes
b) No

Answers in next post ...