Tableau Desktop Certification Practice Test 14

Airlines reprice seats constantly, then have to explain whether the bet worked. Free Tableau Desktop Certification Practice Test 14 supports Tableau Desktop certification prep for revenue, operations, and network roles. Load factor, irregular operations, and ancillary sales become manageable when Tableau puts them in front of the people who can still change the day.

Delta Air Lines, United Airlines, and Southwest Airlines hire BI and Tableau-skilled analysts for commercial and operations reporting. The certification benefit is a clean skills signal in a field where titles vary wildly. One person’s analyst is another person’s developer. The credential tells both sides you can work in Desktop. Job offers still require you to connect a visual to a flight, a bank of seats, or a cost that moved.

Junior Tableau developers commonly see $75,000–$105,000. Mid-level Tableau developers commonly see $105,000–$145,000. Senior Tableau developers commonly see $130,000–$175,000. Hub cities may add a premium over averages near $112,000 and $135,000.

Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs, including the Java DevOps Full Stack JOPP and the Data Science JOPP.

To get hired as a data analyst, data scientist, data engineer, AI or ML engineer, or a software engineer, contact Synergisticit for expert upskilling, interview preparation, and marketing connections to companies. Start with the Synergisticit JOPP.

The SynergisticIT Data Science Job Placement Program bridges this gap. Learn more through the SynergisticIT Job Placement Program.

Welcome to your Tableau Desktop Specialist - Test-14

Name

Phone

Q1. In Tableau, when creating bins from a continuous measure, which of the following is NOT a step in the process?

Select 1 option(s):

Right-click a measure in the Data pane and select Create > Bins

Specify a name for the new field in the Create Bins dialog box

Enter a value in the Size of bins field or have Tableau calculate a value for you

Use the new binned field to create an area chart

Q2. In Tableau, what does the whisker in a box plot represent?

Select 1 option(s):

The median of the data

The interquartile range (IQR)

The minimum and maximum data points within 1.5 * IQR

Outliers in the data

Q3. In Tableau, when converting Date fields between discrete and continuous, which of the following statements is true?

Select 1 option(s):

Discrete dates act as labels and continuous dates will have an axis similar to a measure

Date fields cannot be converted between discrete and continuous

The color of the field does not change when it is converted from discrete to continuous or vice versa

Both A and C

Q4. In Tableau, when creating a pie chart, which of the following statements is true?

Select 1 option(s):

Pie charts work well for comparing exact numbers

Pie charts should be used when your dimension has a very large number of categories

Pie charts should be used to show the relationship of different parts to the whole

Three-dimensional pie charts are recommended for better visual perception of slices

Q5. What is the primary purpose of an LOD (Level of Detail) expression in Tableau?

Select 1 option(s):

To create a new data source by combining data from two or more data sources

To perform real-time analysis on a data source

To define a custom level of aggregation for a measure

To filter data across multiple worksheets

Q6. In Tableau, when using the Pages shelf, which of the following statements is true?

Select 1 option(s):

The Pages shelf does not allow you to break a view into a series of pages

When you place a measure on the Pages shelf, Tableau does not convert the measure into a discrete measure

The Pages shelf creates a set of pages, with a different view on each page based on a member of the field you placed on the Pages shelf

When you add a field to the Pages shelf, a page control is not added to the right of your view

Q7. In Tableau, when sorting specific fields in a visualization, which of the following statements is true?

Select 1 option(s):

You cannot customize sorting by using the Sort menu for specific fields

The Sort menu is available for continuous measures

When sorting, Tableau uses the current International Components for Unicode (ICU) library to determine sort order.

Manual sorting does not allow you to select a value and move it to the desired position

Q8. In Tableau, when working with table calculations, which of the following statements is true?

Select 1 option(s):

Addressing fields define how to group the calculation

Partitioning fields determine the direction of the calculation

Table calculations are computed on the data source and not on the data in the view

Table calculations are computed on the data in the view and not on the data source

Q9. In Tableau, what happens when you perform a full refresh of a data extract?

Select 1 option(s):

It replaces all of the contents in the extract

It only adds rows that are new since the previous refresh

It removes all data from the extract

It updates only the rows that have changed since the last refresh

Q10. In Tableau, how many visualizations can you include within a single tooltip using the Viz in Tooltip feature?

Select 1 option(s):

More than 4

Q11. In Tableau, when creating a calculation using the DATEPARSE function, what is an important consideration?

Select 1 option(s):

The DATEPARSE function does not require a specific format to interpret the string as a date

The DATEPARSE function can only be used with a string data type.

The DATEPARSE function can be used with all connectors without any exceptions.

