Font size
WorksheetsFinal Exam Question Pool (YouTube)
Total questions: 77
Worksheet time: 39mins
Which Tableau feature allows the visualization of data changes over time through animation?
Pages shelf
Filters shelf
Stories
Analytics pane
What is primarily used to connect Tableau to different data sources simultaneously?
Data blending
Data extraction
Live connection
Server connection
True or False: Tableau Desktop cannot export visualizations directly to PDF format.
true
false
What allows the dynamic control of multiple visualization elements simultaneously in Tableau?
Parameters
Filters
Calculated fields
Actions
Highlight actions
Which component is not typically used to improve dashboard performance in Tableau?
Data extracts
Live connections
Aggregated extracts
Filters
Calculated fields
What is the primary purpose of using Level of Detail (LOD) expressions in Tableau?
To increase data granularity
To enhance visualization speed
To bypass the normal aggregation level
To secure data
In Tableau, which shelf is used to control the starting point of a path in a visualization?
Pages shelf
Path shelf
Filters shelf
Tooltip shelf
True or False: Tableau allows users to publish and share dashboards via Tableau Public without any data limit.
true
false
What type of join combines all records from two datasets and fills in nulls where there is no match?
Inner join
Left join
Right join
Full outer join
How can Tableau interact with web data in real-time?
Through Web Data Connectors
Via live data feeds
Using data extracts
Through story points
True or False: Tableau Desktop can be used as a step-by-step ETL tool to combine, shape and clean data.
true
false
What feature should be used to ensure that a workbook's data reflects the most current data available in a database?
Server sync
Live connection
Scheduled extracts
Data source filters
Which types of data sources can Tableau connect to directly? (select multiple)
SQL databases
Web data connectors
Local files
Microsoft Access 97
Cloud data
What are the primary benefits of using data extracts in Tableau? (select multiple)
Faster loading times
Offline data access
Real-time updates
Enhanced security
Ability to use COUNTD
What functionality does Tableau Server provide for collaborating on visualizations? (select multiple)
Comments
Sharing links
Version history
Data-driven Alerts
Subscribing to views
True or False: Tableau Server or Tableau Cloud is required to publish and share dashboards with others.
True
False
Which feature in Tableau helps to reduce data noise based on measure values?
Filters
Sets
Highlighting
Clustering
Which data management features does Tableau offer to enhance analysis? (select multiple)
Data blending
Data pivoting
Data clustering
Data joining
Data cleansing
Which element is NOT directly editable within a Tableau dashboard?
Data source
Filter configurations
Container placement
Mark Colors
What Tableau feature allows you to switch between different views or dashboards dynamically as a user?
Stories
Dashboards
Workbook
Data sources
Which method is recommended for sharing a dashboard with offline users?
Publishing to Tableau Server
Sharing via Tableau Reader
Emailing as a PDF
Embedding in a web page
Which pane enables users to manage the layout and design of multiple dashboards in Tableau?
Dashboard
Layout
Data
Story
True or False: You can use Python scripts in Tableau calculations through the TabPy server.
true
false
What is the main advantage of using context filters in Tableau?
They aggregate data for faster processing
They filter data at the extract layer
They create dependent filters
They create independent filters
Which method is NOT a way to enhance dashboard performance in Tableau?
Using higher level of detail
Reducing the use of filters
Increasing the use of complex calculations
Simplifying visualizations
True or False: Tableau's data interpreter can clean and reshape messy data sourced from SQL databases.
true
false
The Pages shelf allows which of the following? (select multiple)
A way to page through SQL records
A way to jump to a specific page
A way to manually iterate through pages
A way to automatically iterate through pages
A way to size the dashboard dimensions based on devices
Which option is NOT a current, valid Tableau file type?
.twbx
.twb
.hyper
.tde
.tbm
True or False: You can embed external websites in Tableau dashboards.
true
false
What does the Group feature in Tableau Desktop allow?
Grouping members of dimensions together
Grouping users together
Grouping visualizations together
To cluster data automatically
What does publishing a workbook to Tableau Public allow? (select multiple)
Sharing via link
Embedding in websites
Offline Access
Setting Subscriptions
Refreshing Data Extracts
What is the main benefit of using a Gantt chart in Tableau?
Tracking time durations
Comparing categories
Visualizing part-to-whole relationships
Highlighting variations
True or False: Tableau Desktop supports scripting with JavaScript.
true
false
Which data connection type in Tableau provides the most up-to-date information?
Live connection
Data extract
Published data source
Cloud data
How can you look at underlying data in your workbook? (select multiple)
Use the Download Data option in the Data Pane
Use the View Data option in the Data Pane
Use the View Data option by right-clicking a mark
Use the Download Data option by right-clicking a mark
Use the View Data option in the Analysis Toolbar Menu
Which function do you use to convert a numeric field into a string field in Tableau?
STRING()
STR()
VARCHAR()
CAST()
What is the function of the Server menu in Tableau Desktop?
To configure data connections
To manage publishing settings
To administer server settings
To access server logs
True or False: In dashboards, only one sheet can be displayed at a time.
true
false
What can be used to take the difference between 2 measures?
A Calculated Field
The Analytics Pane
Parameter
A Global Variable
Which type of dashboard actions are generally available? (select multiple)
Refresh Extract
Highlight
Tooltip Hover
Filter
Change Parameter
Which of the following are valid dashboard objects? (select multiple)
Vertical
Download
Blank
Parameter
Menu Bar
Which of the following can best be used to compute percent of total?
Reference Line
LOD expression
Quick Table calculation
Ad-hoc calculation
What is the default aggregation applied to a measure when it is first dragged onto a Tableau view?
AVG
COUNT
SUM
CONTINUOUS
In which scenario is a packed bubble chart most effectively used?
Comparing parts of a whole
Displaying trends over time
Illustrating volume differences
Analyzing geographical data
Which feature in Tableau provides the ability to automate report distribution via emails?
Job alerts
Subscriptions
Email scheduling
Filter Actions
What role do hierarchies play in Tableau?
Organizing data into levels
Aggregating data for security
Filtering data across dashboards
Simplifying data entry
What is the benefit of embedding a Tableau dashboard into a web page?
Increases data security
Enhances user interaction
Simplifies data management
Expands data accessibility
True or False: Tableau's version control capabilities allow for the tracking and restoring of previous workbook versions.
True
False
In Tableau, what is the result of blending multiple data sources?
A new single data source is created
Related data from multiple sources is displayed together
Data is summarized into a single table
Data integrity is automatically checked
True or False: You can join tables in Tableau using custom SQL queries.
True
False
True or False: Tableau's LOD expressions cannot aggregate data beyond the visualization level.
True
False
Which Tableau capability is used to sequence a narrative of visualizations for presentation purposes?
Dashboards
Stories
Workbooks
Reports
How does the 'Union' feature in Tableau help in data preparation?
It merges rows from multiple tables
It merges columns from multiple tables
It blends data from multiple sources
It only displays rows that coincide between multiple tables
This icon best describes which component in the Data Pane?
Left Join
Sets
Location
Hierarchy
What role does 'Custom SQL' play in Tableau?
It allows users to write their own SQL queries for data sources
It automates data transformations
It provides templates for common queries
It enhances data security
What advantage does 'Subscription' provide in Tableau Server?
Automated report delivery
Real-time data update
Enhanced security features
Automated License Renewals
Which Tableau Desktop functionality allows you to recover back to your last saved changes?
Rollback
Version history
Revert
Restore
True or False: Running Total is a Quick Table Calculation.
True
False
Which type of join displays only records that have matching values in both tables?
Left Join
Right Join
Inner Join
Outer Join
Which file format is used to save Tableau Workbook files?
.tdsx
.twbx
.hyper
.tableau
Which feature in Tableau enables you to repoint references to a column?
Swap Field
Refactor
Replace References
Replace() function
What does the following icon do?
Union data
Pivot data
Rearrange containers
Swap column and row pills
_____ occur at the physical layer while _____ occur at the logical layer.
Joins, Relationships
Relationships, joins
Horizontals, Blanks
Measures, Dimensions
Which of the following can be used with a parameter to dynamically control the top N members based on a measure?
Groups
Bins
Hierarchy
Sets
Which of the following are valid data types in Tableau?
Number (whole)
Date
String
Spatial
Money
What does the following icon represent in Tableau?
Set
Group
Bin
Attachment
True or False: Tableau Animations can be turned off
True
False
Which of the following can be used to work with data offline?
Live Connection
Extract
Tableau Server
Tableau Cloud
True or False: Sheets can be used as filters for other sheets on a Dashboard
True
False
Which of the following actions can be used to direct a user to a web page?
Go to Web Page
Go to URL
Go to Hyperlink
Go to Website
The following image represents which feature in Tableau?
Dual Axis Bar Chart
Union
Horizontal Bar Chart
Column Alignment
How are relationships depicted in Tableau, and at which layer do they function?
Noodles, physical layer
Noodles, logical layer
Venn diagrams, logical layer
Venn diagrams, physical layer
What occurs in a bar chart when grouping by labels in the view?
The selected members will have the same color, while the rest will have different colors
Grouping by labels is not allowed
The view remains unchanged, but a group is created in the Dimensions shelf
A new bar is generated, consolidating all members within the group
Which of the following can be used to create a join in Tableau? (Select multiple)
Right-click a logical table, open the Join/Union canvas in the physical layer
Double-click a logical table to open the Join/Union canvas in the physical layer
Right-click a physical table, open the Join/Union canvas in the logical layer
Double-click a physical table to open the Join/Union canvas in the logical layer
What is a calculated field?
The number of marks in a visualization
A field created by applying custom formulas to existing data
A Quick Table Calculation
A field used to display metadata about the dataset
To connect Tableau to a CSV data source, which type of connection should you use?
Raw File
Microsoft Excel
Text
CSV
Which of the following best describes Incremental Refreshes?
they are the same as using an extract
they only add fresh rows as compared to the previous refresh
they should only be used with 1M+ rows
they reload all data in the extract
