Tableau Desktop Certification Practice Test 15

Payments businesses explain authorization, merchant health, and spend mix to people who will not read a query. Free Tableau Desktop Certification Practice Test 15 is the Tableau Desktop certification checkpoint for that audience. Tableau is how product, risk, and finance teams share one view of volume without exporting a new file for every question.

Visa, Mastercard, and American Express hire visualization and analytics talent across issuing, acquiring, and internal finance. Certification benefits are strongest as an early-career or switcher signal. You look serious about the tool, and you give a recruiter a reason to advance you. Offers still hinge on whether you can describe a metric’s grain and what a leader should do after seeing it.

Junior Tableau developers often land $75,000–$105,000. Mid-level Tableau developers often land $105,000–$145,000. Senior Tableau developers often land $130,000–$175,000, with some payments and fintech seats above the senior average of about $135,000. The broader developer average stays near $112,000.

Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs, the Java DevOps Full Stack JOPP and the 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 software engineer, contact Synergisticit for expert upskilling, interview preparation, and marketing connections to companies, then review the Synergisticit JOPP.

Databricks, and PySpark. Data science and AI skills—TensorFlow, PyTorch, LLMs, and Generative AI—are increasingly required. Project work is the ultimate proof of employability. SynergisticIT’s Data Science JOPP program ensures your certification signal translates into career readiness by equipping you with advanced skills and project experience.

Welcome to your Tableau Desktop Specialist - Test-15

Name

Email

Phone

Q1. In Tableau, which of the following options can you use to sort a bar chart by the values of a measure?

Select 1 option(s):

Right-click the dimension in the view and choose “Sort“

Drag the measure onto the Sort shelf on the Marks card

Click the “Sort“ button in the toolbar

Right-click the measure in the Data pane and choose “Sort by Field“

None

Q2. What is the primary purpose of logical and physical tables in Tableau‘s data model?

Select 1 option(s):

To create a backup of the original data

To improve performance and take advantage of Tableau functionality not available in the original data

To better describe how extracts will be stored

To convert the data into a different format

None

Q3.  In Tableau, when defining a Percent Difference From table calculation, which option calculates the difference between the current value and the first value in the partition?

Select 1 option(s):

Previous

Next

First

Last

None

Q4. In Tableau, what are the two types of sets that can be created and how do they differ?

Select 1 option(s):

Dynamic sets and Static sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Static sets do not change even if the underlying data changes and can be based on a single or multiple dimensions

Dynamic sets and Fixed sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Fixed sets do not change even if the underlying data changes and can be based on a single or multiple dimensions

Dynamic sets and Variable sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Variable sets change depending on user interaction and can be based on a single or multiple dimensions

Dynamic sets and Interactive sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Interactive sets change depending on user interaction and can be based on a single or multiple dimensions

None

Q5. When you need to relate tables across different databases, what should you do?

Select 1 option(s):

Add them as new data sources from the Data menu

Create a new data source from the drop-down menu next to the Data Source‘s name

Use the Add link in the Left pane to add them as data connections within the same data source

Relating tables across different databases is not possible in Tableau

None

Q6.  How may a sheet - level field be renamed?

Select 2 option(s):

Q7. What is the under-dated portion of the following?

Select 2 option(s):

43952

Q2

5th March 2022

2022

Q8. What function is used to determine the input string‘s length?

Select 1 option(s):

Len ()

Zn ()

Find ()

Replace ()

None

Q9. Which of the following is the correct definition of the ZN function?

Select 1 option(s):

It uses the input expression. If the expression is positive, it returns 0.

It uses the input expression. If the expression is negative, it returns 0.

It uses the input expression. If the expression is NULL, it returns 0.

It uses the input expression. If the expression is a string, it returns 0.

None

Q10. Why should we prefer an extract connection over a live?

Select 2 option(s):

We can work offline: With an extract connection, we have the advantage of working offline. We can access and analyze data even without an internet connection.

Better performance for large databases: When dealing with large databases, it is recommended to use an extract connection for improved performance. Extracts are optimized subsets of data that are stored locally, allowing for faster querying and analysis.

No constant internet connection is required: Unlike live connections, extract connections do not rely on a continuous internet connection. Once the data is extracted, it is stored locally, eliminating the need for a constant internet connection.

Always up-to-date: Extracts can be refreshed to get the latest data whenever needed. By refreshing the extract, we can ensure that we are working with the most updated information.