The DATEPARSE function does not need to include all spaces, hyphens, and other non-alphanumeric symbols in the format

Q12. In Tableau, when assigning colors to marks in the view, what happens if you drag a continuous field, such as SUM(sales), to Color on the Marks card?

Select 1 option(s):

Each mark in the view is colored based on its sales value

All marks in the view are updated to the color you choose

The marks in the view are broken out by category, and each category is assigned a color

The color of the marks does not change

Q13. In Tableau, when creating a parameter, which of the following options can you specify for how the parameter will accept values?

Select 1 option(s):

All, List, Range

All, List, Set

All, Range, Set

List, Range, Set

Q14. Which of the following statements is true about Aggregate Measures in Tableau?

Select 1 option(s):

Aggregate Measures are used to perform calculations on individual records in a dataset

Aggregate Measures are used to perform calculations on groups of records in a dataset

Aggregate Measures are only used for date/time calculations

Aggregate Measures cannot be used in calculations or visualizations

Q15. Which of the following is a way to create a calculated field in Tableau?

Select 1 option(s):

Right-click the dimension or measure in the data pane and choose “Create > Calculated Field“

In the Data pane, click the drop down menu and select “Create Calculated field“

Select “Analysis > Create Calculated Field“

All of the above

Q16. In Tableau, what is one of the benefits of using a context filter?

Select 1 option(s):

It allows you to filter data independently of other filters

It allows you to filter data based on the results of other filters

It allows you to filter data without any impact on performance

All other filters does not depend on the data passing through from the context filter

Q17. When blending two data sets together, what is one of the impacts of data blending on performance in Tableau?

Select 1 option(s):

It decreases the time to query and render when blending two data sets together

It increases the time to query and render due to an extra step in the queries

It has no impact on the time to query and render

It reduces the number of queries needed, thus improving performance

Q18. In Tableau, how can you drill up or down in a hierarchy in a visualization?

Select 1 option(s):

By clicking the + or - icon on the hierarchy field in the visualization

By right-clicking the hierarchy field and selecting ‘Drill Up‘ or ‘Drill Down‘

By double-clicking the hierarchy field in the visualization and the hierarchy menu will display

By dragging the hierarchy field to a new position in the visualization

Q19. In Tableau, when you create a relative date filter, what happens to the view when you open it?

Select 1 option(s):

The view remains static and shows the data as of the date when the filter was created

The view updates to show a time period relative to when you open the view

The view updates to show the most recent data, regardless of the time period specified in the filter

The view does not display any data until you manually update the filter

Q20. What is the purpose of the ATTR function in Tableau?

Select 1 option(s):

Returns a string composed of the specified number of repeated spaces

Returns if it is not null, otherwise returns zero

Returns the value of the given expression if it only has a single value for all rows, otherwise it displays an asterisk.

Returns the number of rows from the current row to the last row

Q21. How can you create a hierarchy in Tableau?

Select 1 option(s):

Drag a dimension onto another dimension in the Data pane

Right-click a dimension in the Data pane and choose ‘Hierarchy‘ > ‘Create Hierarchy‘

Choose “Create Hierarchy“ from the Analysis menu

Both A and B

Q22. Which of the following is NOT stored in a ‘.TDS‘ file?

Select 1 option(s):

Connection information

Calculated fields

Default properties

Actual data records

Q23. Which of the following is a way to share a Tableau workbook with others?

Select 1 option(s):

Save the workbook as a packaged workbook (.twbx) and share the file

Publish the workbook to Tableau Server

Export As PowerPoint

All of the above

Q24. In Tableau, when using the Highlighter feature, what happens when you enter a keyword?

Select 1 option(s):

The view filters to only show marks that match the keyword

The view dims all marks that match the keyword

The view immediately highlights the marks that match or partially match your keyword search

The view highlights the marks that match the keyword and removes all marks that do not match the keyword

Q25. In Tableau, which of the following is NOT a Background Maps option?

Select 1 option(s):

Outdoors

Satellite

Terrain

Streets

Q26. Which of the following chart type is best suited for displaying a time series?

Select 1 option(s):

Bar

Line

Circle

Square

Q27. In Tableau, when creating a story, how can you add a new story point?

Select 1 option(s):

By clicking ‘Blank‘ to use a fresh sheet for the next story point

By start customizing a story point and click ‘Save as New‘ on the toolbar

By clicking ‘Duplicate‘ to use the current story point as the basis for a new one

All of the Above

A and B only

Q28. In Tableau, what is the correct order of operations for applying filters?

Select 1 option(s):

Context filters, Data source filters, Extract filters, Filters on dimensions, Filters on measures

Extract filters, Data source filters, Context filters, Filters on dimensions, Filters on measures

