Free Tableau Desktop Certification Practice Test 11

Energy companies review generation, outage, and commodity exposure before most offices open. Free Tableau Desktop Certification Practice Test 11 is for candidates who want the Tableau Desktop certification to support that kind of operating rhythm. Tableau gives traders, plant leaders, and regulators’ audiences a shared picture of volume, availability, and cost.

Chevron, ExxonMobil, and NextEra Energy hire visualization and BI professionals across finance, trading support, and asset performance. Certification benefits are resume clarity and interview confidence. You can claim Desktop skill and point to a credential instead of a vague “familiar with.” Offers still ask for judgment. A chart of an outage is useless if you cannot say which number a supervisor should act on.

Junior Tableau developers typically see $75,000–$105,000. Mid-level Tableau developers typically see $105,000–$145,000. Senior Tableau developers typically see $130,000–$175,000, with Houston and other energy hubs able to pay toward the top when the role sits beside trading or reliability. Use $112,000 and $135,000 as the published national averages.

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

If you want to learn how 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. The program overview is the Synergisticit JOPP.

The SynergisticIT Data Science Job Placement Program ensures your growth translates into career success. Explore more through the SynergisticIT Job Placement Program

Welcome to your Tableau Desktop Specialist - Test-11

Name

Phone

Q1. Which level of detail raises the context to a higher level of detail?

Select 1 option(s):

EXCLUDE LOD

FIXED LOD

VIZ LOD

INCLUDE LOD

Q2. How does Tableau present a nested calculation in the pill added to the new shelves?

Select 1 option(s):

AGG()

MAX()

SUM()

AVG()

Q3. Which of the following pieces of metadata are stored in a .tds file?

Select 3 option(s):

Default Properties

Workbook Name

Folder Groupings

Renamed Fields

Q4. Which data sources can Tableau connect to? (Select all that apply.)

Select 4 option(s):

Database server

Excel files (.xls, .xlsx, etc.)

Comma delimited values (.csv)

Hadoop cluster

Unattempted

Q5. How can users instantly refresh an extract in Tableau desktop?

Select 3 option(s):

Select a Data Source on Data Menu -> Extract

Select a Data Source on Data Menu -> Extract -> Refresh

Sign in to Tableau Server -> Click Tasks at the top of the page -> Under Extract Refreshes select the workbook or data source -> On the Actions menu click Run now.

Select a Data Source on Data Menu -> Extension -> Refresh

Q6. Choose the correct path to add a default comment for a field

Select 1 option(s):

Right click a field in the Data pane-> Default Properties-> Comment

Right click a field in the Data pane-> Describe-> Comment

Right click a field in the Data pane-> Aggregation -> Default Properties-> Comment

Right click a field in the Data pane -> Comment

Q7. Choose the correct steps to edit the data source

Select 1 option(s):

Data Menu -> Select a Data source -> Edit Data Source

Data Menu -> Select a Data source -> View Data

Data Menu -> Select a Data source -> Edit Data Source Filters

Data Menu -> Select a Data source -> Extract Data

Q8. Which of the following options leads to adjusting the granularity of data in Tableau?

Select 1 option(s):

Group by

Extract

Grouped Fields

Aggregate

Q9. The following Join type must be defined in a Relationship:

Select 1 option(s):

Left Join

Inner Join

Right Join

It is not required to define a join type in a relationship

Q10. What steps should be taken to establish a geographical hierarchy?

Select 1 option(s):

In the Analytics pane right-click the create Hierarchy -> Select Hierarchy -> Ok

In the Analytics pane right-click the geographic field -> Create Hierarchy

In the Data pane right-click the geographic field-> Transform -> select Hierarchy -> Create Hierarchy

In the Data pane right-click the geographic field-> Hierarchy -> Create Hierarchy

Q11. What is the distinction between a dual-axis chart and a combined axis chart?

Select 1 option(s):

Dual axis and combined axis are different terms but have the same meaning

Dual axis chart creates two independent axes while a combined axis chart merges two or more measures into a single axis.

Combined axis chart creates two independent axes while a dual axis chart merges two or more measures into a single axis.

Dual axis chart becomes a combined axis chart once two or more measures are combined into a single axis.

Q12. Which of the following are the types of sets in Tableau?

Select 2 option(s):

Dynamic set

Equal set

Fixed set

Singleton set

Q13. Filter dialog box offers the following tabs for filtering:

Select 3 option(s):

