Tableau Data Analyst Exam UPDATED
ACTUAL Questions and CORRRECT
Answers
Live Connection - CORRECT ANSWER - sends queries to the database/flat file and
updates the view depending on the results
Extracts - CORRECT ANSWER - 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 ANSWER - the data source can be either a live
connection or an extract
Flat files - CORRECT ANSWER - xlsx, csv, pdf, tdsx --.TIFF files are not accessible via
tableau desktop data collection window
Tableau Server - CORRECT ANSWER - customer-managed sharing platform where
creators, explorers and viewers can create, interact, and share content
SQL, Oracle, etc
Tableau Online - CORRECT ANSWER - fully hosted (by tableau) sharing platform where
creators, explorers and viewers can create, interact, and share content
Tableau Prep - CORRECT ANSWER - 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 ANSWER - is on the left side and it's the
space where you connect to your data sources
, Tableau Prep - Flow pane - CORRECT ANSWER - at the top and shows a visual
representation of each step in the data prep process
Tableau Prep - Profile pane - CORRECT ANSWER - displays a summary of each field in
the data sample
Tableau Prep - Data grid - CORRECT ANSWER - 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 ANSWER - number, date, sting, Boolean or geographic role
Alias - CORRECT ANSWER - can only be created for a dimension
full vs. incremental refresh - CORRECT ANSWER - 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 ANSWER - the canvas for creating relationships between tables
physical layer - CORRECT ANSWER - for creating unions and joins between tables (joins
tables together)
Aggregate - CORRECT ANSWER - rolls up the level of granularity on visible dimensions
(used to reduce data size) **impacts the way your calculations function
relationships - CORRECT ANSWER - create contextually appropriate joins (displayed as
flexible noodles between logical tables)
ACTUAL Questions and CORRRECT
Answers
Live Connection - CORRECT ANSWER - sends queries to the database/flat file and
updates the view depending on the results
Extracts - CORRECT ANSWER - 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 ANSWER - the data source can be either a live
connection or an extract
Flat files - CORRECT ANSWER - xlsx, csv, pdf, tdsx --.TIFF files are not accessible via
tableau desktop data collection window
Tableau Server - CORRECT ANSWER - customer-managed sharing platform where
creators, explorers and viewers can create, interact, and share content
SQL, Oracle, etc
Tableau Online - CORRECT ANSWER - fully hosted (by tableau) sharing platform where
creators, explorers and viewers can create, interact, and share content
Tableau Prep - CORRECT ANSWER - 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 ANSWER - is on the left side and it's the
space where you connect to your data sources
, Tableau Prep - Flow pane - CORRECT ANSWER - at the top and shows a visual
representation of each step in the data prep process
Tableau Prep - Profile pane - CORRECT ANSWER - displays a summary of each field in
the data sample
Tableau Prep - Data grid - CORRECT ANSWER - 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 ANSWER - number, date, sting, Boolean or geographic role
Alias - CORRECT ANSWER - can only be created for a dimension
full vs. incremental refresh - CORRECT ANSWER - 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 ANSWER - the canvas for creating relationships between tables
physical layer - CORRECT ANSWER - for creating unions and joins between tables (joins
tables together)
Aggregate - CORRECT ANSWER - rolls up the level of granularity on visible dimensions
(used to reduce data size) **impacts the way your calculations function
relationships - CORRECT ANSWER - create contextually appropriate joins (displayed as
flexible noodles between logical tables)
