Tableau Desktop Certification Practice Test 16

Factories improve what they can see. Free Tableau Desktop Certification Practice Test 16 is for manufacturing candidates using the Tableau Desktop certification as a bridge out of general reporting. Scrap, downtime, supplier scorecards, and safety trends belong in a view a plant manager will open. Tableau is that view when the extract is trusted and the layout is plain.

Caterpillar, Honeywell, and 3M hire BI developers and analysts who can sit between operations and finance. Certification benefits include faster internal mobility and a stronger external application when your experience is Excel-heavy. Job offers in Tableau still ask for more than charts. Employers want the person who can show a constraint, not a gallery.

Junior Tableau developers frequently earn $75,000–$105,000. Mid-level Tableau developers frequently earn $105,000–$145,000. Senior Tableau developers frequently earn $130,000–$175,000. Industrial markets often cluster near the national averages of about $112,000 and $135,000, with premiums for roles that also own the data model.

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

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 via the Synergisticit JOPP

Welcome to your Tableau Desktop Specialist - Test-16

Name

Phone

Q1. The scope of table calculations is

Select 3 option(s):

Cell

Row level

Pane

Table

Q2. Different ways to swap column and row shelf fields

Select 3 option(s):

By using a tool bar icon.

Analysis in menu bar -> swap rows and columns.

Ctrl + W

None

Q3. How to duplicate a worksheet?

Select 2 option(s):

In tool bar click on duplicate.

On sheet tab -> mouse right button -> duplicate

Dashboard in menu bad -> duplicate

None of above

Q4. How many auto-generated fields are added to the dimension?

Select 1 option(s):

Q5. Which table calculation do we use to find the percentage difference as compared to the previous year?

Select 1 option(s):

Difference

Running total

Rank

Percentage difference

Q6. Filter options of discrete dimension when we drag it to the filter shelf.

Select 2 option(s):

General

Special

At least

Condition

Q7. What type of grouping does the picture indicate?

Select 1 option(s):

Visual grouping

Grouping by header

Grouping at field

It represent set

Q8. Which of the following represents a date value?

Select 1 option(s):

Q2 2023

2023

Week 5, 2023

Q9. If field contain only negative or only positive values, if we drag to color mark what color palette we will get

Select 1 option(s):

Sequential color palette.

Individual color palette.

Diverging color palette.

Discrete palette.

Q10. If a field contains both +ve and -ve values, then we will get diverging color palettes.Select 1 option(s):

TRUE

FALSE

Q11. What are the filter options available when we pass a date field in filter shelf?

Select 3 option(s):

Starting day

Ending day

Special

General

Q12. What are the actions available in the dashboard?

Select 3 option(s):

Go to sheet action

Change set values action

Change value action

Change parameter action

Q13. Is it possible to convert a date field to a measure?

Select 1 option(s):

YES

Q14. What does the.TBM signify?

Select 1 option(s):

Table book mark

Tableau book mark

Tableau black mark

Tableau bin mark

Q15. Which of the following is true about the context filter?

Select 3 option(s):

It is independent filter.

Can be rearrange in filter shelf.

Grey in colour.

Access by user.

Always at the top of all filters in filter shelf

Q16. The story analysis toolbar is not enabled.

Select 1 option(s):

TRUE

FALSE

Q17. For which chart angle is available?

Select 1 option(s):

Stacked bar chart

Angle chart

Filled map

Pie

Q18. What types of aggregation are possible for a dimension?

Select 2 option(s):

Sum

Percentage

Countd

Maximum

Q19. The number of decimals supported by tableau is

Select 1 option(s):

Q20. Aggregation is possible for both dimensions and measures.

Select 1 option(s):

TRUE

FALSE

Q21. Different Data types are available for dimensions.

Select 2 option(s):

Maximum

Boolean

Spatial

Sum

Q22. What is the size of each bubble represented in the bubble chart?

Select 1 option(s):

Measure name

Circle

Text value

Measure value

Q23. It is possible to change the date field to continuous.

Select 1 option(s):

TRUE

FALSE

Q24. What type of calculated field gives better performance as compared to others?

Select 1 option(s):

BOOLEAN

INTEGER

STRING

GEOGRAPIC

Q25. What is the color we will get when drag a measure to the row/ column shelf?

Select 1 option(s):

ORANGE

GRAY

YELLOW

GREEN

Q26. Which of the following is a better match for the logical layer?

Select 3 option(s):

We can give relationships between the tables in the logical layer that are represented in the form of noodles.

We can’t perform join types in the logical layer.

Logical tables are containers for physical tables.

It is not a by default canvas.

Q27. Show title is enabled in stories by default.

Select 1 option(s):

TRUE

FALSE

Q28. What are the default properties available for a measure?

Select 2 option(s):

Total using

Aggregation

Shape

Sort

Q29. Which of the following is possible for a measure field?

Select 2 option(s):

Bin

Alias

Group

Set

Q30. The transform option is available for both dimensions and measures.

