Tableau Desktop Specialist Test - 4

The Tableau Desktop Specialist mock test validates your knowledge of Tableau fundamentals. It’s a badge of learning, but badges alone don’t secure jobs.

Employers want professionals who can integrate Tableau with Power BI, SQL, SAS, and Azure. They also expect data engineering proficiency in Snowflake, Databricks, and PySpark, plus data science and AI skills in TensorFlow, PyTorch, LLMs, and Generative AI. Project work is critical to prove you can deliver solutions in real-world environments.

SynergisticIT’s Data Science JOPP program bridges this gap, equipping you with advanced skills and project experience. Learn more: Data Science JOPP.

Welcome to your Tableau Desktop Specialist - Test-4

Name

Phone

Q1. Which of the following is a benefit of using a Tableau Data Source (.tds)?

Select 1 option(s):

To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc

To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who dont have access to the original data.

To hold one or more worksheets, plus zero or more dashboards and stories.

Q2. Which of the following are valid Dashboard size options?

Select 3 option(s):

Fixed Size

Scaled

Range

Automatic

Q3. Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?

Select 1 option(s):

If dragged to row shelf : 7 marks ; If dragged to column shelf : 7 marks

If dragged to row shelf : 14 marks ; If dragged to column shelf : 14 marks

If dragged to row shelf : 14 marks ; If dragged to column shelf : 7 marks

If dragged to row shelf : 7 marks ; If dragged to column shelf : 14 marks

Q4. Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?

Select 1 option(s):

By dragging another measure to the Columns shelf

By dragging another measure to Color on the Marks card

By dragging another dimension to Color on the Marks card

By dragging another dimension to the Rows shelf

Q5. To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs.

Select 1 option(s):

values

sets

inputs

parameters

Q6. Which of the following calculations DO NOT need a quick table calculation?

Select 2 option(s):

Rank

Moving Average

Variance

Standard Deviation

Q7. While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.

Select 1 option(s):

margining

spacing

tiling

padding

Q8. The options for dimensions and measures will differ during filtering

Select 1 option(s):

Yes

Q9. Extension for packaged data source is

Select 1 option(s):

.tds

.tdsx

.hyper

.csv

Q10. Can Custom Shapes can be imported in tableau. Can they be used as filters ?

Select 1 option(s):

No, Yes

Yes ; Yes

Yes, No

No ; No

Q11. Date pill in blue says that its

Select 1 option(s):

Cant say

discrete

continuous

Q12. Which of the following views in dashboard might overlap

Select 1 option(s):

Tiled

None

Both

Floating

Q13. Is it possible to bold the axis in chart

Select 1 option(s):

Yes

Q14. Which of the following model is more significant

Select 1 option(s):

P is 1.99

P is 0.1

P is 0.04

P is 0.99

Q15. When you create bins from a measure you create a new dimension. True or False ?

Select 1 option(s):

FALSE

TRUE

Q16. A story can have multiple dashboards included

Select 1 option(s):

Yes

Q17. Stepped color is selected as 5, how many variations of color is seen

Select 1 option(s):

Q18. Which of the following will help in easily knowing the maximum and minimum values in the text table

Select 1 option(s):

Table Calculation

Quick table calculation

Group

Sort

Q19. Which of the following tableau view will update based on changes to the underlying data.

Select 1 option(s):

none

live

both

extract

Q20. Default aggregation in Tableau is ? Can it be changed ?

Select 1 option(s):

Sum ; No

Sum ; Yes

Avg; No

Avg ; Yes

Q21. Which of the following results in a table that contains all values from both tables.

Select 1 option(s):

Full Outer

Inner

Left

Right

Q22. Adding which one of the following will make a bar chart into stacked bar chart

Select 1 option(s):

dimension only

none

both dimension and measure

measure only

Q23. Which of the following can be used for classifying based on a condition or Top criteria

Select 1 option(s):

Set

Hierarchy

groups

None

Q24. Dimensions are mostly

Select 1 option(s):

continuous

Cant say

discrete

Q25. Color palettes are different for dimensions and measures. True or False?

Select 1 option(s):

TRUE

FALSE

Q26. Granularity depends on which one

Select 1 option(s):

None

Both

dimension only

measures only

Q27. You may create an context filter to

Select 1 option(s):

Create a dependent numerical or top N filter

Improve performance

none

both

Q28. A chart with two Y axis and one X axis is

Select 1 option(s):

Combined Axis Chart

None

Dual Axis Chart

Dual or Combined Axis