Q11. Why is joining better than a relationship?

Select 3 option(s):

Joining is possible when we are working with the same data source.

Joining provides different options to combine two tables.

Joining reduces the size.

Joining supports different data sources.

Q12. If you first drag a dimension field to the row shelf, then a measure field to the column shelf, the chart type you will get in the view is a _____ graph.

Select 1 option(s):

Line

Bar

Circle

Bubble

None

Q13. Number of dimensions to create a heat map?

Select 1 option(s):

One measure.

Zero measure and more dimension.

1 or more dimensions and 1 or 2 measures.

One or more dimensions.

None

Q14. Which method do we use for forecasting?

Select 1 option(s):

Trend line

Binomial

Exponential smoothing

Smoothing

None

Q15. Which of the following helps to reduce the size of the extract?

Select 2 option(s):

By hiding unused fields.

Using aggregation on the measures.

Increasing the connection between tables.

Inner joining the tables.

Q16. Measure create axis when dragging to column or row shelf

Select 1 option(s):

TRUE

FALSE

None

Q17. What is the use of marks in the tableau?

Select 1 option(s):

Proper viz.

For better performance.

Marks to control the visual features of view in a plot.

None

None

Q18. What if we create a group using the marks?

Select 1 option(s):

We will get a set type.

We will get a field on the dimension section in the data pane the grouped values will represent in blue colour.

No of mark increase.

No effect.

None

Q19. How to add a new data source connection in tableau at the data source page

Select 12 option(s):

Go to file in menu bar then new file.

Click on add in the connection pane.

We can’t connect new data source.

Go to data in the menu bar -> Data-> new data source.

Q20. Aliases we can create only for discrete dimensions

Select 1 option(s):

TRUE

FALSE

None

Q21. For contribution analysis, the recommended quick table calculation to use is

Select 1 option(s):

Difference

Percentage of total

Sum

Moving age

None

Q22. What does it mean * after the ATTR function?

Select 1 option(s):

No value present in the expression.

It represents the input expression contains multiple values.

When one value is zero.

Calculation is not supports.

None

Q23. What are the ways we can change the tooltip contents?

Select 2 option(s):

Go to marks card -> tooltips

Mouse right-click (on view) -> format-> default -> tooltip

Worksheet in menu bar -> tooltip

Dashboard -> format

Q24. Which of the following displays a blue pill?

Select 2 option(s):

Sales

Percentage of contribution

Order id

State

Q25. It is possible to delete an auto-generated field.

Select 1 option(s):

TRUE

FALSE

None

Q26. We can convert a dimension to a measure.

Select 1 option(s):

TRUE

False

None

Q27. We can add a trend line to a scatterplot.

Select 1 option(s):

TRUE

False

None

Q28. Which of the following is true about dimension?

Select 3 option(s):

State, country etc are dimension

Dimension create header when we drag to column and row shelf

We can’t convert a dimension to measure

We can create BIN on dimension

Q29. How to clear a worksheet

Select 3 option(s):

Alt + Shift + Backspace (shortcut)

Go to clear work sheet icon in tool bar and press

Go to worksheet in menu bar -> worksheet -> clear

None of above

Q30. Which of the following is correct about relationships?

Select 3 option(s):

Relationships don’t change the table structure.

To combine tables from different data sources, we use relationships.

It occurs at a logical layer.

Relationships are executed at sheet levels.

Q31. Which of the following is true about action?

Select 2 option(s):

We can add actions at the sheet level.

Action is used to create the interactive relationship between date, worksheets, and URL.

Action change the data types.

Action helps to change the dashboard layout.

Q32. Is it possible to add two work sheets at the same time to a dashboard?

Select 1 option(s):

YES

NO

None

Q33. Which of the following auto-generated measures supports an alias?

Select 1 option(s):

Measure name

Latitude

Longitude

Measure value

None

Q34. Is it possible to change the aggregation or alias of the published data source?

Select 1 option(s):

YES

NO

None

Q35. We can create a reference line, reference band, and distribution band from the analytic pane for a continuous axis.

Select 1 option(s):

TRUE

False

None

Q36. Show title is disabled in the dashboard by default.

Select 1 option(s):

TRUE

False

None

Q37. What are the default properties available for a dimension?

Select 1 option(s):

Boolean

Comment

String

MAP

None

