TABLEAU
EXAM
QUESTIONS
AND ANSWERS
A, B, C - Answers -In which three formats can you export a worksheet from the
Worksheet menu? (Choose three.)
A. .csv
B. .xlsx
C. .png
D. .html
E. .pptx
F. .txt
B - Answers -From Tableau Desktop, you sign in to a Tableau Server site.What appears
in the list of available data sources when you search for a published data source?
A. All the data sources published to the Tableau Server
B. All the data sources published to the site within the folders to which you have access
C. All the data sources published to the Tableau Server within the folders to which you
have access
D. All the data sources published to the site
B - Answers -You have the following string value: Sales Data.Which calculated field
produces an output of Sales?
A. LEFT ("Sales Data")
B. LEFT ("Sales Data", 5)
C. LTRIM ("Sales Data")
D. RTRIM ("Sales Data")
B - Answers -When viewing quick table calculations, such as Percent Difference from,
that use a value in the previous column, what will be the first data value in the
visualization?
,A. Zero (0)
B. Null
C. Duplicated from the nearest column
D. The current value
B,C - Answers -Which two types of fields appear blue? (Choose two.)
A. Continuous measures
B. Discrete dimensions
C. Discrete measures
D. Continuous dimensions
A - Answers -What is created by a calculated field that has a formula of SUM(Sales) /
SUM(Profit)?
A. A measure
B. A dimension
C. A set
D. A parameter
A - Answers -With the Marks card drop-down menu set to Automatic, a line chart will be
created whenever you place what on the Rows shelf and the Columns shelf?
A. Measures on one shelf, and a date dimension on the other
B. Zero or more dimensions on one shelf, and 2 or more measures on the other
C. Zero or more measures on one shelf, and 2 or more dimensions on the other
D. A date dimension followed by a continuous measure on one shelf
B,C,E - Answers -What are three benefits of using an extract as compared to a live
connection to a data source? (Choose three.)
A. A live connection to a data source provides the best performance for data
connections.
B. Calculated fields perform better in workbooks connected to extracts than in
workbooks with live connections to a data source.
C. Extracts are stored in memory (RAM), resulting in faster query performance as
compared with live data connections.
D. An extract reduces the amount of data stored on a client computer as compared to a
live data connection.
E. A live connection to a data source can be slow due to network and user traffic,
whereas a connection to an extract improves performance.
Show Suggested Answer
A,D - Answers -What are two examples of a date value? (Choose two.)
A. January 1, 1995
B. December
C. Wednesday
D. 2020-05-01
, A,C,D - Answers -What are three reasons to use joins instead of relationships? (Choose
three.)
A. You need to use a specific join type.
B. You need to create an extract that will have multiple tables.
C. You need to use row-level security.
D. You need to use a data model that supports shared dimensions.
E. You need to connect to multiple databases.
B,D - Answers -What are two characteristics of relationships? (Choose two.)
A. Relationships will query every table in a data model regardless of whether the fields
are in the visualization.
B. Relationships will query only the tables and fields needed to create a visualization.
C. Relationships are only supported when using extracts.
D. Relationships are aware automatically of the native level of detail of logical tables.
B - Answers -When creating a histogram in Tableau, to what does bin size refer?
A. The maximum number of marks in the view
B. The range of the continuous measure counted in each bin
C. The count distinct (COUNTD) of items on either axis
D. The minimum number of axis ticks in the view
C - Answers -When should you use a relationship instead of a join for two data sets?
A. To use both data sets across multiple sheets in a visualization.
B. The data sets are in two separate tables within a single spreadsheet.
C. The data sets include similar data aggregated at different levels of detail.
D. The data sets include similar data aggregated up to the highest level.
D - Answers -How can you access options to apply bold formatting to an axis in the
view?
A. Select Text on the Marks card.
B. Select Field Labels on the Format menu.
C. Right-click on the Field and select Format.
D. Right-click on the axis.
Show Suggested Answer
B - Answers -When creating a data source, how can you add additional connections to
different databases?
A. From the drop-down menu of the current connection, select Edit Connection.
B. From the Connections pane, select Add.
C. From the Data menu, select New Data Source.
D. From the File menu, select New.
C - Answers -You need to display the complete list of potential data connections when
you connect to a server.What action should you perform?
A. Select Connecting to Data.
B. Select More under To a File.
EXAM
QUESTIONS
AND ANSWERS
A, B, C - Answers -In which three formats can you export a worksheet from the
Worksheet menu? (Choose three.)
A. .csv
B. .xlsx
C. .png
D. .html
E. .pptx
F. .txt
B - Answers -From Tableau Desktop, you sign in to a Tableau Server site.What appears
in the list of available data sources when you search for a published data source?
A. All the data sources published to the Tableau Server
B. All the data sources published to the site within the folders to which you have access
C. All the data sources published to the Tableau Server within the folders to which you
have access
D. All the data sources published to the site
B - Answers -You have the following string value: Sales Data.Which calculated field
produces an output of Sales?
A. LEFT ("Sales Data")
B. LEFT ("Sales Data", 5)
C. LTRIM ("Sales Data")
D. RTRIM ("Sales Data")
B - Answers -When viewing quick table calculations, such as Percent Difference from,
that use a value in the previous column, what will be the first data value in the
visualization?
,A. Zero (0)
B. Null
C. Duplicated from the nearest column
D. The current value
B,C - Answers -Which two types of fields appear blue? (Choose two.)
A. Continuous measures
B. Discrete dimensions
C. Discrete measures
D. Continuous dimensions
A - Answers -What is created by a calculated field that has a formula of SUM(Sales) /
SUM(Profit)?
A. A measure
B. A dimension
C. A set
D. A parameter
A - Answers -With the Marks card drop-down menu set to Automatic, a line chart will be
created whenever you place what on the Rows shelf and the Columns shelf?
A. Measures on one shelf, and a date dimension on the other
B. Zero or more dimensions on one shelf, and 2 or more measures on the other
C. Zero or more measures on one shelf, and 2 or more dimensions on the other
D. A date dimension followed by a continuous measure on one shelf
B,C,E - Answers -What are three benefits of using an extract as compared to a live
connection to a data source? (Choose three.)
A. A live connection to a data source provides the best performance for data
connections.
B. Calculated fields perform better in workbooks connected to extracts than in
workbooks with live connections to a data source.
C. Extracts are stored in memory (RAM), resulting in faster query performance as
compared with live data connections.
D. An extract reduces the amount of data stored on a client computer as compared to a
live data connection.
E. A live connection to a data source can be slow due to network and user traffic,
whereas a connection to an extract improves performance.
Show Suggested Answer
A,D - Answers -What are two examples of a date value? (Choose two.)
A. January 1, 1995
B. December
C. Wednesday
D. 2020-05-01
, A,C,D - Answers -What are three reasons to use joins instead of relationships? (Choose
three.)
A. You need to use a specific join type.
B. You need to create an extract that will have multiple tables.
C. You need to use row-level security.
D. You need to use a data model that supports shared dimensions.
E. You need to connect to multiple databases.
B,D - Answers -What are two characteristics of relationships? (Choose two.)
A. Relationships will query every table in a data model regardless of whether the fields
are in the visualization.
B. Relationships will query only the tables and fields needed to create a visualization.
C. Relationships are only supported when using extracts.
D. Relationships are aware automatically of the native level of detail of logical tables.
B - Answers -When creating a histogram in Tableau, to what does bin size refer?
A. The maximum number of marks in the view
B. The range of the continuous measure counted in each bin
C. The count distinct (COUNTD) of items on either axis
D. The minimum number of axis ticks in the view
C - Answers -When should you use a relationship instead of a join for two data sets?
A. To use both data sets across multiple sheets in a visualization.
B. The data sets are in two separate tables within a single spreadsheet.
C. The data sets include similar data aggregated at different levels of detail.
D. The data sets include similar data aggregated up to the highest level.
D - Answers -How can you access options to apply bold formatting to an axis in the
view?
A. Select Text on the Marks card.
B. Select Field Labels on the Format menu.
C. Right-click on the Field and select Format.
D. Right-click on the axis.
Show Suggested Answer
B - Answers -When creating a data source, how can you add additional connections to
different databases?
A. From the drop-down menu of the current connection, select Edit Connection.
B. From the Connections pane, select Add.
C. From the Data menu, select New Data Source.
D. From the File menu, select New.
C - Answers -You need to display the complete list of potential data connections when
you connect to a server.What action should you perform?
A. Select Connecting to Data.
B. Select More under To a File.
