




































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 44
This page cannot be seen from the preview
Don't miss anything!
what is the order of operations for filters? - ANSWER 1. Extract Filter
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)
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
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
What steps will create a dual axis chart? (two methods) - ANSWER
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.
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
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
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