Tableau Question with the answer for practice.
Created
by Arabinda Mohapatra
1. To connect
to multiple tables in a single data source at one time, what must be specified?
a. A blend
b. A
calculation
c. A join
d. A hierarchy
2. Tableau can
create worksheet-specific filters.
a. True
b. False
3. What does
the box in a box plot represent?
a. Maximum
extent of the data
b. The range of the middle half of the data points
c. The median
of the middle half of the data points
d. The outliers
of the data
4. The interquartile range is the difference between the 2nd and 3rd
quartiles.
False
5. The median is the number separating the lower half of the data from
the higher half. It is the same as the 50th percentile or the 2nd quartile.
True
6. The calculation [Ship Date] - [Order Date] will return
number of days
between them
7. What is wrong with this If Statement If [Sales] > 100 and
"Delivery Truck" then 0 else [Shipping Cost] End
id shld be [shipping
mode] = ‘Delivery truck’
8. What will the function Left(3,"Tableau") return?
error
9. All rows from both tables are returned in an INNER JOIN.
False
10. LEFT JOIN returns all rows from the left table, with the matching
rows in the right table.
True
11. 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.
True
12. The term
“addressing” refers to the direction of a calculation.
True
13. SUM is a table
calculation.
False
14. The benefits of
creating a Tableau data extract include improving performance and allowing
offline access to the data.
True
15. The metadata grid displays the fields in your data
source in columns.
False
16. _______ is a
technique in Tableau which will identify marks with similar
characteristics.
Clustering
17. Which of the
following is used to assess trendline significance:
p-value
18. If you would like
your Top N or Bottom N set to change depending on what filter choices are
changed, what type of filter should use use?
Context Filters
19. Sorts can break the
dimension hierarchy. In other words, Tableau will rearrange any the headers of
the fields that appear to the left of the sorted field.
False
20. Which of the following are generated fields in
Tableau? (select all that apply)
Number of Records, Measure Names
21. Pareto charts
combine the following elements
22. Bullet graphs
combine bar charts and reference lines
True
23. You want to email a
packaged workbook containing a Tableau Dashboard to a coworker who does not
have a license for Tableau Desktop. Which application will allow her to view
the dashboard you send via email?
Tableau Reader
24. A visual best
practice is that if you are using a color gradient to represent a continuous
variable which can be negative or positive, you should use a single color
range
False
25. The AVG function
does not treat null values as zeros. Rather, the AVG function ignores null
values.
True
26. An aggregated calculation can be
multiplied by a non-aggregated constant.
true
27. When using
a _____ join the result is a table that contains all values from the left table
and corresponding matches from the right table.
left
28. If you see
duplicate data after doing a join you may be able to eliminate the duplication
by which of the following?
Combine the
tables using a cross database join rather than a standard join
Add a duplicate
filter to your data
Change the join condition
Change to a
full outer join
29. _______ is
a tendency to increase or decrease over time
Seasonality
Slope
Trend
Gradient
30. Which of
the following graph types provide information on the distribution of a
continuous measure?
Pie
Chart
Heat
Map
Box Plot
Packed
Bubbles
31. Positive
skewness means the extreme values are to the right, while negative skewness
means the extreme values are to the left.
true
32. When you
sort data in a hierarchy, Tableau rearranges headers that appear before the
sorted field. false
33. Context Filters
are executed after data source filters.
true
34. Tableau
displays an axis when you drop this onto the Rows or Column shelf.
Continuous
field
Discrete
field
Measure names
Measure
values
35. Gantt
charts are useful for:
Showing
changes to a continue variable over time
Displaying duration of events or activities
over time
Showing
how a measure varies with respect to one or more dimensions
Display
the distribution of a continuous variable
36. Bins acts as containers that summarize
data for a specific range of values. Without using a calculated field,
Tableau's bin feature allows you to create variable sized bins.
false
37. You can
combine multiple worksheets in a single dashboard.
true
38. If a dashboard is difficult to view on a smartphone, you can use the _____
designer to create a phone-specific view of your dashboard:
device designer
39. A ___
action allows Tableau to open a page on an external website.
URL
40. To connect
to multiple tables in a single data source at one time, what must be specified?
A Blend
A Calculation
A join
A hierarchy
41. What is the
use of data interpreter option in tableau?
To structure the unstructured data
To interpret
the data
For predictive
analysis
All of these
42. While using
custom sql option during data connection, which options get disable/removed
from data page?
Data
interpreter
Union
Both A and B
None of these
43. When to use
extract option in tableau? – MCQ (Select all that apply)
When you want to embed data inside tableau file
when you want to share the file without sharing the
data connection information
When you want
to store the connection path
When you want to compress the data
44. To add cross data source join ______ must be specified
Type of join
Relation
Primary and
foreign key
None of these
45. If I changed the layout of worksheet from standard to
fit entire view and next I changed the chart using show me, what will be the
layout of the worksheet?
Standard
Fit width
Fit height
Fit entire view
46. What is the correct way to calculate price of a product?
Sum(sales)/sum(quantity)
Sum(sales/quantity)
Sales/quantity
47.Which columns you cannot delete in tableau – MCQ
Measure names
Measure values
Number of records
Longitude
48. You cannot change a dimension to continuous
True
False
49. You cannot create bins of measures?
True
False
50. Latitude and longitude are tableau generated fields
True
False
51. We can use measure names in creating custom column
True
False
52. For bullet graph, you need ____ dimensions?
1
2
0 or more
All of these
53. For creating line chart, what is required?
Date field
Continuous
field
Both A and B
54. What is the color of attribute in tableau?
Blue
Green
Black
None of these
55.In shelf calculated columns are
Worksheet
specific
Field specific
Workbook specific
Data specific
56. What is the color of tik mark on primary and secondary
data source?
Blue, orange
Orange, blue
Blue, blue
Orange, orange
57. A dimension
is a field that typically holds
discrete qualitative data
58. Dates are
typically treated as
dimensions
59. The 
icon
next to a field means that field is
geographic
60. Which of
the following charts types always includes bars sorted in descending
order?
Pareto Chart
61. Which of
the following charts uses binned data?
Histogram
62. If a field
has a blue background, that means the field is
discrete
63. When might
you want to use a context filter?
When you want to FIRST apply a filter
and THEN show the Top N or Bottom N elements
64.This type
level of detail expression computes total sales for the region, regardless of
what dimensions are shown in the view.
{ FIXED [Region] : SUM([Sales]) }
65.Adding a
dimension to the row or column shelf will filter your data.
False
66. Suppose
that your data has a dimension called "Product Category," which has
the values "Furniture," "Office Supplies," and
"Technology." Which of the following should you use to combine
Furniture and Office Supplies into a single category?
Hierarchy
67. All rows
from both tables are returned in an INNER JOIN.
False
68. LEFT JOIN
returns all rows from the left table, with the matching rows in the right
table.
True
69. 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.
True
70) What is the
colour of Discrete Measures in Tableau?
RED
ORANGE
BLUE
GREEN
71) For Bullet
Graphs we need at-least ____________ measures
3
4
2
1
72) Which graph
is the best to show Comparison between Actual and Target measures ?
Heat Map
Bullet Graph
Bar
Line
73) Which
Aggregate Function is used to calculate Distinct Count ?
AVG()
COUNT()
COUNTD()
SUM()
74) Which is
not an LOD function out of below ?
INCLUDE
FIXED
INDEX
EXCLUDE
75) Which is
not an action out of below ?
Filter
URL
Tooltip
Running
76. ________ is
used to distribute these interactive workbooks and/or reports to the right
audience
Sets
Tableau
Server
Tableau
Public
Tableau Desktop
77. Tableau 10
new feature can Join data from_________ data source(s) and can connect to
________
different,
text file
same, excel
sheet
same, oracle
DB
different, google sheet
78. Which is
not a new feature in TABLEAU 10?
Now you can Blend data from different data
sources
Access to
Oracle Procedure
Catch extract
refresh issues before they become a problem. Tableau can alert you to possible
extract refresh issues via email, so you can quickly resolve them.
The updated
Tableau Online Sync client now emails data source owners if a refresh fails.
79. Below is an
example of Continuous field (by default)?
Sales
Customer
Segment
Date
Product
Category
80. Which is a
false statement about Parameter ?
Parameters can't be used in calculation.
Parameters
can access across different Data Sources
We can Select
Parameters via 4 ways only
Parameters
can make static values dynamic.
81. Which is
not a Filter?
Extract
Filter
Context
Quick Filter
Tooltip Filter
82. Parameters
can be used in
Dimension
Filters
Tooltip
Summary
Quick Filter
83. Which language does Tableau support for data
manipulation while importing the dataset?
a. SQL
b. R
c. Both A and B
d. None of these
84. Which of the following returns Absolute
value of a given number?
a.
ABS(number)
b. ATTR(number)
c. CEILING(number)
d. None of above
85. How data is stored in .tde file ?
a. Row wise
b. Column
wise
c. Document type
d. None of above
86. If blending is applied, then is it necessary
to drop common field in a view containing fields of two different data sources
on which blending is applied a
. True
b. False
87. If we drop 2 measures in rows/columns, what
will be the output
a. Axis
b. Bar chart
c. Scatter Chart
d. None of these
88. Best use of bullet graph
a. To
compare two measures
b. Correlation
c. Graphical representation
d. A and B
89. Link to data is shown in which tab
a. Home Page
b. Data
source page
c. First Page
d. All of these
90. Given a map, find out fields placed in
size,shape,detail,color
a. Country,profit,state,sales
b. Longitude, latitude
c. Sales,
state, country, profit
d. State, country, longitude, latitude
91. which is the aggregate way to calculate
profit ratio:
a. sum(profit/sales)
b. profit/sales
c. sum(profit)/sum(sales)
92. Tableau cannot group the bins
a. True
b. False
93. Null values are considered along with other
items in column while using count function
a. True
b. False
94. Which chart is used to show interquartile
range in tableau?
a. Treemap
b. Gantt chart
c. Box
and whisker plot
95. To use quick table calculations, what type
of programming is required?
a. Java
b. SQL
c. Php
d. None
of these
96. Sorting can be done at following levels
a. Data
source order, Alphabetic, Field and manual
b. Data source order, Alphabetic and Field
c. Data source order and Alphabetic
d. Alphabetic and Field
97. How to use parameterized value to filter the
view in worksheet?
a. Data filter
b.
Calculated field
c. Context filter
d. Bin
98. You cannot select a measure that isn’t
currently in the view as the basis for your reference line
a. True
b. False
99. What type of connection is the given
pic below?
If the provided information is found wrong, please do correct it by sending mail to arabindamohapatra@outlook.com
No comments:
Post a Comment