TABLEAU FUNDAMENTALS EXAM
QUESTIONS AND ANSWERS
The three aspects of the Tableau Desktop workflow (in order) are:
a) Connect, analyze, and share b) Analyze, share, and connect c) Share, analyze, and
connect d) Connect, share, and analyze - Correct Answers -Connect, analyze, and
share
Renaming a dimension or measure in Tableau Desktop:
a) Renames it in the underlying data source. b) Does not rename it in the underlying
data source. - Correct Answers -Does not rename it in the underlying data source.
By default, Tableau Desktop:
a) Creates a snapshot of your data as an extract b) Maintains a live connection to your
data source - Correct Answers -Maintains a live connection to your data source
Which of the following can you edit from the Manage Metadata screen?
a) Data Type, Field Name, Table, and Remote Field Name b) Data type, Field Name c)
Table, and Remote Field Name d) Data type, Table, and Remote Field Name - Correct
Answers -Data type, Field Name
To refresh a live connection from on a worksheet,
a) From the Data menu, select "Refresh All Extracts" b) From the Data menu, select the
Data Source, and then Refresh c) From the Data menu, select the Data Source, and
then Extract Data d) From the Data pane, right-click the Data Source, and select View
Data - Correct Answers -From the Data menu, select the Data Source, and then
Refresh
Which of the following is NOT stored in a Tableau Data Source (.tds) file?
a) Data connection information b) Renamed dimensions and measures c) Worksheet
vizzes d) Folders created to organize dimensions and measures - Correct Answers -
Worksheet vizzes
,When your data is stored in tables from different databases, which of the following
methods allow you to combine the data into a single viz?
a) A join or a union b) A join or a cross-database join c) A union or a data blend d) A
union or a cross-database join e) A data blend or a cross-database join - Correct
Answers -A data blend or a cross-database join
Which of the following combines tables that are related by common fields (columns) and
results in a virtual table that extends horizontally by adding columns of data?
a) A join b) A union c) A blend - Correct Answers -A join
Which of the following is useful when you want to join data but the database you're
using doesn't allow joins (for example, a cube data source)?
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A blend
Which of the following is useful for combining data that is at different levels of detail (for
example combining monthly data with daily data)?
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A blend
Which of the following is useful when combining two tables that have the same fields
(columns) but different rows of data (for example, one has rows of 2018 data and one
has rows of 2019 data)?
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A union
A _________ combines the data and then aggregates it. A _________ aggregates and
then combines the data. a) Join; Blend b) Blend; Join - Correct Answers -Join; Blend
Table A lists Campaign IDs and Campaign Names. Table B lists Customer IDs,
Customer Names, and the Campaign IDs of campaigns with which the customers have
interacted. You join the tables in Tableau Desktop (based on the common Campaign ID
field) with Table A on the left and Table B on the right. You build a crosstab showing
Campaign IDs, Campaign Names, Customer IDs, and Customer Names. If the only
NULL values in the crosstab are in the Customer ID and Customer Name columns,
which of the following is true?
a) An inner join was performed. b) A left join was performed. c) A right join was
performed. d) A full outer join was performed. - Correct Answers -A left join was
performed
Table A lists Campaign IDs and Campaign Names. Table B lists Customer IDs,
Customer Names, and the Campaign IDs of campaigns with which the customers have
interacted. You join the tables in Tableau Desktop (based on the common Campaign ID
, field) with Table A on the left and Table B on the right. You build a crosstab showing
Campaign IDs, Campaign Names, Customer IDs, and Customer Names. If some rows
have NULL values in the Campaign ID and Campaign Name columns while other
different columns have NULL values in the Customer ID and Customer Name columns,
which of the following is true?
a) An inner join was performed. b) A left join was performed. c) A right join was
performed. d) A full outer join was performed. - Correct Answers -A full outer join was
performed.
Table A lists Campaign IDs and Campaign Names. Table B lists Customer IDs,
Customer Names, and the Campaign IDs of campaigns with which the customers have
interacted. You join the tables in Tableau Desktop (based on the common Campaign ID
field) with Table A on the left and Table B on the right. You build a crosstab showing
Campaign IDs, Campaign Names, Customer IDs, and Customer Names. If there are no
NULL values in any of the rows of the crosstab, which of the following is true?
a) An inner join was performed. b) A left join was performed. c) A right join was
performed. d) A full outer join was performed. - Correct Answers -An inner join was
performed
On the Data Source page, we add a cross-database join by:
a) Clicking "Add" next to the word Connections. b) Selecting "New Data Source" from
the Data menu. c) Dragging a Sheet (Table) to the canvas. - Correct Answers -Clicking
"Add" next to the word Connections
____________ requires a primary data source and at least one secondary data source.
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A blend
Which of the following is NOT true about data blending?
a) Data blending applies across all worksheets of a workbook. b) The order in which
fields are used determines which data source is primary and which is secondary. c)
Data blending behaves similarly to a left join, which may result in missing data from the
secondary data source. d) Data from secondary data sources must always be
aggregated in calculations. - Correct Answers -Data blending applies across all
worksheets of a workbook.
In data blending, the primary data source is indicated with a __________ check mark
and any secondary data sources and fields from secondary data sources have a
____________ check mark.
a) Blue; Orange b) Orange; Blue c) Blue; Green d) Green; Blue - Correct Answers -
Blue; Orange
QUESTIONS AND ANSWERS
The three aspects of the Tableau Desktop workflow (in order) are:
a) Connect, analyze, and share b) Analyze, share, and connect c) Share, analyze, and
connect d) Connect, share, and analyze - Correct Answers -Connect, analyze, and
share
Renaming a dimension or measure in Tableau Desktop:
a) Renames it in the underlying data source. b) Does not rename it in the underlying
data source. - Correct Answers -Does not rename it in the underlying data source.
By default, Tableau Desktop:
a) Creates a snapshot of your data as an extract b) Maintains a live connection to your
data source - Correct Answers -Maintains a live connection to your data source
Which of the following can you edit from the Manage Metadata screen?
a) Data Type, Field Name, Table, and Remote Field Name b) Data type, Field Name c)
Table, and Remote Field Name d) Data type, Table, and Remote Field Name - Correct
Answers -Data type, Field Name
To refresh a live connection from on a worksheet,
a) From the Data menu, select "Refresh All Extracts" b) From the Data menu, select the
Data Source, and then Refresh c) From the Data menu, select the Data Source, and
then Extract Data d) From the Data pane, right-click the Data Source, and select View
Data - Correct Answers -From the Data menu, select the Data Source, and then
Refresh
Which of the following is NOT stored in a Tableau Data Source (.tds) file?
a) Data connection information b) Renamed dimensions and measures c) Worksheet
vizzes d) Folders created to organize dimensions and measures - Correct Answers -
Worksheet vizzes
,When your data is stored in tables from different databases, which of the following
methods allow you to combine the data into a single viz?
a) A join or a union b) A join or a cross-database join c) A union or a data blend d) A
union or a cross-database join e) A data blend or a cross-database join - Correct
Answers -A data blend or a cross-database join
Which of the following combines tables that are related by common fields (columns) and
results in a virtual table that extends horizontally by adding columns of data?
a) A join b) A union c) A blend - Correct Answers -A join
Which of the following is useful when you want to join data but the database you're
using doesn't allow joins (for example, a cube data source)?
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A blend
Which of the following is useful for combining data that is at different levels of detail (for
example combining monthly data with daily data)?
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A blend
Which of the following is useful when combining two tables that have the same fields
(columns) but different rows of data (for example, one has rows of 2018 data and one
has rows of 2019 data)?
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A union
A _________ combines the data and then aggregates it. A _________ aggregates and
then combines the data. a) Join; Blend b) Blend; Join - Correct Answers -Join; Blend
Table A lists Campaign IDs and Campaign Names. Table B lists Customer IDs,
Customer Names, and the Campaign IDs of campaigns with which the customers have
interacted. You join the tables in Tableau Desktop (based on the common Campaign ID
field) with Table A on the left and Table B on the right. You build a crosstab showing
Campaign IDs, Campaign Names, Customer IDs, and Customer Names. If the only
NULL values in the crosstab are in the Customer ID and Customer Name columns,
which of the following is true?
a) An inner join was performed. b) A left join was performed. c) A right join was
performed. d) A full outer join was performed. - Correct Answers -A left join was
performed
Table A lists Campaign IDs and Campaign Names. Table B lists Customer IDs,
Customer Names, and the Campaign IDs of campaigns with which the customers have
interacted. You join the tables in Tableau Desktop (based on the common Campaign ID
, field) with Table A on the left and Table B on the right. You build a crosstab showing
Campaign IDs, Campaign Names, Customer IDs, and Customer Names. If some rows
have NULL values in the Campaign ID and Campaign Name columns while other
different columns have NULL values in the Customer ID and Customer Name columns,
which of the following is true?
a) An inner join was performed. b) A left join was performed. c) A right join was
performed. d) A full outer join was performed. - Correct Answers -A full outer join was
performed.
Table A lists Campaign IDs and Campaign Names. Table B lists Customer IDs,
Customer Names, and the Campaign IDs of campaigns with which the customers have
interacted. You join the tables in Tableau Desktop (based on the common Campaign ID
field) with Table A on the left and Table B on the right. You build a crosstab showing
Campaign IDs, Campaign Names, Customer IDs, and Customer Names. If there are no
NULL values in any of the rows of the crosstab, which of the following is true?
a) An inner join was performed. b) A left join was performed. c) A right join was
performed. d) A full outer join was performed. - Correct Answers -An inner join was
performed
On the Data Source page, we add a cross-database join by:
a) Clicking "Add" next to the word Connections. b) Selecting "New Data Source" from
the Data menu. c) Dragging a Sheet (Table) to the canvas. - Correct Answers -Clicking
"Add" next to the word Connections
____________ requires a primary data source and at least one secondary data source.
a) A join b) A union c) A blend d) A cross-database join - Correct Answers -A blend
Which of the following is NOT true about data blending?
a) Data blending applies across all worksheets of a workbook. b) The order in which
fields are used determines which data source is primary and which is secondary. c)
Data blending behaves similarly to a left join, which may result in missing data from the
secondary data source. d) Data from secondary data sources must always be
aggregated in calculations. - Correct Answers -Data blending applies across all
worksheets of a workbook.
In data blending, the primary data source is indicated with a __________ check mark
and any secondary data sources and fields from secondary data sources have a
____________ check mark.
a) Blue; Orange b) Orange; Blue c) Blue; Green d) Green; Blue - Correct Answers -
Blue; Orange