Q29. Text tables are also known as

Select 2 option(s):

Cross tabs

Pivot tables

Pivot tabs

Cross tables

Q30. Reference line can be added from this pane

Select 1 option(s):

Analytics

Data

Predict

Format

Q31. # represents the following datatype

Select 1 option(s):

Numerical Values

Text

Boolean

Date

Q32. Action used for hyperlinks to external resources, such as a web page, file, or another Tableau worksheet.

Select 1 option(s):

Go to Sheet

Highlight

Go to URL

Filter

Q33. You can create the following for members in a dimension so that their labels appear differently in the view.

Select 1 option(s):

groups

rename

sets

aliases

Q34. Line option comes under Marks pane for which of the charts

Select 1 option(s):

Stacked Bar

Bar

Area chart

Line

Q35. Which of the state has lowest average quantity. Use Super store data – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

California

Texas

Idaho

Newyork

Wyoming

Q36. Which of the following URL prefixes are allowed in Dashboard Actions

Select 3 option(s):

FTP

HTTPS

HTTP

LOCALHOST

Q37. Tableau can create worksheet-specific filters.

Select 1 option(s):

Yes

Q38. Blue and Green in Tableau means

Select 1 option(s):

Dimension and Measure

Continous and Discrete

Discrete and Continous

Measure and Dimension

Q39. This type of join will include all values from the right table

Select 1 option(s):

left join

right join

union

blend

Q40. Sub Category and Category can be grouped using

Select 1 option(s):

Parameter

Set

Group

Hierarchy

Q41. Which of the following options can be used to reverse the palette color shades

Select 1 option(s):

Stepped Color

Full color Range

Reverse Colors

Reversed

Q42. Which of the following changes are saved in .tds file.

Select 4 option(s):

Calculated Fields

Groups

Parameters

Aliases

Default Properties

Q43. Which of the following are generated fields in tableau

Select 4 option(s):

Latitude

Measure Values

Longitude

Measure Names

Unattempted

Q44. These kind of filters are identified by a grey color on the Filters shelf.

Select 1 option(s):

Context Filters

Dimension filters

Extract Filters

Data source filters

Q45. Maximum percentage of total discount is in which city and what is the percentage. Use sample Store – orders data. Please download the needed data from https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Philadelphia,11.24%

Jacksonville, 15.03%

Tampa,18.9%

Miami,7.82%

Charlotte,10.91%

Q46. Extract filters are available only for which option when you are trying to extract the data

Select 1 option(s):

Joins

Single Table

Multiple Tables

Identical Datatypes

Q47. Which of the following are valid datatypes

Select 2 option(s):

Date Month

Date Year

Date

Date Time

Q48. Which of the following statements are correct

Select 2 option(s):

Dual Axis chart can be created only with measures and not with date

There is no difference between dual axis and combined axis charts

Once the Combined axis chart is created, rows/columns are updated to Measure Names and Mesaure values

Combined axis chart is created by dragging 2 measures onto same axis

Q49. Which of the following are common default properties for every measure or dimension

Select 2 option(s):

Number format

Shape

color

comment

Q50. Which of the following charts is used to visualize the relationship in numeric variables

Select 1 option(s):

Line chart

Scatter plot

Box plot

Area chart

Q51. A visual group can be created by

Select 2 option(s):

Select the marks and right click , create group

Select the marks from left pane and use group

Select the marks and click on group icon on the top

Select the marks and click on worksheet, then group.

Q52. Dimensions that are used to frame the calculations in crosstab are called as

Select 1 option(s):

Text fields

Addressing Fields

Partition Fields

Pivot fields

Q53. Which of the following are true about measures

Select 2 option(s):

They are seen in green color

They apply aggregation by default

They have Qualitative data

Continuous measures create axes when used

Q54. Which of the following will help in opening up the web page within dashboard

Select 1 option(s):

Running Action

Web Page URL

Web Page Action

Web Page Object

Q55. Using data filter in the data source page will

Select 1 option(s):

This option itself is not present

filter the data for all sheets

data can be filtered only in sheet

filter the data for only one sheet

Q56. Find the total sales value of items shipped in June and May 2014.Please download sample super store data from https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

68542

58471

78542

58243

Q57. Blend resembles this join

Blend resembles this join

Select 1 option(s):

right

left

union

cross db

Q58. A bar chart is converted to stacked bar chart by adding

Select 1 option(s):

Measure

Cant determine

Dimension

2 Measures

[/ppwp]