1.What are two methods for renaming a field in a 9.What are two examples of a date value?

(Choose
visualization? (Choose two.) two.)
A. From the Data pane, use the field’s drop-down A. January 1, 1995
menu and select Rename. B. December
B. From the Data pane, right-click the field and select C. Wednesday
Replace References. D. 2020-05-01
C. From the Data pane, click and hold on the field
until the name is editable.
D. From the Format menu, select Field Labels. 10.What are three reasons to use joins instead of
relationships? (Choose three.)
2.Which statement accurately describes aliases? A. You need to use a specific join type.
A. You can assign an alias to a field member before B. You need to create an extract that will have multiple
creating a visualization. tables.
B. When you assign an alias, the name changes in the C. You need to use row-level security.
database. D. You need to use a data model that supports shared
C. You can create an alias for a discrete measure. dimensions.
D. You can create an alias for a continuous dimension. E. You need to connect to multiple databases.

11.What are three benefits of using an extract as

5.You need to invert the color intensity of a compared to a live connection to a data source?
quantitative range. (Choose three.)
Which option should you use? A. A live connection to a data source provides the best
A. Border performance for data connections.
B. Reversed B. Calculated fields perform better in workbooks
C. Opacity connected to extracts than in workbooks with live
D. Stepped Color connections to a data source.
C. Extracts are stored in memory (RAM), resulting in
6.You need to display the complete list of potential faster query performance as compared with live data
data connections when you connect to a server. connections.
What action should you perform? D. An extract reduces the amount of data stored on a
A. Select Connecting to Data. client computer as compared to a live data connection.
B. Select More under To a File. E. A live connection to a data source can be slow due
C. Select More under To a Server. to network and user traffic, whereas a connection to an
D. Select File on the menu, and then select New. extract improves performance.

7.When creating a data source, how can you add 12.Which string function should you use to find a
additional connections to different databases? substring within a column and return a Boolean value?
A. From the drop-down menu of the current A. RTRIM
B. SPLIT
connection, select Edit Connection.
C. CONTAINS
B. From the Connections pane, select Add. D. ENDSWITH
C. From the Data menu, select New Data Source.
D. From the File menu, select New. 13.Which string function return a Boolean value as a
result?
8.What are two characteristics of relationships? A. FIND
(Choose two.) B. STARTSWITH
A. Relationships will query every table in a data model C. CHAR
regardless of whether the fields are in the visualization. D. UPPER
B. Relationships will query only the tables and fields
needed to create a visualization. 14.You want to assign the Latitude geographic role to a
C. Relationships are only supported when using field.
extracts. What should be the data type and the data role of the
D. Relationships are aware automatically of the native field? (Choose two.)
level of detail of logical tables. A. String
B. Dimension
C. Measure
D. Number (decimal)
15.Which two statements accurately describe Which two filter modes can you use with dimension
relationships in Tableau Desktop? (Choose two.) filters? (Choose two.)
A. Used to establish an explicit join type A. Range of Values
B. Maintains tables separately in the data source B. At most
C. Used to join physical tables into a single logical C. Wildcard Match
table D. Multiple Values (drop-down)
D. Maintains each table’s level of detail (LOD)
without duplicating records When viewing quick table calculations, such as
Percent Difference from, that use a value in the
16. How can you access options to apply bold previous column, what will be the first data value in
formatting to an axis in the view? the visualization?
A. Select Text on the Marks card. A. Zero (0)
B. Select Field Labels on the Format menu. B. Null
C. Right-click on the Field and select Format. C. Duplicated from the nearest column
D. Right-click on the axis D. The current value