Wildcard

Report

Condition

Top

Q14. Tableau supports which of the following quick table calculations?

Select 3 option(s):

Percent of total

Percentile

Z-score

Rank

Q15. In Tableau, how do you change the color of a chart from the Marks card? [Choose all that apply]

Select 2 option(s):

For an existing chart select the All in Marks card -> From the Select Color Palette select any of the desired option -> From the select Data item choose desired color for each of the measure -> Apply -> Ok

For an existing chart select the All in Marks card -> Select Color -> Edit Colors -> From the Select Color Palette select any of the desired option -> From the select Data item choose desired color for each of the measure -> Apply -> Ok

For an existing chart select the All in Marks card -> Select Color -> Choose the desired color -> Apply -> Ok

For an existing chart select the All in Marks card -> Select Color -> Edit Colors -> From the Select Color Palette select any of the desired option -> Apply -> Ok

Q16. How can we create a story in Tableau?

Select 1 option(s):

Go to File -> Click on New Story -> Select Ok

Go to Analysis -> Click on New Story -> Select Ok

Go to Data -> Click on New Story -> Select Ok

Click the New Story tab -> In the lower-left corner of the screen, choose a size for the story -> Double click on any sheet or dashboard to put inside the story -> By default the story name gets its title from the -> Click Add a caption to summarize the story point.

Q17. In Tableau, how do you create a viz in a tooltip?

Select 1 option(s):

Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the target worksheet, click Tooltip in the Marks card -> Select insert and select the target worksheet

Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Marks card -> Select insert and select the target worksheet

Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Worksheets tab -> Select insert and select the target worksheet

Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Analytics tab -> Select insert and select the target worksheet

Q18. In Tableau, how do we change the size of the marks?

Select 1 option(s):

After creating any chart go to Format -> Select the Marks card -> Choose the size of the chart

After creating any chart go to Analysis -> Select the Marks card -> Choose the size of the chart

After creating any chart go to Marks card -> Select the size -> Move the slider to the right or left to increase or decrease the size of the chart

After creating any chart go to Story -> Select the Marks card -> Choose the size of the chart

Q19. How do we enable the Animation option in Tableau?

Select 1 option(s):

Go to Format -> Choose Animations -> Select On from Animations Tab

Go to Analysis -> Choose Animations -> Select On from Animations Tab

Go to Worksheet -> Choose Animations -> Select On from Animations Tab

Go to Dashboard -> Choose Animations -> Select On from Animations Tab

Q20. How do we disaggregate data in Tableau?

Select 1 option(s):

For any visualization Go to Data -> Uncheck the Aggregate Measures

For any visualization Go to File -> Uncheck the Aggregate Measures

For any visualization Go to Analysis -> Uncheck the Aggregate Measures

For any visualization Go to Worksheet -> Uncheck the Aggregate Measures

Q21. What are the advantages to using relationships to combine tables?

Select 2 option(s):

Make it easier to analyze data across multiple tables at different levels of granularity.

Makes it easier to change the key fields used to combine the tables.

Tables are only queried when fields from the tables are added to the viz.

Makes it easier to combine rows from one table with rows from another

Q22. Aliases cannot be created for the following (Choose as many as appropriate)

Select 3 option(s):

Continuous dimension

Discrete dimension

Dates

Measures

Q23. Tableau adds the following fields to the Measures area of the Data pane when a field is assigned a geographic role:

Select 1 option(s):

Meridian and Longitude

Latitude and Longitude

Meridian and Latitude

Only Meridian

Q24. How many data sources can you blend in Tableau?

Select 1 option(s):

Two or more

Three or more

Four or more

Five or more

Q25. How do you make a stacked bar chart with a separate bar for each measure? [Choose All That Apply]

Select 1 option(s):

Drag a dimension to Color -> Drag Measure Names to Rows and also drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok c) Drag a dimension to Color -> Drag

Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok

Drag a Measure Values to Color -> Drag Measure Names to Columns and drag Dimension to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok

Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> Ok

Q26. How do you create a Highlight Table or Heat Map in Tableau?

How do you create a Highlight Table or Heat Map in Tableau?

Select 1 option(s):

Drag one or more dimensions on the Columns shelf -> Select Square as the mark type -> place a measure of interest on the Colour shelf.

Drag one or more dimensions on the Columns shelf and one or more dimensions on the Rows shelf -> place a measure of interest on the Colour shelf -> Select Square as the mark type