Select 1 option(s):

FALSE

TRUE

Q31. Size marks don’t work for Tree maps.

Select 1 option(s):

TRUE

FALSE

Q32. Which of the following is correct for blending?

Select 3 option(s):

Blending is executed at sheet level.

It is used when we work on different data sources.

Secondary data sources perform a left join with the primary data source.

Blend can be published.

Q33. What is the data type of a parameter?

Select 3 option(s):

FLOAT

INTEGER

GEOGRAPIC

DATE

Q34. How do I rename a field at the data source level?

Select 2 option(s):

Go to the particular field you want to rename. Click on the drop-down arrow and select “Rename.“

Mouse left button: double click -> rename

We can’t change the file name on the data source page.

The correct option is none of the above.

Q35. Identify the data type for DATENAME (‘day’, [order date])?

Select 1 option(s):

Boolean

Numeric

String

Geographical

Q36. What is the output of SPLIT (“tableau_2022”,”_”, 2)?

Select 1 option(s):

2022

tableau

Q37. Output of CEILING (2.99)?

Select 1 option(s):

2.5

Q38. Why should we prefer extract connection over the live one?

Select 2 option(s):

It will query the date from the Tableau data engine.

Extracting takes more time.

Less performance for large data sources.

The query execution time is less.

Q39. Which of the following is true about joining?

Select 2 option(s):

It uses different data sources.

Static

Join always creates a new table in the database.

Remove granularity.

Q40. How to create a stacked bar chart?

Select 1 option(s):

After creating a bar chart, drag one measure field to color-mark.

After creating a bar chart, drag one dimension field to the color mark.

We can create a bar chart directly from Show Me.

No option to create a stacked bar chart.

Q41. How many measures are required to plot a tree map?

Select 1 option(s):

0 measure

1 or 2 measures

Only 1 measure

Only dimension

Q42. What is the method of forecasting?

Select 2 option(s):

Additive

Multiplicative

Cumulative

Aggregation

Q43. Identify the symbol represent (paper clip)

Select 1 option(s):

Set

Boolean

Group

Q44. What does .hyper file indicate?

Select 1 option(s):

It represents the Tableau data engine.

It stores connection information.

All the custom shape types are present in this.

Contain custom calculated fields, groups, and sets.

Q45. What is the purpose of a box plot?

Select 2 option(s):

It is used to identify outliers.

Percentage of contribution.

Comparison analysis.

Distribution of values of measure.

Q46. What are the native connectors in Tableau?

Select 1 option(s):

JDBC

ODBC

CONNECTOR PLUGIN USING TABLEAU CONNECTOR SDK

MDT

Q47. Which of the following does not fall under the Scope of the reference line?

Select 1 option(s):

Entire table

Per pane

Per cell

Per header

Q48. What type of join represents the below?

Select 1 option(s):

Inner join

Left join

Outer join

Cross join

Q49. Default connection type when we connect a data source to tableau

Select 1 option(s):

LIVE

EXTRACT

Q50. Which of the following represents the correct

Select 3 option(s):

Filters used at sheet level are local filters.

The user can’t control the context filter.

The filter in the filter shelf works on the OR clause.

We can pass the filter to different worksheet for the same data source.

Q51. We can connect to Amazon Redshift in Tableau.

Select 1 option(s):

Yes

Q52. Which filter option type is not available when we drag a date dimension to the filter shelf?

Select 1 option(s):

General

Condition

Wildcard

Top

Q53. Which of the following is incorrect about the data source connection?

Select 1 option(s):

Extract connections and make connections between Tableau and the Tableau date engine.

Live connections make direct links between tableau and the data source.

A live connection gives better performance than an extracted connection.

Any change in the database that reflects on Tableau in the live connection

Q54. What are the sort by options not available in dimension?

Select 1 option(s):

Field

Nested

Numeric

Manual

Q55. Why do we use bar charts?

Select 1 option(s):

For Moving average analysis.

For Percentage of total analysis.

For Time series analysis analysis.

For Comparison analysis.

Q56. Which of the following is not a filter action in a dashboard?

Select 1 option(s):

It enable the communication between the dashboards.

We need to use SELECT as the run action.

Use the data from the source sheet and filter the data on the target sheets.

We can communicate the sheet with the webpage.

Q57. Forecasting is only possible with at least one measure.

Select 1 option(s):

TRUE

FALSE

Q58. Default mark type for the highlight table

Select 1 option(s):

Table

Rectangle

Square

Pane

Q59. No of chart type in available in marks card

Select 1 option(s):

Q60. What is the geographic role of a measure by default?

Select 1 option(s):

Number

Measure

Continuous

None

Q61. We can drag the same table for union.

Select 1 option(s):

TRUE

FALSE

Q62. Which of the following is false?

Select 1 option(s):

You can add an alias for a discrete dimension.

You can add an alias for a calculated field.

You cannot create an alias for a continuous dimension.

You cannot create an alias for a measure.

[/ppwp]