17. With the Marks card drop-down menu set to Which two types of aggregations can be applied to
Automatic, a line chart will be created whenever you string fields? (Choose two.)
place what on the Rows shelf and the Columns shelf? A. Minimum
A. Measures on one shelf, and a date dimension on the B. Sum
other C. Average
B. Zero or more dimensions on one shelf, and 2 or D. Count Distinc
more measures on the other
C. Zero or more measures on one shelf, and 2 or more You create a crosstab that shows a list of 100 hotel
dimensions on the other chains alongside their average nightly cost. You also
D. A date dimension followed by a continuous create two groups showing, respectively, the top 10
measure on one shelf and bottom 10 hotel chains by cost, with subtotals.
What should you do to improve the crosstab and
18. When should you use a relationship instead of a compare the two groups to all the remaining hotel
join for two data sets? chains?
A. To use both data sets across multiple sheets in a A. Create a new view.
visualization. B. Color encode the hotel chain names.
B. The data sets are in two separate tables within a C. Include an Other group.
single spreadsheet. D. Include the Summary card.
C. The data sets include similar data aggregated at
different levels of detail. You have the following string value: Sales Data.
D. The data sets include similar data aggregated up to Which calculated field produces an output of Sales?
the highest level. A. LEFT (“Sales Data”)
B. LEFT (“Sales Data”, 5)
What is created by a calculated field that has a formula C. LTRIM (“Sales Data”)
of SUM(Sales) / SUM(Profit)? D. RTRIM (“Sales Data”)
A. A measure
B. A dimension You create a dual axis chart that shows sales and profit
C. A set over time.
D. A parameter What should you do to distinguish sales from profit?
(Choose two.)
Which two types of fields appear blue? (Choose two.) A. Adjust the time frame displayed.
A. Continuous measures B. Change the mark types of sales and profit.
B. Discrete dimensions C. Adjust the aggregations for sales and profit to be
C. Discrete measures different.
D. Continuous dimensions D. Change the color of sales and profit.
What are two use cases for creating hierarchies from Which statement accurately describes an extract when
the Data pane? (Choose two.) the Physical Tables option is selected?
A. To organize related fields together A Data is limited to only the Top N of data for the
B. To add drilldown functionality for fields connection.
C. To create faster-performing queries B All the data is tolled up to the current visible fields.
D. To concatenate all fields into a single field C An individual table is created for each physical table
in the extract.
From which three locations can you sort a D Data shown in the Data pane is separated based on
visualization? (Choose three.) the table type.
A. The Analysis menu
B. Tooltip on the Marks card You have the following visualization.
C. An axis
D. The Worksheet menu
E. A field label
F. A header
Which set type is created when you select the Create
Which statement accurately describes creating a group Set option?
by selecting headers in a view? A A fixed set
A. The grouped dimension is added to Color. B A dynamic set
B. A newly created group only exists in the current C A Top N set
view. D A combined set
C. A new group updates the aliases from the selected
headers. You need to display the complete list of potential
D. The grouped dimension replaces the original data connections when you connect to a server.
dimension field on Rows or Columns. What action should you perform?
A. Select Connecting to Data.
B. Select More under To a File.
You want to provide additional information when C. Select More under To a Server.
hovering over a field in the Data pane as shown in the D. Select File on the menu, and then select New.
following exhibit.
What should you configure for the field? When creating a data source, how can you add
A. An alias additional connections to different databases?
B. A header label A. From the drop-down menu of the current
C. A default comment connection, select Edit Connection.
D. A hierarchy B. From the Connections pane, select Add.
C. From the Data menu, select New Data Source.
You want to save a view as an image that you can paste D. From the File menu, select New.
into a Microsoft Word document. Which two
statements accurately describe exporting a view as an How can you access options to apply bold formatting
image? Choose two. to an axis in the view?
A Default exports include everything in the view, A. Select Text on the Marks card.
including Tableau fonts. B. Select Field Labels on the Format menu.
B The default export format is TIFF. C. Right-click on the Field and select Format.
C The default export format is PNG. D. Right-click on the axis.
D The exported image is a vector-based file that
embeds the Tableau fonts. Which two filter modes can you use with dimension
filters? (Choose two.)
A. Range of Values
How can you create a packaged data source? B. At most
A From the Worksheet menu, select Export, and then C. Wildcard Match
select Data. D. Multiple Values (drop-down)
B From the Data pane, right-click the data connection,
and then select Add to Saved Data Sources.
C From the File menu, select Share.
D From the File menu, select Save As.
You are creating a combined axis chart. What is the purpose of a context filter?
Where should you drag the second measure after A. It sorts data in ascending order
dragging the first measure to the Rows shelf? B. It improves performance by filtering
A. The Marks card before other filters (correct)
B. The Filter card C. It combines multiple filters
C. The horizontal axis in the view D. It only applies to dimensions
D. The vertical axis in the view
6. Which function is used to create a
To best improve the display of a scatter plot that has calculated field for profit per unit in
overlapping shapes, you should adjust the Tableau?
_____________ of the marks. A. SUM([Profit]) / SUM([Quantity])
A. mark size (correct)
B. mark borders B. AVG([Profit] * [Quantity])
C. color opacity C. [Profit] + [Quantity]
D. color palette D. COUNT([Profit])

7. What happens when you drag a discrete

Basic Concepts field to the Columns shelf?
1. Which of the following is NOT a data type A. It creates a line chart
in Tableau? B. It creates headers for each unique value
A. String (correct)
B. Boolean C. It applies a filter
C. Date D. It changes the field to continuous
D. Character (correct)
8. What does a green pill in Tableau
2. Which of the following operations can be represent?
performed in the Data Source tab? A. A continuous field (correct)
A. Creating calculated fields B. A discrete field
B. Joining tables (correct) C. A string data type
C. Creating dashboards D. A calculated measure
D. Formatting visuals
9. Which of the following actions can you
3. Which of the following file types can perform in the Data pane?
Tableau connect to? A. Create calculated fields
A. Excel B. Change data types
B. JSON C. Group fields
C. SQL Server D. All of the above (correct)
D. All of the above (correct)
11. What is the primary use of a dual-axis chart
4. What is a data extract in Tableau? in Tableau?
A. A static snapshot of data stored for A. To compare two measures on different
performance improvement (correct) scales (correct)
B. A direct live connection to a data source B. To add a second dimension to a scatter plot
C. A Tableau dashboard component C. To filter data dynamically
D. A visualization format D. To show percentages

5. What is the default data connection type 12. Which of the following charts is best for
when connecting to an Excel file in analyzing trends over time?
Tableau? A. Pie Chart
A. Live connection (correct) B. Bar Chart
B. Extract C. Line Chart (correct)
C. SQL D. Heatmap
D. Hyper file
13. Which shelf is used to control the shape, 20. Which type of filter allows users to select a
color, and size of marks in a visualization? range of values dynamically?
A. Marks card (correct) A. Dimension filter
B. Rows shelf B. Range filter (correct)
C. Columns shelf C. Extract filter
D. Filters shelf D. Data source filter