Drag one dimension on the Columns shelf and one measure on the Rows shelf -> place a measure of interest on the Colour shelf.

Drag one or more dimensions on the Rows shelf-> Select Square as the mark type -> place a measure of interest on the Colour shelf.

Q27. How do you create a Hierarchy in Tableau?

Select 1 option(s):

Right click on a field -> Create Hierarchy -> Choose the fields -> ok

Right click on a field -> Choose the fields -> Create Hierarchy -> ok

In Data pane drag a field and drop on top of another field -> enter a name of the hierarchy -> ok

Right click on a field -> Create Hierarchy -> ok

Q28. How do you create Relative Date Filters?

Select 1 option(s):

Drag a date field to the filter shelf -> Select a time unit -> Ok

Drag a date field to the filter shelf -> Ok

Drag a date field to the filter shelf -> Define the date period -> Ok

Drag a date field to the filter shelf -> Select a time unit -> Define the date period -> Ok

Q29. What are the primary types of calculations you can use to create calculated fields in Tableau?

Select 3 option(s):

Basic calculations

Statistic Calculations

Level of Detail (LOD) expressions

Table calculations

Q30. Which of the following statement about dimensions and measures in Tableau is incorrect?

Select 1 option(s):

The values of a dimension can be continuous or discrete.

The values of a dimension are always non-numeric.

The values of a measure are always numeric.

The values of a measure can be continuous or discrete.

Q31. What does the box in a box plot represent?

Select 1 option(s):

Maximum value

Minimum value

Median of the middle half of the points

Interquartile range

Upper quartile

Q32. _____________ is a snapshot of the data that Tableau stores locally. It‘s ideal for large datasets with only a few fields.

Select 1 option(s):

Tableau Packaged Workbook (.twbx)

Tableau Workbook (.twb)

Tableau Data Extract (.tde)

Tableau Data Source (.tds)

Q33. The default path for all supporting files, data sources, icons, logs, etc is the following:

Select 1 option(s):

Documents -> Tableau Files

Documents -> Tableau

Documents -> My Tableau Repository

Downloads -> Tableau Support Files

Q34. In Tableau, what data type does this icon represent?

Select 1 option(s):

Date & Time values

Cluster Group

Boolean values

Geographic values

Q35. In Tableau, __________ is a technique that will identify marks with similar characteristics

Select 1 option(s):

Grouping

Clustering

Sets

Union

Q36. Which of the following two columns CANNOT be deleted in Tableau?

Select 2 option(s):

Number of Records

Measure Names

Measure Values

Calculated Fields

Q37. What are the differences between live and extract connections? (Select All that Apply)

Select 2 option(s):

Live allows real-time data while extracts are kind of batch which needs to be refreshed from time
to time to get the updated data.

Live Connection does not slow down operational queries which results in fetching data quickly.

Live Connection takes more time to load data than Extract Connection.

Both the connection takes same time to work with and they do not have any functional
difference.

Q38. What is the default format (extension) that Tableau saves the files as?

Select 2 option(s):

.doc

.tdsx

.tds

.pbix

Q39. What steps will create a dual axis chart? [Select All that Apply]

Select 2 option(s):

Drag one dimension to Column and drag two measures to Row -> In the Rows right click any of the measure -> Select Dual axes -> Go to marks type of any of the measure and choose the chart type as Bar.

Drag two dimensions to Column and drag one measures to Row -> Go to marks type of any of the
measure and choose the chart type as Bar.

Drag one dimension to Column and drag one measures to Row -> drag another measure to the
“chart itself and as the rectangle shape appears drop it -> Go to marks type of any of the measure and
choose the chart type as Bar.

“

Drag one dimension to Column and drag one measure to Row -> Go to marks type of any of the
measure and choose the chart type as Bar.

Q40. Which of the following can prevent a refresh for a refreshable list of parameter values? [select all that apply].

Select 3 option(s):

The default field returns null.

The default field does not return a single value.

The default field is in a data source thats not yet connected.

The user cancels the query to the data source while Tableau is attempting to connect.

Q41. Which of the following applies to the Density map in Tableau? (Select all that apply.)

Select 3 option(s):

To create a density map, the data source should contain Latitude and Longitude coordinates or location names.

Tableau cannot recognize location names and create a density map using the point locations assigned to Tableau geocoding locations.

Density maps are most effective when the location data is very precise, such as location coordinates in a limited space.

