Tableau
Tableau
Tableau
False
True
Explanations:
A Reference Band can based on two fixed points.
7. A sheet cannot be used within a story directly. Either sheets should be used
within a dashboard, or a dashboard should be used within a story.
True
False
Explanations:
A sheet can be used within a story directly.
9. Is it possible to use measures in the same view multiple times (e.g. SUM of the
measure and AVG of the measure)?
No
Yes
Explanations:
Yes, measures can be used multiple times in the same view.
13. Trend Lines can only be used with numeric or date fields.
True
False
Explanations:
16. The icon associated with the field that has been grouped is a ______________.
Paper Clip
Set
Hash
Equal To
Explanations:
The icon associated with the field that has been grouped is a paper clip.
17. What is the profitable moving average in November 2013, including four months
prior and four months after?
$8,553
$8,256
$8,441
$7,501
Explanations:
The profitable moving average in November 2013, including four months prior and
four months after is $8,441.
18. The best trend model for your view would be the one with?
R-Squared value closest to 1
P-Value more than 1
R-Squared value greater than 1
R-Squared value equal to P-Value
Explanations:
R-Squared value closest to 1 is the best trend model for a view.
24. The default join type in case of Blended data sources is?
Cross Join
Inner Join
Left outer Join
Full outer Join
Explanations:
ANSWER: (C) Left outer Join is the default join type in case of Blended data
sources. The primary dataset is considered to be the left table.
D A & B
To share the same data source with multiple dashboards what type of data source can
be used
Embedded
Shared
Standalon
B & C
Discrete data roles can only take individual values within a range
True
False
Pdf
Image
Data
Word
ans a,b,c
True
False
Ans False
Use extract
Reduce scope
Reduce Number of marks
Use indexes in the database and use those fields for filtering
A,B,C,D
1. State the best reason for using an extract instead of a live connection?
You need to apply an aggregation that takes too long when using a live connection.
� You need to join tables that are in the data source.
Using the extract is the best option as an aggregation should be applied on a live
connection which takes too long.
-----------------------------------------------------------------------------------
--------------------------------------
2. State what should be used to create a calculated field that returns data
independent of the data granularity in a view?
� A table calculation
� A basic calculation
-----------------------------------------------------------------------------------
-----------------------------------------
� A blend
� A calculation
A join
� A hierarchy
A join has to be defined to link multiple tables from a single data source.
-----------------------------------------------------------------------------------
-----------------------------------------
4. A field that shows average home values for the United States in 2016 is most
likely:
� A geographical dimension
An aggregated measure
An aggregate measure in Tableau is a set of values that returns a single numeric
value. Hence, aggregated measure shows average home values.
-----------------------------------------------------------------------------------
-----------------------------------------
URL actions
� Edit tooltip options
Filter actions
� Hide and unhide all sheet options
The URL actions and filter actions are the interactive elements which add to the
dashboard for users.
-----------------------------------------------------------------------------------
-----------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------
True
False
The statement is true as Tableau can create worksheet specific filters.
-----------------------------------------------------------------------------------
-----------------------------------------
Colorado
� Missouri
� Wyoming
� Utah
The profitable state encompasses the Colorado state in the Technology product
category.
-----------------------------------------------------------------------------------
-------------------------------------
9. In which Region do all Product Categories fall beneath the overall average
profit?
� All Regions
� Central
� East
South
� West
-----------------------------------------------------------------------------------
-----------------------------------------
11. State true or false. A reference band cannot be based on a continuous axis.
False
True
A reference band is based on two reference points.
-----------------------------------------------------------------------------------
-----------------------------------------
True
False
A Reference Distribution plot can be on a continuous axis.
-----------------------------------------------------------------------------------
-----------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------
� Filled maps
� Layered maps
� Symbol maps
A web map service helps for geo-referenced map images and aids in map
visualization.
-----------------------------------------------------------------------------------
---------------------------------------
15. How to execute a URL action on a dashboard object within a dashboard to open a
Web Page, without opening the web browser?
Correct, with the use of a Web Page object it is possible to execute a URL action
on a dashboard object within a dashboard to open a web page in the system�s web
browser.
-----------------------------------------------------------------------------------
-----------------------------------------
True
� False
The disablement of the highlighting action is done for the entire workbook from the
toolbar.
-----------------------------------------------------------------------------------
-------------------------------------------
17. A sheet cannot directly be used within a story. Either sheet should be used
within a dashboard, or a dashboard should be used within a story.
True
False
A sheet can be used directly within a story.
-----------------------------------------------------------------------------------
-------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------
19. In Tableau, can you use measures in the same view multiple times (e.g., SUM of
the measure and AVG of the measure)?
No
Yes
Possible, measures can be used multiple times in the same view.
-----------------------------------------------------------------------------------
-----------------------------------------
False
True
Sets can be created on dimensions.
-----------------------------------------------------------------------------------
-----------------------------------------
Sets
Groups
Calculated fields
Table Calculations
Calculated fields are used for creating variable size bins.
-----------------------------------------------------------------------------------
-----------------------------------------
22. Which of the following best describes the usage of a bullet graph?
To Analyze the trend for a time period
To Compare the actual against the target sales
To add data to bins and calculating count measure
To Display the sales growth for a particular year
A bullet graph compares the actual sales with the targeted sales.
-----------------------------------------------------------------------------------
-----------------------------------------
23. Disaggregation breaks down all records in the underlying data source.
True
False
True, Disaggregation breaks down all the data records in the underlying data
sources.
-----------------------------------------------------------------------------------
-----------------------------------------
Bar
Line
Histogram
Scatter Plots
Tableau displays measures over a period of time as a Lines.
-----------------------------------------------------------------------------------
-----------------------------------------
25. The icon associated with the field that has been grouped is a ______________.
Paper Clip
Set
Hash
Equal To
A paperclip is an icon associated with the field that has been grouped.
-----------------------------------------------------------------------------------
-----------------------------------------
26. In the West region, which state�s sales fall within the Reference Band starting
from average sales of that region till median of sales? (Perform the below
questions in Tableau 9.0 and connect to the Saved Sample � Superstore dataset)
California
Colorado
Montana
New Mexico
The correct answer is Colorado
-----------------------------------------------------------------------------------
-----------------------------------------
27. Which chart types always includes bars sorted in descending order?
� Gantt Chart
Pareto Chart
� Combo Chart
� Bar in Bar
A Pareto chart can be represented in line graph format and bar graph format. The
values are represented in descending order in the bar graph. The line graph
represents the line graph.
-----------------------------------------------------------------------------------
-----------------------------------------
28. What is the minimum amount of RAM recommended for any production use of Tableau
Server?
8 GB
16 GB
32 GB
64 GB
32 GB is the recommended RAM for a Tableau server.
-----------------------------------------------------------------------------------
-----------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------
30. Mention the best method to visualize individual users affected by a particular
workbook permissions rule?
Search on the host project�s Permissions page, and then click the permissions
rule.
On the menu, click on the content, then workbooks and then list icon.
Click on workbook's permission page and click on permission rule.
On the menu, click on groups and then all users.
Individual users can be viewed by navigating to the workbook�s permission page and
clicking the permissions rules.
-----------------------------------------------------------------------------------
-----------------------------------------
31. A user with a Viewer license type and site role can create data-driven alerts.
True
False
A user with viewer license type cannot create Data-driven alerts. Hence, the above
statement is false.
-----------------------------------------------------------------------------------
-----------------------------------------
32. How to subscribe a user to a view by an administrator?
-----------------------------------------------------------------------------------
-----------------------------------------
33. Mention all of the relevant options for Active Directory group synchronization
performance?
-----------------------------------------------------------------------------------
-----------------------------------------
34. A Tableau Support case can be opened in one of the following valid ways. Which
one?
-----------------------------------------------------------------------------------
-----------------------------------------
35. One of the following charts uses binned data. Which one?
� Pie Chart
� Box Plot
Histogram
� Bullet Graphs
-----------------------------------------------------------------------------------
-----------------------------------------
� Continuous
Discrete
� Dimension
� Measure
If the field has a background color, blue, then the field is discrete.
-----------------------------------------------------------------------------------
-----------------------------------------
� False
Correct
A reference band can be based on two fixed points.
-----------------------------------------------------------------------------------
-----------------------------------------
38. A reference distribution plot cannot be along with the continuous axis
� True
� False
-----------------------------------------------------------------------------------
-----------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------
-----------------------------------------------------------------------------------
-----------------------------------------
41. Why is the benefit of using a bullet graph?
A bullet graph is helpful in comparing the actual sales against the targeted sale.
-----------------------------------------------------------------------------------
----------------------------------------
42. Disaggregation allows visualizing all the data rows the underlying data source.
� True
� False
The Disaggregation in Tableau allows to visualize all the data rows from a data
source.
-----------------------------------------------------------------------------------
-------------------------------------
� Bar graph
Line graph
� Histogram
� Scatter Plots
-----------------------------------------------------------------------------------
------------------------------------
Paper clip
� Set
� Hash
� Equal to
PDF Connector in Tableau is designed to pull out data from PDF files into which
type of objects. Select the correct option.
A. Tables
B. Views
C. Extract
D. Cubes
When Using Cubes, We can make extracts in Tableau.
A. True
B. False
Dashboard can be shown on the tooltip of any field on any dashboard as we can show
sheet on tooltip.
A. True
B. False @
A. Average
B. Default for Sheets is sum whereas for workbook it is average
C. Multiplication
D. Sum
Which type of chart is best suitable to identify the correlation between two
measures?
A. Box Plot
B. Scatter Plot
C. Motion Chart
D. Histogram
Select the correct syntax to find the difference of days between order date and
shipment date:
FIXED level of detail expressions compute a value using the specified dimensions,
without reference to the dimensions in the view.
true
false
files contain geographic information that can be very useful for visual analysis.
Which of the following types of geometries are supported by Tableau.
A. Longitude
B. Latitude
C. Number of Records
D. Calculated Field *
A. True *
B. False
The Technique that identifies which items are more related to each other than other
items based on the statistics is called.
A. Clustering
B. Grouping
C. Sets *
D. Forecasting