14. How can you display two different measures Dashboards & Stories
on the same axis in Tableau? 21. What is a dashboard in Tableau?
A. Use a bar chart A. A collection of multiple visualizations on
B. Use a table calculation a single view (correct)
C. Drag the second measure onto the first B. A type of calculated field
measure's axis (correct) C. A single worksheet
D. Use a pie chart D. A type of data connection

15. Which visualization is best for comparing 22. How can you add interactivity to a
proportions? dashboard in Tableau?
A. Line Chart A. Using dashboard actions
B. Pie Chart (correct) B. Applying filters
C. Histogram C. Using parameters
D. Box Plot D. All of the above (correct)

16. Which type of filter is used to include or 23. What is a Tableau Story?
exclude data from the visualization? A. A sequence of dashboards or sheets to
A. Group create a narrative (correct)
B. Set B. A type of calculated field
C. Dimension Filter (correct) C. A type of map visualization
D. Trend D. A dashboard element

17. What is the key difference between a filter 24. Which feature allows users to apply the
and a parameter in Tableau? same filter across multiple sheets in a
A. Parameters are dynamic inputs that dashboard?
allow users to control values, while filters A. Measure Filters
remove data from the view (correct) B. Worksheet Filters
B. Filters are applied to dashboards only C. Dashboard Filter Actions (correct)
C. Parameters cannot be used in calculated D. Parameter Controls
fields
D. Filters work only with measures 25. Which of the following is NOT a component
of a Tableau dashboard?
18. Where can you find all the filters applied to A. Worksheet
a worksheet? B. Dashboard Actions
A. In the Data pane C. Objects
B. On the Filters shelf (correct) D. Relationships (correct)
C. In the Marks card
D. In the Pages shelf Data Connections & Joins
26. What is the purpose of using joins in
19. What happens when you apply a quick filter Tableau?
in Tableau? A. To combine related data from multiple
A. It creates an interactive filter for the user tables (correct)
(correct) B. To filter data
B. It permanently removes data from the C. To create calculated fields
dataset D. To duplicate data
C. It sorts the data
D. It generates a calculated field
27. Which type of join includes only matching 34. How can you apply a Table Calculation in
records from both tables? Tableau?
A. Left Join A. By right-clicking a measure and selecting
B. Right Join “Add Table Calculation” (correct)
C. Inner Join (correct) B. By creating a parameter
D. Full Outer Join C. By using a filter
D. By joining tables
28. Which join type includes all records from
the left table and only matching records 35. Which option in Table Calculation allows
from the right table? running computations across the entire
A. Left Join (correct) table?
B. Right Join A. Compute using Cell
C. Inner Join B. Compute using Table (Across) (correct)
D. Cross Join C. Compute using Pane
D. Compute using Column
29. What is the main difference between
relationships and joins in Tableau? 36. How can you sort data in Tableau?
A. Joins create a new dataset, while A. Using the Sort button in the toolbar
relationships keep tables independent B. Sorting directly in the visualization
B. Relationships allow flexible data C. Using calculated fields
modeling, while joins combine tables D. All of the above (correct)
immediately (correct)
C. Joins are faster than relationships 37. Which feature allows grouping similar data
D. Relationships create calculated fields points into a single category?
A. Filters
30. Which Tableau connection allows you to B. Groups (correct)
combine data from multiple sources? C. Joins
A. Data Extracts D. Hierarchies
B. Blending (correct)
C. Filtering 38. What is the difference between Groups and
D. Aggregations Sets?
A. Groups combine values into a single
31. What is a Table Calculation in Tableau? category, while Sets create dynamic subsets
A. A computation applied at the (correct)
visualization level (correct) B. Sets are static, Groups are dynamic
B. A database function C. Groups can be used in filters, Sets cannot
C. A calculated field D. Groups filter data
D. A type of filter
39. What is a hierarchy in Tableau?
32. Which of the following is a commonly used A. A structured way of organizing related
Table Calculation? fields (correct)
A. SUM B. A type of join
B. COUNT C. A method of sorting data
C. Running Total (correct) D. A Table Calculation
D. IF statement
Which method can be used to create a
33. Which function helps calculate the hierarchy in Tableau?
difference between two rows in Tableau? A. Dragging one field onto another in the
A. INDEX() Data pane (correct)
B. LOOKUP() (correct) B. Using a calculated field
C. SUM() C. Applying a filter
D. COUNT() D. Creating a dashboard
 47. Which field type is typically used on the