Q38. Is it possible to create a BIN on a dimension?

Select 1 option(s):

NO

YES

None

Q39. It is possible to add two reference lines for the same axis.

Select 1 option(s):

TRUE

False

None

Q40. Which of the following are representations of geographic role types?

Select 3 option(s):

Airport

Area code

Village name

CBSA/ MSA

Continent

Q41. Bubble charts don’t have any axes.

Select 1 option(s):

TRUE

False

None

Q42. Can we sort as per date?

Select 1 option(s):

YES

NO

None

Q43. Which of the following is true for incremental and extract refresh?

Select 2 option(s):

An incremental refresh takes less time to update the dataset compared to a full refresh.

An incremental refresh only adds the newly added rows to the existing table.

An incremental refresh increases the data size.

A full refresh is faster than an incremental refresh.

Q44. Which pane does the below figure indicate?

Select 1 option(s):

DATA PANE

Filter

Parameter

Data source page

None

Q45. We can add a calculated field to the reference line.

Select 1 option(s):

TRUE

False

None

Q46. What is the P value in the trend line?

Select 1 option(s):

P <= 0.05

P = 0

P >= 0

P >= 0.05

None

Q47. Which of the following is true for the TDS file type?

Select 2 option(s):

It stores the connection information.

It stores local data.

filter settings.

It contains groups, set, bins.

Q48. We can pass SET, GROUP, and PARAMETERS in calculated fields.

Select 1 option(s):

TRUE

FALSE

None

Q49. Choose the correct representation of the animation type.

Select 2 option(s):

Sequential animation takes more time than simultaneous animation.

Simultaneous animation is the default.

The default animation duration is 1 minute.

We can create animations at the dashboard level.

Q50. Which one, if not correct for quick filter options, is available for dimension?

Select 1 option(s):

Single value (slider)

Single value (list)

Multi value (custom list)

None

None

Q51. When we drag dimensions to the shelf, it will create a header.

Select 1 option(s):

TRUE

False

None

Q52. Default marks type in the marks card Tableau

Select 1 option(s):

Circle

Bar

Automatic

Polygon

None

Q53. Choose different ways to create groups.

Select 3 option(s):

In the data pane, select the particular file on which we want to create a group, right-click the mouse button, create, and then group.

Select the marks you want to group from view by pressing the ctrl key -> mouse right button -> group.

Select the headers from the view -> group icon on the tool bar.

None of the above

Q54. How to add a new data source connection in Tableau at the sheet level

Select 2 option(s):

Go to data in the menu bar: Data->New Data Source.

Go to Work Sheet in the menu bar and add a new data source.

Click on the new data source icon on the sheet level.

We can’t connect to any new data sources.

Q55. Can we export our workbook in a lower version from the current version?

Select 1 option(s):

Yes

No

None

Q56. Which of the following can we add by quick table calculation?

Select 3 option(s):

Difference form

Percentage of total

Moving average

Sum ()

Q57. To visualize the year-over-year (YOY) growth of sales, the chart we should prefer is a ______ chart.

Select 1 option(s):

Line

Bar

Circle

Pie

None

Q58. How do I change the sheet title to italic?

Select 2 option(s):

Double click on the work sheet title -> change the font style.

Right click on the title -> edit title-> change the font style.

We can’t change the title.

Go to worksheets in the menu bar and change the title.

Q59. Which of the following is a green pill?

Select 2 option(s):

State

Sales

Ship mode

Measure value

Q60. What are the different ways we can sort?

Select 3 option(s):

Tool bar

Header

Legend

None

Q61. Is it possible to convert a measure to a dimension?

Select 1 option(s):

TRUE

False

None

Q62. How do I edit the row and column labels?

Select 2 option(s):

Go to axis in view -> right click -> title -> change the title.

Go to work sheet in menu bar -> change the title.

Format -> change title.

Double click on the axis -> title-> change title

Q63. Which of the following is true about measure?

Select 2 option(s):

We can pass a quick table calculation on to measure.

Can convert measure to dimension.

Measure can be discrete and continuous

Measure won’t change the datatype.

Q64. How can we increase the mark on the views evenly?

Select 1 option(s):

Legend

By adjusting Size mark

Removing from the mark

Slider

None

Q65. Which of the following are dashboard objects?

Select 3 option(s):

BLANK

WEB PAGE

ASK DATA

PAINT

Time's up

[/ppwp]