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. These questions may be helpful for preparation for other Tableau Certification Exams as well
Answers to previous post are given below:
61. b
62. d
63. a
64. b
65. b
66. d
67. c
68. a
69. b
70. a
71. c
72. a
73. a
74. a,c,d
75. a
The next set of question are given below:
76. Which of the following is not a keyword for calculation of LOD in Tableau?
a) INCLUDE
b) FIXED
c) EXCLUDE
d) UNFIXED
77. Which of the following statements are false? (Choose all that apply)
a) .tde files are Tableau data extract files that can be refreshed
b) .tds files are Tableau data source files that has details of data source connection and calculated fields
c) .tdsx files are Tableau data source files that contain data as .tde files that can be refreshed
d) .tbm files are Tableau bookmark files that has details about individual worksheets
78. Which customer has the highest profit ratio based on below data?
Customer Order Id Sales
Marjorie Owens 90454 105.88
Stacey Davenport 68756 34.27
Arlene Lutz 45464 634
Rhonda Ivey 97655 54.65
Marjorie Owens 90452 27.76
Rhonda Ivey 97650 13.4
Stacey Davenport 68703 157.4
Arlene Lutz 45400 345.32
a) 340.2
b) 328.3
c) 315.5
d) 321.9
89. Using cross tabulation for Company by year for the period 2010-14, representing Volume of shares as a percentage of the total table shows the percentage for Amazon, Apple, and Biogen Idec for 2014 as?
a) 0.60, 9.58, 0.35
b) 0.98, 10.43, 0.45
c) 1.98, 10.50, 0.75
d) 0.68, 10.51, 0.24
90. For June 2011, the difference of Average High price and Average Low price for Amazon is
a) 5.292
b) 5.489
c) 5.919
d) 5.699
Answers in later posts ...
Answers to previous post are given below:
61. b
62. d
63. a
64. b
65. b
66. d
67. c
68. a
69. b
70. a
71. c
72. a
73. a
74. a,c,d
75. a
The next set of question are given below:
76. Which of the following is not a keyword for calculation of LOD in Tableau?
a) INCLUDE
b) FIXED
c) EXCLUDE
d) UNFIXED
77. Which of the following statements are false? (Choose all that apply)
a) .tde files are Tableau data extract files that can be refreshed
b) .tds files are Tableau data source files that has details of data source connection and calculated fields
c) .tdsx files are Tableau data source files that contain data as .tde files that can be refreshed
d) .tbm files are Tableau bookmark files that has details about individual worksheets
78. Which customer has the highest profit ratio based on below data?
Customer Order Id Sales
Marjorie Owens 90454 105.88
Stacey Davenport 68756 34.27
Arlene Lutz 45464 634
Rhonda Ivey 97655 54.65
Marjorie Owens 90452 27.76
Rhonda Ivey 97650 13.4
Stacey Davenport 68703 157.4
Arlene Lutz 45400 345.32
Profit Order Id
-2.54 68756
8.98 90454
63.98 45400
-1.67 97650
5.87 90452
-9.28 97655
-73.67 45464
23.53 68703
a) Stacey Davenport
b) Rhonda Ivey
c) Marjorie Owens
d) Arlene Lutz
79. Which customer has the lowest profit ratio based on above data?
a) Marjorie Owens
b) Rhonda Ivey
c) Arlene Lutz
d) Stacey Davenport
80. Which customers have a negative profit ratio based on above data? (Choose all that apply)
a) Stacey Davenport
b) Rhonda Ivey
c) Marjorie Owens
d) Arlene Lutz
81. The average of the profit ratios based on above data is
a) 0.1125
b) 0.1145
c) 0.0125
d) 0.0155
Use Sample data for all the following questions:
82. Which consecutive quarters had nearly the same volumes of shares?
a) Q4 2013 - Q1 2014
b) Q1 2012 - Q2 2012
c) Q3 2014 - Q4 2014
d) Q1 2013 - Q2 2013
83. The maximum variance of volumes is seen in
a) Q2 2011
b) Q4 2013
c) Q4 2014
d) Q4 2010
84. For Biogen Idec, which year saw the lowest volume of shares?
a) 2011
b) 2012
c) 2013
d) 2014
85. For the given data across all the years, Standard Deviation of volume is
a) 95546787
b) 65094763
c) 59605789
d) 62591026
86. For 2012, the difference between the maximum and minimum average Close price is
a) 138.00
b) 151.73
c) 126.85
d) 190.64
87. For January 2013, the average Low price for Biogen Idec is
a) 140.5
b) 151.3
c) 144.9
d) 136.7
88. For June 2014, the average High price for Amazon is
a) Q4 2013 - Q1 2014
b) Q1 2012 - Q2 2012
c) Q3 2014 - Q4 2014
d) Q1 2013 - Q2 2013
83. The maximum variance of volumes is seen in
a) Q2 2011
b) Q4 2013
c) Q4 2014
d) Q4 2010
84. For Biogen Idec, which year saw the lowest volume of shares?
a) 2011
b) 2012
c) 2013
d) 2014
85. For the given data across all the years, Standard Deviation of volume is
a) 95546787
b) 65094763
c) 59605789
d) 62591026
86. For 2012, the difference between the maximum and minimum average Close price is
a) 138.00
b) 151.73
c) 126.85
d) 190.64
87. For January 2013, the average Low price for Biogen Idec is
a) 140.5
b) 151.3
c) 144.9
d) 136.7
88. For June 2014, the average High price for Amazon is
a) 340.2
b) 328.3
c) 315.5
d) 321.9
89. Using cross tabulation for Company by year for the period 2010-14, representing Volume of shares as a percentage of the total table shows the percentage for Amazon, Apple, and Biogen Idec for 2014 as?
a) 0.60, 9.58, 0.35
b) 0.98, 10.43, 0.45
c) 1.98, 10.50, 0.75
d) 0.68, 10.51, 0.24
90. For June 2011, the difference of Average High price and Average Low price for Amazon is
a) 5.292
b) 5.489
c) 5.919
d) 5.699
Answers in later posts ...