Density marks work best where the specific locations change continuously and smoothly across space, rather than values constrained to discrete locations like boroughs or neighborhoods.

Q42. How to create a group from a field in the Data pane?

Select 2 option(s):

In the Data pane, right-click a field -> select Create -> In the Create Group dialog box select the members that need to be grouped -> Group -> Ok.

In the Data pane, right-click a field -> select Group.

In the Data pane right-click a field -> Group.

In the Analytics pane right-click a field -> select Group -> Ok.

Q43. Which of the following are applicable for nested sort in Tableau? (Select all that apply.)

Select 3 option(s):

Nested sort considers each pane independently and sorts the rows per pane.

Nested sorts look correct within the context of the pane, but dont convey the aggregated information about how the values compare overall.

Sorting from an axis does not give a nested sort by default.

While creating a nested sort, the sort is inherited when we drill down through the dimensions.

Q44. How do you create a Binned Dimension in Tableau?

Select 1 option(s):

In the Data pane, right-click a measure -> select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok.

In the Data pane, right-click a measure -> Create Bins dialog box accept the proposed new field name or specify a different name for the new field -> Mention the size of bins -> Ok.

In the Data pane, right-click a measure -> select Create bins > Ok.

Select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok.

Q45. How to show subtotals in visualization in Tableau?

Select 1 option(s):

Click the Analytics pane -> In the Analytics pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals.

Click the Analytics pane -> Click the Subtotals

Click the Data pane -> In the Data pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals

Click the Data pane -> Click the Subtotals

Q46. Choose which of the following are true for using fonts in Tableau for visualization? [Select all that Apply]

Select 2 option(s):

If the workbook is created in Tableau Desktop then we can use any font installed on the computer in the workbook.

If the workbook is created using Web Authoring we can use any font installed on the computer in the workbook.

If the workbook is published to Tableau Server any custom font must be installed on all server nodes. If the font is not installed on Tableau Server, the uninstall font will be replaced with a substitute font upon publishing.

If the workbook is published to Tableau Online we can use any font installed on the computer in the workbook.

Q47. How can we export a view as an image file in Tableau?

Select 1 option(s):

Select Data > Export> Image -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save.

Select Worksheet > Export> Image -> In the Export Image dialog box, select the elements we want to include in the image. If the view contains a legend, under Image Options, select the legend layout -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save.

Select Format > Export> Image -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save.

Select Worksheet -> Click Save as -> In the Save Image dialog box, specify a file location, name, and format. Then click Save.

Q48. Which of the following are true for URL actions in Tableau? [Select all that apply]

Select 3 option(s):

A URL action is a hyperlink that points to a web page, file, or other web-based resources outside of Tableau.

We can use URL actions to create an email.

We can use URL actions to link to additional information about the data.

To customize links based on our data, we cannot automatically enter field values as parameters in URLs.

Q49. In Tableau, a discrete field is shown in which color?

Select 1 option(s):

Red

Blue

Green

Yellow

Q50. What are the differences between a discrete date and continuous date values? [Select all that Apply]

Select 3 option(s):

Discrete date part color is Blue whereas the Continuous date part color is Green.

Discrete date creates labels whereas the Continuous date creates axes.

Discrete date aggregates data at the selected unit whereas the Continuous date uses individual date values.

Continuous date part color is Blue whereas the Discrete date part color is Green.

Q51. How can we change the aggregation of a measure in Tableau?

Select 1 option(s):

For any visualization right click on the measure -> Go to Aggregate -> Select any of the desired aggregates for that measure.

For any visualization right click on the measure -> Go to Analysis -> Select any of the desired aggregate for that measure.

For any visualization right click on the measure -> Go to Measure -> Select any of the desired aggregate for that measure.

For any visualization right click on the measure -> Go to Format -> Select any of the desired aggregate for that measure.

Q52. Trend lines can only be used with numeric or date fields.

Select 1 option(s):

TRUE

FALSE

Q53. Which of the following is a good reason for using a bullet graph?

Select 1 option(s):

Comparing the actual sales against the target sales

Analyzing the trend over a given time period

Forecasting future sales

Displaying the year-on-year growth in sales

Q54. To connect Tableau to a CSV data source what type of connection should you use?

Select 1 option(s):

Spatial

Excel

Text

JSON

Q55. Which of the following is NOT a type of Quick Filter available in Tableau?

Select 1 option(s):

Wildcard Match

