Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Tableau Desktop Specialist Practice Exam Questions and Answers, Exams of Nursing

A comprehensive set of practice exam questions and answers for tableau desktop specialist certification. It covers various aspects of tableau desktop, including data connections, filters, relationships, data types, chart creation, and more. The questions are designed to test your understanding of key concepts and functionalities within tableau desktop.

Typology: Exams

2024/2025

Available from 01/02/2025

kelvin-smith-3
kelvin-smith-3 🇺🇸

1

(1)

2K documents

1 / 44

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
TABLEAU DESKTOP SPECIALIST PRACTICE
EXAM Questions with 100% correct Answers
Latest Versions 2025 TOP RATED A+
what is the order of operations for filters? -
ANSWER 1. Extract Filter
2. Data Source Filter
3. Context Filter
4. Normal (dimension/measure) Filters
blend vs relationship - ANSWER blend: never
truly combines it, only supports left joins, can't
be published, combines two different data
sources
relationship: aggregates and then combines,
supports full outer join, can be published since it
can create a table in the background
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c

Partial preview of the text

Download Tableau Desktop Specialist Practice Exam Questions and Answers and more Exams Nursing in PDF only on Docsity!

TABLEAU DESKTOP SPECIALIST PRACTICE

EXAM Questions with 100% correct Answers

Latest Versions 2025 TOP RATED A+

what is the order of operations for filters? - ANSWER 1. Extract Filter

  1. Data Source Filter
  2. Context Filter
  3. Normal (dimension/measure) Filters blend vs relationship - ANSWER blend: never truly combines it, only supports left joins, can't be published, combines two different data sources relationship: aggregates and then combines, supports full outer join, can be published since it can create a table in the background

context filter - ANSWER a set filter that will be carried out before any filters added on the worksheet (ex: you only want to see breakfast category, and then you want to filter top 10)

  • comes after extract ad data source filters What is the difference between Live and Extract connections? - ANSWER - Live allows real-time data while extracts are kind of batch which needs to be refreshed from time to get the updated data
  • Live Connection takes more time to load data than Extract Connection Why the direct connection to the extract is not recommended? - ANSWER - The table names will be different
  • The extract cannot be refreshed
  • The data model and relationships will be lost *it can be removed once it's connected directly

Tableau? a)two b)three c)four d)five - ANSWER a) two In a Relationship we need to define the following Join type- a)Inner Join b)Left Join c)Right Join d)it is not required to define a join type in a relationship - ANSWER d) it is not required to define a join type in a relationship Which option leads to adjusting the granularity of data in Tableau? a)aggregate b)group by c)grouped fields

d)extract - ANSWER a) aggregate Advantages to using relationships to combine tables: (multiple possible answers) a)makes it easier to change the key fields used to combine tables b)makes it easier to analyze data across multiple tables at different levels of granularity c)makes it easier to combine rows from one table with rows from another d)tables are only queried when fields from the tables are added to the viz - ANSWER b) makes it easier tho 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 (aka when required in the worksheet) Relationships vs Joins - ANSWER Relationships

  • do not combine rows from one table with rows from another
  • duplication is avoided

following? a)continuous dimension b)discrete dimension c)measures d)dates - ANSWER b) discrete dimension When assigning geographic role to a field, tableau adds two fields to the Measurers area of the Data pane: - ANSWER Latitude and Longitude Choose the correct path to change the data type for a field in the view - Right click the field in the Data pane and then: a)Change Data Type - > Data Types - > choose appropriate type b)Change Data Type - > choose appropriate type c)Data Types - > Choose appropriate type d)choose appropriate type - ANSWER b) Right click the field in the Data pane - > Change Data Type - > Choose appropriate type

Choose the correct path to add a default comment for a field - Right click a field in the Data Pane and then: a)Default Properties - > Comment b)Aggregation - > Default Properties - > Comment c)Comment d)Describe - > Comment - ANSWER a) Right click a field in the Data Pane - > Default Properties - > Comment What steps should be taken to change a vertical Baar 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 - ANSWER a) Drag the measure to the columns shelf and the dimension to the

d)Data pane right-click the geographic field - > Transform - > select Hierarchy - > create hierarchy

  • ANSWER 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? a)dual axis and combined axis mean the same 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 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 - ANSWER b) dual axis chart creates two independent axes while a combines axis chart merges two or more measures into a single axis

What steps will create a dual axis chart? (two methods) - ANSWER

  1. one dimension to Column and drag two measures to Row - > in the Rows right click any of the measures - > Select Dual axes - > Go to marks type of any of the measure and choose the chart type as Bar
  2. Drag one dimension to Column and drag one measure to Row - > drag another measure to the chart itself and as the rectangle shape appears drop it - > 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? a)Drag a dimension to Color - > drag measure names to Columns and drag Measure values to Rows - > on Columns shelf right-click Measure Names - > select Filter - > select the check boxes

Which of the following applies for Density map in Tableau? a)To create a density map, the data source should contain Latitude and Longitude coordinates or location names b)Tableau can't recognize location names and create a density map using the points locations assigned to 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 smoothy across space, rather than values constrained to discrete locations like borough or neighborhood.

  • ANSWER a) c) d)

How to create Highlight table or Heat Map in Tableau? - ANSWER Drag one or more measures to Columns and Rows shelf Place a measure on the Color shelf and select Square as the mark type How to create a group from a field in the Data plane? - ANSWER 1. right click a field - > select Create - > in the Create Group box select members that needs to be grouped - > Group - > Ok

  1. right click a field - > select Group Which of the following are the types of sets in Tableau? a)Singleton set b)Dynamic set c)Fixed set d)Equal set - ANSWER b) Dynamic set

c)condition d)top How to create a Relative Data Filter a)drag a date field to the filter shelf - > Ok b)drag a date field to the filter shelf - > Select a time unit - > Ok c)drag a date field to the filter shelf - > Select a time unit - > Define the date period - > Ok d)drag a date field to the filter shelf - > Define the date period - > Ok - ANSWER 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 three) 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 dimensions

  • ANSWER 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? a)z-score

create calculated fields in Tableau a)basic calculations b)Level of Detail (LOD) expressions c)statistic calculations d)table calculations - ANSWER a) basic calculations b)LOD expressions d) table calculations *NOT statistic Which of the following can prevent a refresh for a refreshable list of parameter values? (select all that apply) a)default field returns null b)default field does not return a single value c)default field is in a data source that's not yet connected

d)user cancels the query to the data source while Tableau is attempting to connect - ANSWER a) default field returns null c)default field is in a non-connected source d)user cancels the query How to show subtotals in 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 - ANSWER a) click analytics pane - > under Summarize drag Totals into Add Totals dialog

  • drop it over Subtotals