TABLEAU DATA ANALYST EXAM
QUESTIONS AND ANSWERS
Live Connection - Correct Answers -sends queries to the database/flat file and updates
the view depending on the results
Extracts - Correct Answers -are saved subsets of data that improve performance and
take advantage of Tableau functionality, allowing you to refresh the data on a regular
basis.
Published Data Source - Correct Answers -the data source can be either a live
connection or an extract
Flat files - Correct Answers -xlsx, csv, pdf, tdsx --.TIFF files are not accessible via
tableau desktop data collection window
Scatter plots
Multi-axis charts - Correct Answers -Require 2 measures and 0 dimensions
Crosstabs
Highlight tables
Heatmap - Correct Answers -Require 1 measure and 1 or more dimensions
Tree maps - Correct Answers -Require 1 or 2 measures and 1 or more dimensions
Tableau Server - Correct Answers -customer-managed sharing platform where creators,
explorers and viewers can create, interact, and share content
SQL, Oracle, etc
Tableau Online - Correct Answers -fully hosted (by tableau) sharing platform where
creators, explorers and viewers can create, interact, and share content
Tableau Prep - Correct Answers -desktop based visual ETL program. It enables
developers to connect to data, create workflows, automate jobs and share flows with
others.
Tableau Prep - Connections Pane - Correct Answers -is on the left side and it's the
space where you connect to your data sources
Tableau Prep - Flow pane - Correct Answers -at the top and shows a visual
representation of each step in the data prep process
, Tableau Prep - Profile pane - Correct Answers -displays a summary of each field in the
data sample
Tableau Prep - Data grid - Correct Answers -displays a preview of the rows and
columns of the data source
Any changes that are made in to profile pane will automatically show in the data grid
Field type - Correct Answers -number, date, sting, Boolean or geographic role
Alias - Correct Answers -can only be created for a dimension
full vs. incremental refresh - Correct Answers -full refresh replaces all of the contents in
the extract
An incremental refresh only adds rows that are new since the previous refresh.
logical layer - Correct Answers -the canvas for creating relationships between tables
physical layer - Correct Answers -for creating unions and joins between tables (joins
tables together)
Aggregate - Correct Answers -rolls up the level of granularity on visible dimensions
(used to reduce data size) **impacts the way your calculations function
relationships - Correct Answers -create contextually appropriate joins (displayed as
flexible noodles between logical tables)
Joins - Correct Answers -merges multiple tables based on a clause - this creates a new
fixed table
Unions - Correct Answers -appends two or more tables to form a new combined table
(good for data with the same number of rows and data types)
Blending - Correct Answers -visualizes data from separate sources within the same
view via blended fields (the result is similar to a left join)
Specific and Wildcard - Correct Answers -types of unions that are available in the
physical layer
Dimensions - Correct Answers -qualitative (used to categorize, segment, and filter) eg
names and dates (normally discrete)
Measures - Correct Answers -quantitative (can be counted or aggregated) eg $, ratios,
or quantities (normally continuous)
Discrete - Correct Answers -(blue) - finite set of values -> year, category, country ADD A
NEW HEADER (normally dimensions)
QUESTIONS AND ANSWERS
Live Connection - Correct Answers -sends queries to the database/flat file and updates
the view depending on the results
Extracts - Correct Answers -are saved subsets of data that improve performance and
take advantage of Tableau functionality, allowing you to refresh the data on a regular
basis.
Published Data Source - Correct Answers -the data source can be either a live
connection or an extract
Flat files - Correct Answers -xlsx, csv, pdf, tdsx --.TIFF files are not accessible via
tableau desktop data collection window
Scatter plots
Multi-axis charts - Correct Answers -Require 2 measures and 0 dimensions
Crosstabs
Highlight tables
Heatmap - Correct Answers -Require 1 measure and 1 or more dimensions
Tree maps - Correct Answers -Require 1 or 2 measures and 1 or more dimensions
Tableau Server - Correct Answers -customer-managed sharing platform where creators,
explorers and viewers can create, interact, and share content
SQL, Oracle, etc
Tableau Online - Correct Answers -fully hosted (by tableau) sharing platform where
creators, explorers and viewers can create, interact, and share content
Tableau Prep - Correct Answers -desktop based visual ETL program. It enables
developers to connect to data, create workflows, automate jobs and share flows with
others.
Tableau Prep - Connections Pane - Correct Answers -is on the left side and it's the
space where you connect to your data sources
Tableau Prep - Flow pane - Correct Answers -at the top and shows a visual
representation of each step in the data prep process
, Tableau Prep - Profile pane - Correct Answers -displays a summary of each field in the
data sample
Tableau Prep - Data grid - Correct Answers -displays a preview of the rows and
columns of the data source
Any changes that are made in to profile pane will automatically show in the data grid
Field type - Correct Answers -number, date, sting, Boolean or geographic role
Alias - Correct Answers -can only be created for a dimension
full vs. incremental refresh - Correct Answers -full refresh replaces all of the contents in
the extract
An incremental refresh only adds rows that are new since the previous refresh.
logical layer - Correct Answers -the canvas for creating relationships between tables
physical layer - Correct Answers -for creating unions and joins between tables (joins
tables together)
Aggregate - Correct Answers -rolls up the level of granularity on visible dimensions
(used to reduce data size) **impacts the way your calculations function
relationships - Correct Answers -create contextually appropriate joins (displayed as
flexible noodles between logical tables)
Joins - Correct Answers -merges multiple tables based on a clause - this creates a new
fixed table
Unions - Correct Answers -appends two or more tables to form a new combined table
(good for data with the same number of rows and data types)
Blending - Correct Answers -visualizes data from separate sources within the same
view via blended fields (the result is similar to a left join)
Specific and Wildcard - Correct Answers -types of unions that are available in the
physical layer
Dimensions - Correct Answers -qualitative (used to categorize, segment, and filter) eg
names and dates (normally discrete)
Measures - Correct Answers -quantitative (can be counted or aggregated) eg $, ratios,
or quantities (normally continuous)
Discrete - Correct Answers -(blue) - finite set of values -> year, category, country ADD A
NEW HEADER (normally dimensions)
