Specialist Practice Questions on Exploring and Analyzing Data

Use the Specialist study guide to quickly look up information related to these questions. More Specialist practice questions available here.

Enter Email to Submit Quiz & Subscribe

1. What steps should be taken to change a vertical bar chart to horizontal?

a) Drag the measure to the columns shelf and the dimension to the row shelf

b) Drag the measure to the rows shelf and the dimension to the column shelf

c) Drag the measure to both the row shelf and the columns shelf

d) Drag the dimension to both the rows shelf and the column shelf

2. What types of trend lines are available in Tableau? [Select All that Apply]

a) logistic

b) Linear

c) Logarithmic

d) Multinomial

e) Polynomial

3. What steps should be taken to create a geographical hierarchy?

a) In the Analytics pane right-click the geographic field -> Create Hierarchy

b) In the Analytics pane right-click the create Hierarchy -> Select Hierarchy -> Ok

c) In the Data pane right-click the geographic field-> Hierarchy -> Create Hierarchy

d) In the Data pane right-click the geographic field-> Transform -> select Hierarchy -> Create Hierarchy

4. What is the difference between a dual axis chart and a combined axis chart?

a) Dual axis and combined axis are different terms but have the same meaning.

b) Dual axis chart creates two independent axes while a combined axis chart merges two or more measures into a single axis.

c) Combined axis chart creates two independent axes while a dual axis chart merges two or more measures into a single axis.

d) Dual axis chart becomes a combined axis chart once two or more measures are combined into a single axis.

5. What steps will create a dual axis chart? [Select All that Apply]

a) Drag one dimension to Column and drag two measures to Row -> In the Rows right click any of the measure -> Select Dual axes -> Go to marks type on the second measure and choose the chart type as Bar

b) Drag two dimensions to Column and drag one measures to Row -> 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

d) Drag one dimension to Column and drag one measure to Row -> Go to marks type of any of the measure and choose the chart type as Bar

6. How to create a stacked bar chart while using a separate bar for each measure? – [Select All that Apply]

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

b) Drag a dimension to Color -> Drag Measure Names to Rows and also 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

c) Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> Ok

d) Drag a Measure Values to Color -> Drag Measure Names to Columns and drag Dimension to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok

7. Which of the following applies for Density map in Tableau – [Select All that Apply]

a) To create a density map, the data source should contain Latitude and Longitude coordinates or location names

b) Tableau cannot recognize location names and create a density map using the point locations assigned to Tableau geocoding locations

c) Density maps are most effective when the location data is very precise, 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 neighbourhood.

8. How to create Highlight Table in Tableau –

a) Drag one or more 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

b) Drag one or more dimensions on the Columns shelf -> Select Square as the mark type -> place a measure of interest on the Colour shelf.

c) Drag one or more dimensions on the Rows shelf-> Select Square as the mark type -> place a measure of interest on the Colour shelf.

d) Drag one dimension on the Columns shelf and one measure on the Rows shelf -> place a measure of interest on the Colour shelf.

9. How to create a group from a field in the Data pane? –

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.

c) In the Data pane right-click a field -> Group

d) In the Analytics pane right-click a field -> select Group -> Ok

10. Which of the following are the types of sets in Tableau? – [Select All that Apply]

a) Singleton set

b) Dynamic set

c) Fixed set

d) Equal set

11. How to create a Hierarchy in Tableau? –

a) In Data pane drag a field and drop on top of another field -> enter a name of the hierarchy -> ok

b) Right click on a field -> Create Hierarchy -> Choose the fields -> ok

c) Right click on a field -> Create Hierarchy -> ok

d) Right click on a field -> Choose the fields -> Create Hierarchy -> ok

12. Filter dialog box offers the following tabs for filtering – [Select all that Apply]

a) Report

b) Wildcard

c) Condition

d) Top

13. How to create Relative Date Filters–

a) Drag a date field to the filter shelf -> Select Relative Date -> Ok

b) Drag a date field to the filter shelf -> Select Relative Date -> Select a time unit -> Ok

c) Drag a date field to the filter shelf -> Select Relative Date -> Select a time unit -> Define the date period -> Ok

d) Drag a date field to the filter shelf -> Select Relative Date -> Define the date period -> Ok

14. Which of the following are applicable for nested sort in Tableau? – [Select all that Apply]

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

c) Sorting from an axis does not give a nested sort by default

d) While creating a nested sort, the sort is inherited when we drill down through the dimensions

15. Which of the following quick table calculations are available in Tableau? – [Select all that Apply]

a) Z-score

b) Percent of total

c) Rank

d) Percentile

16. How do you create a Binned Dimension in Tableau?

a) In the Data pane right-click a measure -> select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok.

b) In the Data pane right-click a measure -> Create Bins dialog box accept the proposed new field name or specify a different name for the new field -> Mention the size of bins -> Ok

c) In the Data pane right-click a measure -> select Create bins > Ok

d) Select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok

