TABLEAU QUESTIONS WITH
CORRECT ANSWERS
How can the users refresh an extract immediately in Tableau desktop? (Multiple
Possible Answers) - Correct Answers -a) Select a Data Source on Data Menu -> Extract
b) Select a Data Source on Data Menu -> Refresh
c) Sign in to Tableau Server -> On the Actions menu click Run now
What Is The Difference Between Live And Extract Connections. - Correct Answers -a)
Live allows real-time data while extracts are kind of batch which needs to be refreshed
from time
to time to get the updated data.
b) Live Connection takes more time to load data than Extract Connection
Why the direct connection to the extract is not recommended - (Multiple Possible
Answers) - Correct Answers -a) The table names will be different
b) The extract cannot be refreshed
c) The data model and relationships will be lost
What is the default format (extension) that Tableau saves the files as? - Correct
Answers -b) .tdsx
c) .tds
How many data sources can we blend in Tableau? - Correct Answers -Two
In a Relationship we need to define the following Join type - Correct Answers -d) It is
not required to define a join type in a relationship
Which option leads to adjusting the granularity of data in Tableau? - Correct Answers -
a) Aggregate
Advantages to using relationships to combine tables: (Multiple Possible Answers) -
Correct Answers -b) Make it easier to analyze data across multiple tables at different
levels of granularity
d) Tables are only queried when fields from the tables are added to the viz
Select the correct pathway to edit the data source - - Correct Answers -a) Data Menu -?
Select a Data source -> Edit Data Source
,Aliases can only be created for - Correct Answers -Discrete dimension
While assigning geographic role to a field, Tableau adds two fields to the Measures
area of the Data pane: - Correct Answers -a) Latitude and Longitude.
Choose the correct path to change the data type for a field in the view - - Correct
Answers -b) Right click of the field in the Data pane -> Change Data Type -> Choose
the appropriate data type
Choose the correct path to add a default comment for a field - Correct Answers -a)
Right click a field in the Data pane-> Default Properties-> Comment
Create a horizontal bar chart - Correct Answers -a) Drag the measure to the columns
shelf and the dimension to the row shelf
What types of trend lines are available in Tableau? - Correct Answers -Linear,
Logarithmic, Exponential, Polynomial
]
What steps should be taken to create a geographical hierarchy? - Correct Answers -c)
Data pane right-click the geographic field -> Hierarchy -> Create Hierarchy
What is the difference between a dual axis chart and a combined axis chart? - Correct
Answers -b) Dual axis chart creates two independent axes while a combined axis chart
merges two or more measures into a single axis
What steps will create a dual axis chart? - Correct Answers -a) Drag 1 dimension to
Column and 2 measures to Row -> In the Rows right click any of the measure -> Select
Dual axes -> Go to marks type of any of the measure and choose the chart type as Bar
c) Drag one dimension to Column and drag one measures to Row -> drag another
measure to the chart itself and as the rectangle shape appears drop it -> Go to marks
type of any of the measure and
choose the chart type as Bar
How to create a stacked bar chart while using a separate bar for each measure? -
[Select All that
Apply] - Correct Answers -a) Drag a dimension to Color -> Drag Measure Names to
Columns and drag Measure Values to Rows -> On the Columns shelf right-click
Measure Names -> select Filter -> select the check boxes for the measures to display ->
Ok
Which of the following applies for Density map in Tableau - [Select All that Apply -
Correct Answers -a) To create a density map, the data source should contain Latitude
and Longitude coordinates or location names
c) Density maps are most effective when the location data is very previse, such as
location coordinates in a limited space
, d) Density marks work best where the specific locations change continuously and
smoothly across space, rather than values constrained to discrete locations like
borough or neighborhood
How to create Highlight Table or Heat Map in Tableau - - Correct Answers -a) Drag one
or ore dimensions on the Columns shelf and one or more dimensions on the Rows shelf
-> place a measure of interest on the Color shelf -> Select Square as the mark type
How to create a group from a field in the Data pane? - Correct Answers -a) In the Data
pane right-click a field -> select Create -> In the Create Group dialog box select the
members that needs to be grouped -> Group -> Ok
b) In the Data pane right-click a field -> select Group
Which of the following are the types of sets in Tableau? - [Select All that Apply] -
Correct Answers -b) Dynamic set
c) Fixed set
How to create a Hierarchy in Tableau? - - Correct Answers -a) In Data pane drag a field
and drop on top of another field -> enter a name of the hierarchy -> ok
Filter dialog box offers the following tabs for filtering - [Select all that Apply] - Correct
Answers -b) Wildcard
c) Condition
d) Top
How to create Relative Date Filters- - Correct Answers -c) Drag a date field to the filter
shelf -> Select a time unit -> Define the date period -> Ok
Which of the following are applicable for nested sort in Tableau? - [Select all that Apply]
- Correct Answers -a) Nested sort considers each pane independently and sorts the
rows per pane
b) Nested sorts look correct within the context of the pane, but don't convey the
aggregated information about how the values compare overall
d) While creating a nested sort, the sort is inherited when we drill down through the
dimensions
Which of the following quick table calculations are available in Tableau? - [Select all that
Apply] - Correct Answers -Running total, Difference, Percent difference, Percent of total,
Rank, Percentile, Moving average,
YTD total, Compound growth rate, Year of year growth, YTD growth.
How do you create a Binned Dimension in Tableau? - - Correct Answers -a) In the Data
pane right-click a measure -> select Create > Bins -> Create Bin dialog accept the
proposed New field name or specify a different name for the new field -> Mention the
size of bins -> Ok
CORRECT ANSWERS
How can the users refresh an extract immediately in Tableau desktop? (Multiple
Possible Answers) - Correct Answers -a) Select a Data Source on Data Menu -> Extract
b) Select a Data Source on Data Menu -> Refresh
c) Sign in to Tableau Server -> On the Actions menu click Run now
What Is The Difference Between Live And Extract Connections. - Correct Answers -a)
Live allows real-time data while extracts are kind of batch which needs to be refreshed
from time
to time to get the updated data.
b) Live Connection takes more time to load data than Extract Connection
Why the direct connection to the extract is not recommended - (Multiple Possible
Answers) - Correct Answers -a) The table names will be different
b) The extract cannot be refreshed
c) The data model and relationships will be lost
What is the default format (extension) that Tableau saves the files as? - Correct
Answers -b) .tdsx
c) .tds
How many data sources can we blend in Tableau? - Correct Answers -Two
In a Relationship we need to define the following Join type - Correct Answers -d) It is
not required to define a join type in a relationship
Which option leads to adjusting the granularity of data in Tableau? - Correct Answers -
a) Aggregate
Advantages to using relationships to combine tables: (Multiple Possible Answers) -
Correct Answers -b) Make it easier to analyze data across multiple tables at different
levels of granularity
d) Tables are only queried when fields from the tables are added to the viz
Select the correct pathway to edit the data source - - Correct Answers -a) Data Menu -?
Select a Data source -> Edit Data Source
,Aliases can only be created for - Correct Answers -Discrete dimension
While assigning geographic role to a field, Tableau adds two fields to the Measures
area of the Data pane: - Correct Answers -a) Latitude and Longitude.
Choose the correct path to change the data type for a field in the view - - Correct
Answers -b) Right click of the field in the Data pane -> Change Data Type -> Choose
the appropriate data type
Choose the correct path to add a default comment for a field - Correct Answers -a)
Right click a field in the Data pane-> Default Properties-> Comment
Create a horizontal bar chart - Correct Answers -a) Drag the measure to the columns
shelf and the dimension to the row shelf
What types of trend lines are available in Tableau? - Correct Answers -Linear,
Logarithmic, Exponential, Polynomial
]
What steps should be taken to create a geographical hierarchy? - Correct Answers -c)
Data pane right-click the geographic field -> Hierarchy -> Create Hierarchy
What is the difference between a dual axis chart and a combined axis chart? - Correct
Answers -b) Dual axis chart creates two independent axes while a combined axis chart
merges two or more measures into a single axis
What steps will create a dual axis chart? - Correct Answers -a) Drag 1 dimension to
Column and 2 measures to Row -> In the Rows right click any of the measure -> Select
Dual axes -> Go to marks type of any of the measure and choose the chart type as Bar
c) Drag one dimension to Column and drag one measures to Row -> drag another
measure to the chart itself and as the rectangle shape appears drop it -> Go to marks
type of any of the measure and
choose the chart type as Bar
How to create a stacked bar chart while using a separate bar for each measure? -
[Select All that
Apply] - Correct Answers -a) Drag a dimension to Color -> Drag Measure Names to
Columns and drag Measure Values to Rows -> On the Columns shelf right-click
Measure Names -> select Filter -> select the check boxes for the measures to display ->
Ok
Which of the following applies for Density map in Tableau - [Select All that Apply -
Correct Answers -a) To create a density map, the data source should contain Latitude
and Longitude coordinates or location names
c) Density maps are most effective when the location data is very previse, such as
location coordinates in a limited space
, d) Density marks work best where the specific locations change continuously and
smoothly across space, rather than values constrained to discrete locations like
borough or neighborhood
How to create Highlight Table or Heat Map in Tableau - - Correct Answers -a) Drag one
or ore dimensions on the Columns shelf and one or more dimensions on the Rows shelf
-> place a measure of interest on the Color shelf -> Select Square as the mark type
How to create a group from a field in the Data pane? - Correct Answers -a) In the Data
pane right-click a field -> select Create -> In the Create Group dialog box select the
members that needs to be grouped -> Group -> Ok
b) In the Data pane right-click a field -> select Group
Which of the following are the types of sets in Tableau? - [Select All that Apply] -
Correct Answers -b) Dynamic set
c) Fixed set
How to create a Hierarchy in Tableau? - - Correct Answers -a) In Data pane drag a field
and drop on top of another field -> enter a name of the hierarchy -> ok
Filter dialog box offers the following tabs for filtering - [Select all that Apply] - Correct
Answers -b) Wildcard
c) Condition
d) Top
How to create Relative Date Filters- - Correct Answers -c) Drag a date field to the filter
shelf -> Select a time unit -> Define the date period -> Ok
Which of the following are applicable for nested sort in Tableau? - [Select all that Apply]
- Correct Answers -a) Nested sort considers each pane independently and sorts the
rows per pane
b) Nested sorts look correct within the context of the pane, but don't convey the
aggregated information about how the values compare overall
d) While creating a nested sort, the sort is inherited when we drill down through the
dimensions
Which of the following quick table calculations are available in Tableau? - [Select all that
Apply] - Correct Answers -Running total, Difference, Percent difference, Percent of total,
Rank, Percentile, Moving average,
YTD total, Compound growth rate, Year of year growth, YTD growth.
How do you create a Binned Dimension in Tableau? - - Correct Answers -a) In the Data
pane right-click a measure -> select Create > Bins -> Create Bin dialog accept the
proposed New field name or specify a different name for the new field -> Mention the
size of bins -> Ok