Maps & Spatial Data Filters shelf for date-based filtering?
40. Which type of visualization is used to A. Continuous Date (correct)
display geographic data? B. Discrete Dimension
A. Bar Chart C. Boolean
B. Scatter Plot D. String
C. Map (correct)
D. Pie Chart 48. How can you show the top 10 performing
products in a dataset?
41. What does Tableau use to recognize A. Using calculated fields
geographic fields? B. Applying a Top N filter (correct)
A. Latitude and Longitude (correct) C. Using Sets
B. Field names D. Creating a new hierarchy
C. Calculated fields
D. Table Calculations 49. Which function is used to check if a value
exists in a Set?
42. How do you add custom map layers in A. IN (correct)
Tableau? B. COUNT()
A. By adding background images or C. SUM()
Mapbox maps (correct) D. AVG()
B. By changing field types
C. By using calculated fields 50. What is the primary benefit of using
D. By applying a filter Extracts instead of Live connections?
A. Improved performance (correct)
43. Which map type allows the visualization of B. Real-time data updates
density? C. Reduced storage usage
A. Filled Map D. Increased data granularity
B. Line Map
C. Heat Map (correct) 51. Which type of filter improves dashboard
D. Scatter Map performance?
A. Context Filter (correct)
44. Which of the following is NOT a valid B. Measure Filter
geographic field in Tableau? C. Parameter
A. Country D. Quick Filter
B. Sales (correct)
C. City 52. Which optimization technique speeds up
D. State large datasets?
A. Using live connections
Advanced Concepts B. Applying more filters
45. What does the Pages shelf do in Tableau? C. Aggregating data before importing into
A. Creates filters Tableau (correct)
B. Animates data across different values D. Using multiple joins
(correct)
C. Applies calculations 53. What does Data Blending use to match
D. Generates calculated fields records between datasets?
A. Common dimensions (correct)
46. Which feature allows highlighting specific B. Relationships
data points in Tableau? C. Joins
A. Highlight Action (correct) D. Hierarchies
B. Filter Action
C. Sets
D. Data Blending
 54. Which feature can be used to improve What are three options to change the scope of a