17. The main types of calculations you can use to create calculated fields in Tableau: – [Select all that Apply]

a) Basic calculations

b) Level of Detail (LOD) expressions

c) Statistic Calculations

d) Table calculations

18. Which of the following can prevent a refresh for a refreshable list of parameter values? [select all that apply]

a) The default field returns null.

b) The default field does not return a single value

c) The default field is in a data source that’s not yet connected.

d) The user cancels the query to the data source while Tableau is attempting to connect.

19. How can subtotals be added to a visualization?

a) Click the Analytics pane -> In the Analytics pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals

b) Click the Analytics pane -> Click the Subtotals

c) Click the Data pane -> In the Data pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals

d) Click the Data pane -> Click the Subtotals

16 thoughts on “Specialist Practice Questions on Exploring and Analyzing Data”

shihui hu
January 14, 2022 at 11:32 pm

too many concept quesitons.

Reply
1. LearningTableau
  January 20, 2022 at 9:09 pm
  
  The new Specialist exam has all knowledge-based questions a mix of concept questions and “how do you do x” type questions. There are no hands-on questions in the current Specialist exam.
  
  Reply
wilko
February 18, 2022 at 2:12 pm

Did you included any real exam questions too?

Reply
1. LearningTableau
  February 18, 2022 at 2:17 pm
  
  No, it’s against the exam policy to take questions from the official exam. The questions are in the same format and cover the same topics, but they are not copies of the official exam questions.
  
  Reply
Tao Tao
April 15, 2022 at 1:56 am

If the those question more difficult than real exam?

Reply
1. Narcis
  May 4, 2022 at 7:53 am
  
  Hi Tao,
  
  We can’t tell for sure if these questions are more difficult or easier than those from the real exam – the pool of questions from the real exam is very large and is often updated. You can be sure that the quizzes are built to follow the same topics and measure the same knowledge as the real exam is, so most likely they will be very similar in difficulty level.
  
  Thanks,
  Narcis
  
  Reply
Mash
October 5, 2022 at 8:52 pm

Hi Tao,

I’m afraid the response for Q18 is not in line with tableau documentation.

18. Which of the following can prevent a refresh for a refreshable list of parameter values? [select all that apply]
“b) The default field does not return a single value “, is a scenario that prevents parameter refresh as per tableau, https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm#when-the-parameter-value-or-list-of-values-can%E2%80%99t-refresh.

The solution suggested by you doesn’t identify this as a scenario that prevents refresh. Kindly check.

Thanks a bunch for the awesome material !

Reply
1. Narcis
  June 19, 2023 at 11:28 am
  
  Hi Mash,
  
  As it is mentioned in the solution guide, a single value is required when setting the parameters defaultvalue, but not when dynamically setting a list of possible values for the parameter.
  
  Hope this makes it clearer.
  Narcis
  
  Reply
Zhao
October 11, 2022 at 3:20 am

Hi, do we have to select all that is correct to get full marks? or do we just need to select 1 to get marks? Thank you!

Reply
1. Narcis
  April 30, 2023 at 8:40 am
  
  Hi Zhao,
  
  Like in the real certification exam, for the questions with multiple answers to get all the points for a question you have to get all the correct answer.
  
  Hope this makes it clear.
  Narcis
  
  Reply
Naman Bisht
April 21, 2023 at 11:58 am

According to my observation the answers you provide are not correct in some of the cases.

Reply
1. Narcis
  April 30, 2023 at 8:31 am
  
  Hi Naman,
  
  There might be some inaccuracies or misspellings in some questions and we are sorry for if that happens. User feedback is very important and that’s why we need some examples to be able to correct them or maybe clarify them for you.
  
  Narcis
  
  Reply
Ali
March 6, 2024 at 11:19 am

Question Question 9 [2.2.1 Create groups by using marks, headers, and the data pane]
How to create a group from a field in the Data pane?
All the answers in the list are wrong including the proposed correct answers a +b (there is missing step Create—>group)

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.
c) In the Data pane right-click a field -> Group
d) In the Analytics pane right-click a field -> select Group -> Ok.
Correct answer: a, b.

Reply
1. Narcis
  May 28, 2024 at 3:03 pm
  
  Hi Ali,
  
  You’re correct about option b, that is not correct and it’s now fixed. For option a however, that answer is correct, it is mentioned “in the Create Group dialog box select the members that need to be grouped”.
  
  Thank you,
  Narcis
  
  Reply
Mark
September 6, 2024 at 3:10 am

If these questions are what the exam is like then it is WAY ,more difficult than the mother practice exams and questions I’ve seen on Udemy and other places… I thought I was prepared until I saw these!

Reply
1. Narcis
  September 21, 2024 at 11:17 am
  
  Hi Mark,
  
  Maybe this means that you’ve just found your areas where you could use more work. Keep practicing and you’ll surely pass!
  
  Narcis
  
  Reply

16 thoughts on “Specialist Practice Questions on Exploring and Analyzing Data”

Leave a Reply Cancel reply