Multiple Values (dropdown)

Regex Match

Single Value (slider)

Q56. Which of the following occur earlier in the order of operations than context filters?

Select 1 option(s):

Sets

Data blending

Dimension filters

Data source filters

[/ppwp]

Free Tableau Desktop Certification Practice Test 11

Q1. Which level of detail raises the context to a higher level of detail?

Q2. How does Tableau present a nested calculation in the pill added to the new shelves?

Q3. Which of the following pieces of metadata are stored in a .tds file?

Q4. Which data sources can Tableau connect to? (Select all that apply.)

Q5. How can users instantly refresh an extract in Tableau desktop?

Q6. Choose the correct path to add a default comment for a field

Q7. Choose the correct steps to edit the data source

Q8. Which of the following options leads to adjusting the granularity of data in Tableau?

Q9. The following Join type must be defined in a Relationship:

Q10. What steps should be taken to establish a geographical hierarchy?

Q11. What is the distinction between a dual-axis chart and a combined axis chart?

Q12. Which of the following are the types of sets in Tableau?

Q13. Filter dialog box offers the following tabs for filtering:

Q14. Tableau supports which of the following quick table calculations?

Q15. In Tableau, how do you change the color of a chart from the Marks card?  [Choose all that apply]

Q16. How can we create a story in Tableau?

Q17. In Tableau, how do you create a viz in a tooltip?

Q18. In Tableau, how do we change the size of the marks?

Q19. How do we enable the Animation option in Tableau?

Q20. How do we disaggregate data in Tableau?

Q21. What are the advantages to using relationships to combine tables?

Q22. Aliases cannot be created for the following  (Choose as many as appropriate)

Q23. Tableau adds the following fields to the Measures area of the Data pane when a field is assigned a geographic role:

Q24. How many data sources can you blend in Tableau?

Q25. How do you make a stacked bar chart with a separate bar for each measure?  [Choose All That Apply]

Q26. How do you create a Highlight Table or Heat Map in Tableau?

Q27. How do you create a Hierarchy in Tableau?

Q28. How do you create Relative Date Filters?

Q29. What are the primary types of calculations you can use to create calculated fields in Tableau?

Q30. Which of the following statement about dimensions and measures in Tableau is incorrect?

Q31. What does the box in a box plot represent?

Q32. _____________ is a snapshot of the data that Tableau stores locally. It‘s ideal for large datasets with only a few fields.

Q33. The default path for all supporting files, data sources, icons, logs, etc is the following:

Q34. In Tableau, what data type does this icon represent?

Q35. In Tableau, __________ is a technique that will identify marks with similar characteristics

Q36. Which of the following two columns CANNOT be deleted in Tableau?

Q37. What are the differences between live and extract connections? (Select All that Apply)

Q38. What is the default format (extension) that Tableau saves the files as?

Q39. What steps will create a dual axis chart? [Select All that Apply]

Q40. Which of the following can prevent a refresh for a refreshable list of parameter values? [select all that apply].

Q41. Which of the following applies to the Density map in Tableau? (Select all that apply.)

Q42. How to create a group from a field in the Data pane?

Q43. Which of the following are applicable for nested sort in Tableau? (Select all that apply.)

Q44. How do you create a Binned Dimension in Tableau?

Q45. How to show subtotals in visualization in Tableau?

Q46. Choose which of the following are true for using fonts in Tableau for visualization?  [Select all that Apply]

Q47. How can we export a view as an image file in Tableau?

Q48. Which of the following are true for URL actions in Tableau? [Select all that apply]

Q49. In Tableau, a discrete field is shown in which color?

Q50. What are the differences between a discrete date and continuous date values? [Select all that Apply]

Q51. How can we change the aggregation of a measure in Tableau?

Q52. Trend lines can only be used with numeric or date fields.

Q53. Which of the following is a good reason for using a bullet graph?

Q54. To connect Tableau to a CSV data source what type of connection should you use?

Q55. Which of the following is NOT a type of Quick Filter available in Tableau?

Q56. Which of the following occur earlier in the order of operations than context filters?

Q15. In Tableau, how do you change the color of a chart from the Marks card? [Choose all that apply]

Q22. Aliases cannot be created for the following (Choose as many as appropriate)

Q25. How do you make a stacked bar chart with a separate bar for each measure? [Choose All That Apply]

Q46. Choose which of the following are true for using fonts in Tableau for visualization? [Select all that Apply]