dashboard performance? reference line? Choose three.
A. Reducing the number of marks in a Options:
visualization (correct) A- Per Pane
B. Using multiple live connections B- Fill Above
C. Adding more complex filters C- Entire Table
D. Using a pie chart D- Maximum
E- Per Cell
55. Which feature can be used to improve Answer:
dashboard performance? A, C, E
A. Reducing the number of marks in a Explanation:
visualization (correct) You can change the scope of a reference line by
B. Using multiple live connections choosing one of the following options: Per Pane,
C. Adding more complex filters Entire Table, or Per Cell. The scope determines how
D. Using a pie chart many reference lines are added to the view
and how they are calculated. Per Pane adds one
Which of the following situations describe the best reference line for each pane in the view. Entire
reason to use a union? Table adds one reference line for the entire table in the
Options: view.Per Cell adds one reference line for
A- You have two tables with similarly named columns each cell in the view
of data that you want to combine.
B- You have two data sets with similar data types for When creating a date filter in Tableau, to what does
which you want to find only distinct values. Anchor refer?
C- You have two tables with differently named Options:
columns of data that you want to combine. A- The mid-point in the range of displayed dates.
D- You have two data sets saved in different formats B- The date in a relative-date filter to which you
that you want to unify into a single format. anchor a unit of time.
Answer:A C- The date in a range-of-dates filter to which you
anchor units of time.
Explanation: D- The latest date in the data source that can be found.
You should use a union when you have two tables with Answer:B
similarly named columns of data that you
want to combine. A union is a method for combining Explanation:
data by appending rows of one table onto When creating a date filter in Tableau, anchor refers to
another table.The tables that you union must have the the date in a relative-date filter to which
same number of fields, the same field names, and the you anchor a unit of time. A relative-date filter is a
same data types2 type of filter that allows you to dynamically
filter data based on a range of time relative to the
Which two filter modes can you use with continuous current date or a specific date.For example,
filters? Choose two. you can use a relative-date filter to show data for the
Options: last 7 days, the next 3 months, or the
A- Multiple Values current quarter1To create a relative-date filter, you
B- Special need to specify the following options: The
C- Range of Values date field that you want to filter. The unit of time that
D- Single Values you want to use for the filter, such as days,
Answer:B, C weeks, months, quarters, or years. The range of time
that you want to show relative to the
Explanation: anchor date, such as last, next, this, or to date. The
According to the Tableau Help, there are two filter anchor date that you want to use as the
modes for continuous filters: Range of Values reference point for the filter.You can use the current
and Single Value. The help also states that ''Range of date or a custom date as the anchor
Values lets you specify a minimum and date1For example, if you want to create a relative-date
maximum value for the filter using sliders or input filter that shows data for the last 3
fields'' and ''Single Value lets you select one months from January 1st, 2022, you would select the
value on a slider for the filter'' (page 1). following options: Date field: Order Date
Unit of time: Months Range of time: Last 3 Anchor computations that are applied to the values in an entire
date: Custom (01/01/2022)1The other options table or partition of a table.Table
are not valid definitions of anchor when creating a date calculations can be created by selecting them from the
filter in Tableau. The mid-point in the context menu of a measure or by using
range of displayed dates is not related to the anchor functions in a calculated field
date, but rather to the center of the axis
that represents the date field. The date in a range-of- Tableau will automatically create a hierarchy for which
dates filter to which you anchor units of two kinds of data? Choose two.
time is not correct, because a range-of-dates filter does Options:
not use an anchor date, but rather a start A- Date & Time
and end date that can be fixed or dynamic.The latest B- Date
date in the data source that can be found is C- Geographic
not related to the anchor date, but rather to the D- String
maximum value of the date field in the data Answer:A, D
source Explanation:
Tableau will automatically create a hierarchy for date
You have a continuous numeric measure named Sales. and geographic data. A hierarchy is a way
Which chart type is created when you double-click the of organizing data into different levels of detail. For
Sales measure? example, a date hierarchy can have year,
Options: quarter, month, and day levels. A geographic hierarchy
A- A text table can have country, state, city, and zip
B- A line chart code levels. Tableau recognizes date and geographic
C- A pie chart data based on their data types and formats,
D- A bar chart and creates hierarchies for them by default.Tableau
Answer:D does not automatically create hierarchies for
Explanation: date & time or string data
When you double-click a continuous numeric measure
named Sales in Tableau, it automatically Which two elements can have their values changed by
creates a bar chart. Tableau's default behavior for a using a dashboard action? Choose two.
single measure is to display it as a bar chart, Options:
with the measure values represented on the Y-axis and A- Bins
an automatic range on the X-axis. B- Groups
C- Sets
Which aggregation is available without requiring a D- Parameters
table calculation or calculated field? Answer:C, D
Options: Explanation:
A- Running total In Tableau, the two elements that can have their values
B- Standard deviation changed by using a dashboard action are
C- Sample covariance Sets and Parameters. Dashboard actions can be
D- Percent of total configured to modify the values within a set or a
Answer:B parameter, allowing for interactive and dynamic
Explanation: changes in the visualization based on user
Standard deviation is an aggregation that is available interactions. For example, selecting a specific data
without requiring a table calculation or point in a dashboard can trigger an action
calculated field. Standard deviation is a statistical that updates a set or changes the value of a parameter,
measure that shows how much variation there which in turn can alter the displayed
is from the average value in a set of data.Standard data or the appearance of visualizations within the
deviation is one of the predefined dashboard.
aggregations in Tableau that can be applied to any
measure by selecting it from the context You have a bar chart that has a dimension on the
menu of the measure or from the drop-down menu on Columns shelf and a measure on the Rows
the Marks card6The other options are not shelf.
aggregations that are available without requiring a How can you make a stacked bar chart?
table calculation or calculated field. Running Options:
total, sample covariance, and percent of total are all A- Drag another dimension to Color on the Marks card
examples of table calculations, which are B- Drag another measure to Color on the Marks card.
C- Drag another dimension to Size on the Marks card. Configure URL: After placing the web page object, a
D- Drag another measure to the left of the measure on dialog box will prompt you to enter the URL
the Rows shelf. of the web page you want to display. Enter your
Answer:A company's web page URL here.
Explanation: Resize and Position: Adjust the size and position of the
To create a stacked bar chart in Tableau, you can drag a web page object to fit your dashboard
second dimension to the Color shelf on design.
the Marks card. This action will segment the bars
already present in the chart by the new You have the following legend.
dimension, stacking the segments on top of each other What occurs when you click the icon to the right of Air
within each bar. This is a common Ticketing Cabin Type Name?
method to add additional layers of detail to a bar chart Options:
and effectively compare parts to a whole A- The filter options open.
across categories. B- The legend toggles on or off.
C- The highlighter toggles on or off.
What are two examples of a date value? D- The Edit Colors dialog box opens
Choose two. Answer:C
Options: Explanation:
A- 2020-05-01 When you click the icon to the right of Air Ticketing
B- December Cabin Type Name, the highlighter toggles on
C- Wednesday or off. The highlighter is a feature that allows you to
D- January 1.1995 highlight marks in the view that match a
Answer:A, D specific value or condition. You can access the
Explanation: highlighter by clicking the icon next to a
Date values in Tableau represent specific points in time dimension or measure in the legend, filter, or
and are typically formatted in a standard parameter. The icon looks like a light bulb with a
date format. plus sign. When you click the icon, a highlighter box
Option A, '2020-05-01', is a standard date format will appear where you can enter or select a
representing the 1st of May 2020. value to highlight. The marks that match the value will
Option D, 'January 1, 1995', is another example of a be highlighted in the view, while the
date value, representing the 1st of January, others will be dimmed. You can also use the
1995. Options B ('December') and C ('Wednesday') highlighter box to search for values, clear the
represent a month and a day of the week, highlighting, or lock the highlighting. To turn off the
respectively, but do not specify a particular date. highlighter, you can click the icon again or
close the highlighter box. The other options are not
You create a dashboard that tracks your teams progress correct descriptions of what occurs when you
on various projects. On the dashboard, click the icon to the right of Air Ticketing Cabin Type
you want to display your company's web page. Which Name. The filter options do not open,
dashboard element should you use? because the icon is not for filtering, but for
Options: highlighting. The legend does not toggle on or off,
A- A navigation object because the icon is not for showing or hiding the
B- A URL action legend, but for accessing the highlighter. The
C- An extension Edit Colors dialog box does not open, because the icon
D- A web page object is not for changing the colors of marks,
Answer:D but for highlighting them.
Explanation:
To display your company's web page on a Tableau
dashboard, you should use a web page object.
The web page object allows you to embed a web page
within your Tableau dashboard, providing
direct access to external web content.
Open your Dashboard: Start by opening the dashboard
where you want to add the web page.
Add Web Page Object: In the Objects section of the
dashboard pane, select the 'Web Page' object
and drag it onto your dashboard.
The option to create bins is available for which type of cannot use Shape to change the shape of circles in this
field? view. Heat maps are views that show the
Options: distribution of two or more measures by using a color
A- Boolean gradient and size. You can create a heat
B- String map by placing one or more dimensions on Columns
C- Date and Rows and two measures on Color and
D- Numeric Size on the Marks card.You cannot use Shape to
Answer:D change the shape of marks in this view
Explanation:
The option to create bins in Tableau is available for Which action describes the process for changing a
numeric fields. Bins allow you to group a measure so that it automatically aggregates
series of numeric values into larger segments, which an average instead of a sum?
can simplify analysis and help in creating Options:
histograms or other visualizations that show the A- Right-click the field in the Data pane and select
distribution of data. For example, you can create Default Properties to change it.
bins to group ages into categories like 0-10, 11-20, etc. B- Add the field to the view, right-click the axis, and
select Format to change it.
The Shape option is available for which two views? C- Right-click the field in the Data pane and select
Choose two. Change Data Type to change it.
Options: D- Right-click and drag the field into the view to
A- Side-by-side circles change it.
B- Scatter plots Answer:A
C- Heat maps Explanation:
D- Packed bubbles To change a measure so that it automatically
Answer:B, D aggregates as an average instead of a sum, you
Explanation: should right-click the field in the Data pane and select
The Shape option is available for scatter plots and Default Properties. In the Default
packed bubbles views. The Shape option Properties menu, you can set the default aggregation
allows you to change the shape of marks in the view for the measure, such as setting it to
by selecting from a predefined set of shapes calculate an average by default when added to a view
or adding custom shapes.You can access the Shape
option by placing any field on Shape on the Which two options can you use to change the device
Marks card4Scatter plots are views that show the layout of a dashboard? Choose two.
relationship between two numerical variables Options:
by plotting them as coordinates on a Cartesian plane. A- The Dashboard pane
You can create a scatter plot by placing at B- The Format menu
least one measure on Columns and at least one C- The Dashboard menu
measure on Rows on the Marks card.You can D- The Layout pane
then use Shape to assign different shapes to different Answer:A, D
categories or segments in your Explanation:
data5Packed bubbles are views that show hierarchical You can change the device layout of a dashboard by
data as a set of nested circles. Each circle using the Dashboard pane or the Dashboard
represents a dimension member and its size is menu. The Dashboard pane allows you to select a
proportional to a measure value. You can create a device type and customize the layout for that
packed bubble chart by placing one or more device. The Dashboard menu allows you to create a
dimensions on Detail and one measure on Size on new device layout or copy an existing
the Marks card.You can then use Shape to change the one.The Format menu and the Layout pane do not have
shape of circles to other shapes such as options for changing the device layout
squares or stars6The other options are not valid views
for using the Shape option. Side-by-side How can you set the default properties of a field to
circles are views that show proportions of a whole by Currency?
using circles with different angles and sizes Options:
arranged horizontally or vertically. You can create a A- From the Data pane, configure the number format
side-by-side circle chart by placing one of the field.
dimension on Columns or Rows and one measure on B- From the Format menu, configure the Font settings
Angle and Size on the Marks card.You
C- From the Format menu, configure the Field Labels True or False:When relating tables, the fields that
settings. define the relationships must have the same
D- From the Data pane, configure the data type of the data type.
field. Options:
Answer:A A- True
Explanation: B- False
To set the default properties of a field to Currency in Answer:A
Tableau, you need to configure the number Explanation:
format of the field from the Data pane. This can be According to the official documentation, the following
done by right-clicking the field in the Data are the requirements for using
pane and selecting Default Properties, then choosing 1) When relating tables, the fields that define the
the appropriate number format (in this relationshipsmusthave the same data type.
case, Currency). Changing the data type in the Data Source page does
not change this requirement. Tableau will
True or False:When you drag additional tables to the still use the data type in the underlying database for
logical layer canvas, Tableau automatically queries. 2) You can't define relationships based on
attempts to create the relationship based on existing geographic fields. 3) Circular relationships aren't
key constraints and matching fields to supported in the data model. 4) You can't edit
define the relationship. If it can't determine the relationships in a published data source.
matching fields, then relating these tables is not 5) You can't define relationships between published
possible. data sources. 6) Your workbook must use an embedded
Options: data source for you to be able to edit relationships and
A- True performance options in the Data Source page in
B- False Tableau Online or Tableau Server.
Answer:B
Explanation: Which of the following are benefits of combining
Tables that you drag to the logical layer of the Data sheets using dashboards?
Source page canvas must be related to each Options:
other. When you drag additional tables to the logical A- Easier to compare visualisations side by side
layer canvas, Tableau automatically B- It is mandatory to combine sheets when using
attempts to create the relationship based on existing Tableau
key constraints and matching fields to C- Helps in faster analysis
define the relationship. If it can't determine the D- Provides the ability to use one sheet as a filter for
matching fields, you will need to select them. other
If no constraints are detected, aMany-to- Answer:A, C, D
manyrelationship is created and referential integrity is Explanation:
set toSome records match. These default settings are a The only incorrect option is -It is mandatory to
safe choice and provide the most a lot of combine sheets when using Tableau.
flexibility for your data source. All others are valid advantages that Dashboards
provide when using Tableau!
Which of the following are valid options to define the
scope of a reference line? Choose 3. With the Marks card drop-down menu set to
Options: Automatic, a line chart will be created whenever you
A- Pane place what on the Rows shelf and the Columns shelf?
B- Table Options:
C- Section A- Measures on one shelf, and a date dimension on the
D- Window other
E- cell B- Zero or more dimensions on one shelf, and 2 or
F- Axis more measures on the other
Answer: C- A date dimension followed by a continuous measure
A, B, E on one shelf
D- Zero or more measures on one shelf, and 2 or more
dimensions on the other
Answer:A
Explanation: When you use the 'Create Set' option in Tableau, it
According to theTableau Desktop Specialist Exam creates a dynamic set if the conditions for
Readiness, a line chart will be created inclusion in the set are based on a calculation or an
whenever you place measures on one shelf, and a date aggregation that may change as the data is
dimension on the other. This is because updated or as filters are applied. Fixed sets are static
Tableau automatically recognizes date fields and treats and do not change with data refreshes,
them as continuous dimensions. while dynamic sets can update to reflect the current
state of the data.
You need to display the complete list of potential data
connections when you connect to a server. Which of the following are True for Measure Names?
What action should you perform? Options:
Options: A- It contains all the measures in your data, collected
A- Select File on the menu, and then select New into a single field with continuous values.
B- Select Connecting to Data. B- When you add it to a view, all of the measure names
C- Select More under To a Server appear as row or column headers in the
D- Select More under To a File. view.
Answer:C C- When working with a text table showing Profit for
Explanation: each Category,
To display the complete list of potential data when you add Sales to the text table (by dragging it
connections when connecting to a server in Tableau, and dropping it in the view), the measure
you should select 'More' under the 'To a Server' option. names field is automatically dragged to the row and
This action will provide a comprehensive filter shelves.
list of server types and data sources that Tableau can D- It contains the names of all measures in your data,
connect to. collected into a single field with discrete
values.
What are two use cases for a story? Choose two. Answer:B, C, D
Options: Explanation:
A- Provide additional editing and interactive It contains all the measures in your data, collected into
capabilities to your audience. a single field with continuous values -This
B- Present a data narrative to lead your audience to is the definition for 'Measure Values'.
your conclusions. All others are True w.r.t. Measure Names!
C- Assemble a sequenced analysis to share with TheMeasure Namesfield contains the names of all
collaborators. measures in your data, collected into a single
D- To allow for easier exporting to Power Point. field with discrete values.
Answer:B, C
Explanation: Which set type is created when you select the Create
You can use a story to present a data narrative to lead Set option?
your audience to your conclusions, or to Options:
assemble a sequenced analysis to share with A- A fixed set
collaborators. A story is a sequence of visualizations B- A dynamic set
that work together to convey information.You can C- A Top N set
create stories to tell a data story, provide D- A combined set
context, demonstrate how decisions relate to outcomes, Answer:B
or to simply make a compelling case Explanation:
When you use the 'Create Set' option in Tableau, it
You have the following visualization. creates a dynamic set if the conditions for
Which set type is created when you select the Create inclusion in the set are based on a calculation or an
Set option? aggregation that may change as the data is
Options: updated or as filters are applied. Fixed sets are static
A- A fixed set and do not change with data refreshes,
B- A dynamic set while dynamic sets can update to reflect the current
C- A Top N set state of the data.
D- A combined set
Answer:B
Explanation:
How can you create a packaged data source? A- The mid-point in the range of displayed dates.
Options: B- The date in a relative-date filter to which you
A- From the Worksheet menu, select Export, and then anchor a unit of time.
select Data. C- The date in a range-of-dates filter to which you
B- From the Data pane, right-click the data connection, anchor units of time.
and then select Add to Saved Data D- The latest date in the data source that can be found.
Sources. Answer:B
C- From the File menu, select Share. Explanation:
D- From the File menu, select Save As. When creating a date filter in Tableau, anchor refers to
Answer:B the date in a relative-date filter to which
Explanation: you anchor a unit of time. A relative-date filter is a
To create a packaged data source (.tdsx file) in type of filter that allows you to dynamically
Tableau, you would right-click on the data filter data based on a range of time relative to the
connection in the Data pane and select the option to current date or a specific date.For example,
add it to saved data sources. This action you can use a relative-date filter to show data for the
packages the data source with the metadata that you've last 7 days, the next 3 months, or the
defined in Tableau, such as calculations, current quarter To create a relative-date filter, you need
groups, and sets, so that you can easily share it with to specify the following options: The
others. This does not package the data date field that you want to filter. The unit of time that
itself, which is a separate step if you're working with you want to use for the filter, such as days,
local file-based data. weeks, months, quarters, or years. The range of time
that you want to show relative to the
At a minimum, what do you need to create a simple anchor date, such as last, next, this, or to date. The
scatter plot? anchor date that you want to use as the
Options: reference point for the filter.You can use the current
A- A measure on Columns and a measure on Rows date or a custom date as the anchor
B- A dimension on Detail and a measure on Columns date1For example, if you want to create a relative-date
C- A dimension on Columns and a measure on Rows filter that shows data for the last 3
D- A dimension on Columns and a dimension on Rows months from January 1st, 2022, you would select the
Answer:A following options: Date field: Order Date
Explanation: Unit of time: Months Range of time: Last 3 Anchor
To create a simple scatter plot in Tableau, you need to date: Custom (01/01/2022)1The other options
have a measure on Columns and a are not valid definitions of anchor when creating a date
measure on Rows. A scatter plot is a type of filter in Tableau. The mid-point in the
visualization that shows the relationship between range of displayed dates is not related to the anchor
two numerical variables. In Tableau, you can create a date, but rather to the center of the axis
scatter plot by placing at least one that represents the date field. The date in a range-of-
measure on the Columns shelf and at least one measure dates filter to which you anchor units of
on the Rows shelf. The measures can be time is not correct, because a range-of-dates filter does
continuous or discrete, but they must be not use an anchor date, but rather a start
aggregated.The marks in the scatter plot represent the and end date that can be fixed or dynamic.The latest
intersection of the values for each measure1The other date in the data source that can be found is
options are not valid ways to create a not related to the anchor date, but rather to the
simple scatter plot in Tableau. A dimension on Detail maximum value of the date field in the data
and a measure on Columns will create a bar source2
chart, not a scatter plot. A dimension on Columns and a
measure on Rows will create a line chart Which of the following is a benefit of using a Tableau
or an area chart, depending on the mark type.A Data Source (.tds)?
dimension on Columns and a dimension on Rows Options:
will create a text table or a heat map, depending on the A- To hold one or more worksheets, plus zero or more
mark type dashboards and stories.
B- To not contain the actual data but rather the
information necessary to connect to the actual
When creating a date filter in Tableau, to what does data as well as any modifications you've made on top
Anchor refer? of the actual data such as changing default
Options: properties, creating calculated fields etc
C- To create a single zip file that contains a workbook if you drop a discrete field (a blue field), such as
along with any supporting local file data Category, on Color, the marks in the view are
and background images. This is great for sharing your broken out by category, and each category is assigned
work with others who don't have access to a color.
the original data. If you drop a continuous field, such as SUM(sales), on
D- To create a local copy of a subset or entire data set Color, each mark in the view is colored
that you can use to share data with based on its sales value.
others, when you need to work offline, and improve
performance. You need to display the complete list of potential data
Answer: connections when you connect to a server.
B What action should you perform?
Explanation: Options:
The following are the official definitions from the A- Select File on the menu, and then select New
Tableau documentation for the various file B- Select Connecting to Data.
types: C- Select More under To a Server
1) .tds (Tableau Data Source) - To not contain the D- Select More under To a File.
actual data but rather the information Answer:C
necessary to connect to the actual data as well as any Explanation:
modifications you've made on top of the To display the complete list of potential data
actual data such as changing default properties, connections when connecting to a server in Tableau,
creating calculated fields etc. (CORRECT you should select 'More' under the 'To a Server' option.
ANSWER) This action will provide a comprehensive
2) .twbx ( Tableau packaged workbook) - To create a list of server types and data sources that Tableau can
single zip file that contains a workbook connect to.
along with any supporting local file data and
background images. This is great for sharing your What are two requirements to combine two tables by
work with others who don't have access to the original using a union? Choose two.
data. Options:
3) Extract (.hyper or .tde) -- To create a local copy of a A- Related fields must have matching data types.
subset or entire data set that you can use B- Related fields must have different names.
to share data with others, when you need to work C- The tables must come from different connections.
offline, and improve performance. D- The tables must have the same number of fields.
3) (.twb) Workbooks -- To hold one or more Answer:A, D
worksheets, plus zero or more dashboards and Explanation:
stories. To perform a union in Tableau, the tables must have a
related field with matching data types,
How can you add color to marks in the view in and they must have the same number of fields. This
Tableau? allows the tables to be appended vertically
Options: in the data source. Different names or tables from
A- Click on Data in the main menu above, and click on different connections do not affect the ability
choose color. to union the tables.
B- From the Data pane, drag a field to Color on the
Marks card. Which one of the following is a dimension?
C- In the column/row shelf, right click the field and Options:
click on edit in shelf to select the color. A- Longitude
D- From the Analytics pane, drag a model to Color on B- Measure Names
the Marks card. C- Number of records
Answer:B D- Latitude
Explanation: Answer:B
To assign a color to marks in the view, do the Explanation:
following: Measure Names is a dimension. Latitude, Longitude,
From the Data pane, drag a field to Color on the Marks and Number of records are all measures.
card.
Tableau applies different colors to marks based on the
field's values and members. For example,
To display data that has both negative and positive
quantitative values, Tableau Desktop will
display marks by using__________________as the
default.
Options:
A- the full color range
B- a diverging palette
C- a sequential palette
D- a categorical palette
Answer:B
Explanation:
Tableau Desktop will display marks by using a
diverging palette as the default to display data
that has both negative and positive quantitative values.
A diverging palette is a type of color
palette that uses two different color ranges to show
positive and negative values. For example, a
red-green diverging palette uses shades of red for
negative values and shades of green for
positive values.A diverging palette is automatically
applied when there are both negative and
positive values for a measure that is placed on Color
on the Marks card5The other options are not
correct types of color palettes that Tableau Desktop
uses as the default for data with both
negative and positive values. A full color range is not a
valid term for a color palette in Tableau. A
sequential palette is a type of color palette that uses
different shades of one color to show
variations in a single measure.A sequential palette is
usually applied when there are only positive
values for a measure that is placed on Color on the
Marks card5A categorical palette is a type of
color palette that uses different colors to show discrete
values or categories.A categorical palette
is usually applied when there is a dimension that is
placed on Color on the Marks card