Data source filters, Context filters, Extract filters, Filters on measures, Filters on dimensions

Extract filters, Context filters, Data source filters, Filters on dimensions, Filters on measures

Q29. In Tableau, what is included in a packaged workbook (.twbx)?

Select 1 option(s):

Background images

Custom geocoding

Local cube files

All of the above

None of the above

Q30. In Tableau, when using the “View Underlying Data“ option, what is the maximum number of rows that can be viewed on Tableau Server?

Select 1 option(s):

100 rows

200 rows

500 rows

1000 rows

Q31. In Tableau, what is one of the reasons you might create a context filter?

Select 1 option(s):

To force a filter to be carried out last

To create a dependent numerical or top N filter

To exclude data of interest from a filter

To make all other filters independent of the context filter

Q32. What is the best use case for a stacked bar chart?

Select 1 option(s):

Useful for analyzing two measures with different scales

Showing the distribution of a single measure

Comparing the proportions of different categories

Showing trends over time

Q33. In Tableau, when there are multiple dimensions in the view, what type of sort can be created?

Select 1 option(s):

Nested Sort

Alphabetical Sort

Numerical Sort

Comparative sort

Q34. In Tableau, when filtering categorical data (dimensions), which tab in the Filter dialog box allows you to define a pattern to filter on?

Select 1 option(s):

General

Wildcard

Condition

Top

Q35. In Tableau, which of the following statements about using the Top tab in the Filter dialog box is INCORRECT?

Select 1 option(s):

The Top filter allows you to include a specified number of data points in the view, such as the top 15 products

The Top filter can only be used to display the highest values; it can‘t show the lowest values

The Top filter eliminates the need to set specific range criteria by enabling a relative comparison within the field

The Top filter can be used to display views such as the top 10 Cities by average Sales

Q36. Which of the following is NOT an Aggregate function in Tableau?

Select 1 option(s):

COUNT

MODE

MEDIAN

STDEV

Q37. In Tableau, what is the default color for most marks when there are no fields on Color on the Marks card?

Select 1 option(s):

Red

Green

Blue

Yellow

Q38. In Tableau, when creating a table calculation, which of the following options is NOT available in the “Compute Using“ selection?

Select 1 option(s):

Table (across)

Pane (down)

Cell

Column (down)

Specific Dimensions

Q39. What is not an available option for exporting when we select ‘Worksheet > Export‘ ?

Select 1 option(s):

Image

Data

Crosstab to Excel

MS PowerPoint

Q40. In Tableau, which of the following options allows you to create bins for a continuous measure?

Select 1 option(s):

Right-click the measure field on the Data pane and choose “Create > Bins“

Select the measure field from the Data pane, and then go to “Analysis“ menu and select “Create Bins“

From the Data pane, drag the measure field to “Shape“ on the Marks card.

Select the measure in the view, and use the Histogram option in the Show Me panel to create bins

Q41. In Tableau, when configuring a Viz in Tooltip, what is the ‘default‘ filter setting?

Select 1 option(s):

Filtered on Selected Fields

Filtered on All Fields

No filter applied

Filter option is not available

Q42. What is the purpose of a dashboard in Tableau?

Select 1 option(s):

To connect to data sources and prepare data for analysis

To create and save individual visualizations

To display multiple visualizations in a single view

To create calculated fields and hierarchies

Q43. What is the purpose of using an LOD (Level of Detail) expression in Tableau?

Select 1 option(s):

To define a custom level of aggregation for a measure

To blend data from multiple data sources

To create a hierarchical drill-down in a visualization

To apply a filter across multiple worksheets

Q44. Which of the following is a technique used to optimize Tableau workbooks for improved performance?

Select 1 option(s):

Using context filters

Reducing the number of calculated fields

Extracting data instead of using live connections

All of the above

Q45. What is the result of blending data from two different data sources in Tableau?

Select 1 option(s):

A new data source is created with the combined data

The data from the secondary data source is added to the primary data source as additional columns

The data from the secondary data source is displayed in the view based on a common field in the primary data source

The data from both data sources is combined into a single flat file

Q46. How do we convert a measure to a dimension in the Data pane?

Select 1 option(s):

Click and drag the measure field from a measures area in the Data pane and drop it into a dimensions area

Right-click the measure field in the Data pane and select ‘Convert to Dimension‘

Select the measure field in the Data pane and then go to the ‘Analysis‘ menu and select ‘Convert to Dimension‘

A and B

B and C

Q47. In Tableau, what can you do to view all individual rows of your data source and analyze the distribution of individual transactions, rather than summarized data?

Select 1 option(s):

Aggregate all measures in the view from the Analysis menu

Apply a filter on the view to show only certain transactions

Navigate to the Analysis menu and select ‘Reveal Data‘ option

Navigate to the Analysis menu and deselect the ‘Aggregate Measures‘ option

Q48. In Tableau, when using a parameter in a reference line, how can you dynamically modify the position of the reference line?

Select 1 option(s):

By manually editing the reference line in the view

By adjusting the parameter value in the parameter control

By changing the data type of the parameter.

By modifying the underlying data source

Q49. What is the purpose of using map layers in Tableau?

Select 1 option(s):

To create a 3D effect on the map

To layer multiple sources of spatial data on maps for a more detailed view

To add a decorative background to the map

To hide certain parts of the map

Q50. In Tableau, what is the purpose of the Pages shelf?

Select 1 option(s):

To create a series of views that display different subsets of the data, based on a selected dimension or measure

To create a multi-page PDF or printed report

To organize multiple worksheets or dashboards in a workbook

To create a slideshow or animation that shows how data changes over time

Q51. In Tableau, what does the ZN function do when applied to a numeric field or measure?

Select 1 option(s):

It converts all numeric values to zero

It replaces all null values with zero

It converts all zero values to null

It replaces all null values with the average of the non-null values

Q52. What is the purpose of a tooltip in Tableau?

Select 1 option(s):

To display additional information about a data point when the user hovers over it

To show the relationship between two measures in a visualization

To provide context for the visualization using labels or annotations

To customize the appearance of a visualization

Q53. In Tableau, what happens when you join tables and the fields you join on are not of the same data type?

Select 1 option(s):

The join will still work, but the data might be inconsistent

The join will break and you will need to make the data types the same

Tableau will automatically convert the data types to match

The join will work, but you will not be able to remove fields used in the join clause

Q54. What is the primary purpose of the LOOKUP function in Tableau?

Select 1 option(s):

To return the value of the expression at a specific position in a partition

To calculate the average of a set of numbers

To return the absolute value of a number

To return the character encoded by the ASCII code number

Q55. Which of the following aggregation functions returns the number of items in a group of non-null values in a given field?

Select 1 option(s):

COUNT

COUNTD

SUM

AVG

Q56. What happens to members that are removed from an existing group in Tableau?

Select 1 option(s):

They are deleted from the dataset

They are added to the ‘Other‘ group, if it exists

They are automatically added to a new group

They are hidden from the view

Q57. How can you display interactive filters in a Tableau view?

Select 1 option(s):

By selecting ‘Show Filter‘ from the field drop-down menu in the view

By dragging the field to the Filters shelf

By selecting ‘Interactive Filter‘ from the field drop-down menu in the view

By right-clicking on the field in the view and selecting ‘Interactive Filter‘

Q58. What type of chart is best suited for comparing individual data points across categories?

Select 1 option(s):

Bar chart

Line chart

Pie chart

Scatter plot

Q59. In Tableau, how can multiple views be used to filter other views in a dashboard?

Select 1 option(s):

By selecting each view and choosing ‘Use as Filter‘ from the shortcut menu

By selecting each view and choosing ‘Ignore Actions‘ from the shortcut menu

By selecting each view and choosing ‘Use as Filter‘ and ‘Ignore Actions‘ from the shortcut menu

None of the above

Q60. What is the purpose of a hierarchy in Tableau?

Select 1 option(s):

To filter data based on multiple levels

To organize dimensions into a logical order for drill-down analysis

To create calculated fields for complex calculations

To group dimensions and measures together

Q61. In Tableau, what happens when a floating object is hidden in a dashboard?

Select 1 option(s):

It reveals any objects beneath it

It leaves a blank space behind

It moves to the bottom of the dashboard

It deletes itself from the dashboard

Q62. In Tableau, which of the following options is available when formatting text alignment?

Select 1 option(s):

Horizontal

Vertical Alignment

Direction

Wrap

All of the above

A and B

Q63. What does the presence of all table colors next to a field in the union profile indicate in Tableau?

Select 1 option(s):

The field is irrelevant to the union operation

The field has mismatched data

The union operation was performed correctly for that field

The field was excluded from the union operation

Q64. In Tableau, what does the delta symbol indicate when applying a quick table calculation to a field in a visualization?

Select 1 option(s):

It indicates that the field is being used as a filter

It indicates that the field is being used in a calculated field

It indicates that a quick table calculation is being applied to the field

It indicates that the field is being used in a parameter

Q65. Which type of join in Tableau combines all rows from both tables, filling in NULL values for non-matching rows?

Select 1 option(s):

Inner join

Left join

Right join

Full outer join

[/ppwp]