Tableau Desktop Specialist Test - 10

The Power BI PL-300 mock test is a catalyst for career growth. It validates your Power BI fundamentals and prepares you for certification. Yet, catalysts alone don’t guarantee employment. Employers want professionals who can integrate Power BI with Tableau, SQL, SAS, and Azure, while also mastering data engineering platforms like Snowflake, Databricks, and PySpark. Data science and AI skills—TensorFlow, PyTorch, LLMs, and Generative AI—are increasingly required.

The SynergisticIT Data Science Job Placement Program ensures your catalyst leads to career success by combining certification-level knowledge with advanced training and project-based learning. Learn more through the SynergisticIT Job Placement Program.

Welcome to your Tableau Desktop Specialist - Test-10

Name

Phone

Q1. Which type of date field is used below?

Select 1 option(s):

Discrete

Continuous

Exact

Date/Time

Q2. You have a bar chart showing monthly revenue by store. What should you do to combine the bars for two of the stores?

Select 1 option(s):

Create a group

Create a hierarchy

Create a set

Create an alias

Q3. Why the direct connection to the extract is not recommended? (Select All that Apply)

Select 3 option(s):

The table names will be different.

The extract can not be refreshed.

The data model and relationships will be lost.

The extract cannot be removed once it is connected directly.

Q4. How can we change the shape of the marks for a chart in Tableau?

Select 1 option(s):

Choose any two measures and drag them to columns and rows -> select any measure and drag it to the color of the Marks card -> select any measure and drag it to the shape of the Marks card.

Choose any one measure and drag it to columns and choose any dimension and drag it to rows -> select any dimension and drag it to the color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card.

Choose any two dimensions and drag them to columns and rows -> select any dimension and drag it to the color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card.

Choose any two measures and drag them to columns and rows -> select any dimension and drag it to the color of the Marks card -> select any dimension/measure and drag it to the shape of the Marks card.

Q5. How can we create a dashboard in Tableau? [Select all that Apply]

Select 2 option(s):

Go to dashboard and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok.

Go to Analysis and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok.

Go to Worksheets and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok.

Select the New Dashboard option -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok.

Q6. How can we manually add a separate device layout in Tableau?

Select 1 option(s):

Open a dashboard -> On the Dashboard tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode.

Open a dashboard -> On the Analytics tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode.

Open a Worksheet -> On the Dashboard tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode.

Open a dashboard -> On the Dashboard click on Format tab and select Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode.

Q7. How can we publish a workbook for Tableau?

Select 1 option(s):

Open the desired workbook for publish. Go to File. Click on Save to Tableau Public As. Sign in to the server. Name the workbook for publish. Click Ok.

Open the desired workbook for publish. Go to Data. Click on Save to Tableau Public As. Name the workbook for publish. Click Ok

Open the desired workbook for publish. Go to Analytics. Click on Save to Tableau Public As. Name the workbook for publish. Click Ok

Open the desired workbook for publish. Go to Format. Click on Save to Tableau Public As. Name the workbook for publish. Click Ok

Q8. Which of the following is true for Measures in Tableau?

Select 2 option(s):

Measures contain numeric, quantitative values.

Measures contain qualitative values (such as names, dates, or geographical data).

Measures can be used to categorize, segment, and reveal the details in the data.

Measures can be aggregated.

Q9. Which are all true about dashboard Web page objects? [select all that apply]

Select 2 option(s):

If a dashboard contains a Web page object, an URL action will open the web page on
the dashboard only.

To interactively display information from the web inside a dashboard, you can use a
URL action with a web page object.

A dashboard can have multiple Web page objects.

Web page objects can be added only to Dashboard or Story but not to a Worksheet.

Q10. Which file type saves both the connection information (for example the database server address), calculations and groups that you‘ve added, along with an extract of the data?

Select 1 option(s):

.hyper

.tds

.tde

.tdsx

.twb

Q11. What actions should you take after adding one table to the canvas to create a relationship with a second table on a separate database?

Select 1 option(s):

Select Data on the toolbar, then New Data Source. Enter the connection information and drag the desired table into the canvas.

Click the Add link to the right of the Connections heading in the left pane. Switch between data connections in the left pane, then drag out the desired table to the canvas and release it.

In the left pane, select the New Custom SQL option. Use the full database and SQL name in the query.

Right-click the data source and select Edit Connection. Update the database for the second table. Then drag the second table into the canvas until you see the noodle appear creating the connection to the first table.

Q12. A relationship is most similar to which type of join?

Select 1 option(s):

Left

Right

Inner

Outer

Union

Q13. Which of the following can be used to combine tables at different levels of granularity without duplicating data? [Select All that Apply]

Select 2 option(s):

Union

Join

Blend

Relationship

Concatenate

Q14. When we create a bin on measure, a new dimension is added to the existing dimension.

Select 1 option(s):

TRUE

FALSE

Q15. What is the output of LEFT (“TABLEAU”, 2)?

Select 1 option(s):

TABLEAU

Q16. Is it possible to use the same table in a union?

Select 1 option(s):

YES

Q17. The functionality we can get from the extract connection is

Select 1 option(s):

Sum

Count

CountD

Join

Q18. Default mark type for the heat map

Select 1 option(s):

Select 1 option(s):

LINE

RECTANGLE

SQUARE

Q19. Combined set for is used for what purpose.

Select 1 option(s):

To get all members in one sheet

Compare the members in one sheet

To get proper visualization

Change dynamically

Q20. The value of R in a regression model varies.

Select 1 option(s):

R = 0

R > 0

R = 1

Q21. URL action is used

Select 1 option(s):

We can switch from one sheet to another.

Connect tableau to outside of tableau.

To filter sheet

To swap sheet using parameters.

Q22. LOD types that Tableau supports

Select 3 option(s):

FIXED

Variable

INCLUDE

EXCLUDE

Q23. Output of MAKEDATETIME (2023, 7, 15, 12, 30, 0)?

Select 1 option(s):

5 hour: 20 minute: 23 second

5H: 23M: 23S

July 15, 2023, at 12:30 PM

None

Q24. Use of the cross-join

Select 1 option(s):

When information is sourced from various sources.

For same data source.

For left join.

To manage the data properly.

Q25. Which of the following in tableau doesn’t support animation?

Select 3 option(s):

Headers

Trends

Polygon in web browser

Profit

Q26. Indexes represent the position of records in a table.

Select 1 option(s):

TRUE

FALSE

Q27. What is .twb?

Select 1 option(s):

Tableau work box

Tableau worksheet

Table workbook

Tableau workbook

Q28. What is the default join in blending?

Select 1 option(s):

LEFT

RIGHT

INNER

CROSS

Q29. What does set represent?

Select 1 option(s):

Condition In a dimension

A set is the subset of data based on a condition.

In /out function

Combine data

Q30. What are the following comes under tableau product

Select 2 option(s):

Tableau desktop

Tableau social

Tableau network

Tableau server

Q31. How can we create a variable-sized bin?

Select 1 option(s):

Using calculated filed

Parameter

Set

Filter

Q32. To compare actual vs. target, which chart is suitable?

Select 1 option(s):

Bullet chart

Line

Pie

Gant

Q33. BIN accommodates dimensions.

Select 1 option(s):

TRUE

FALSE

Q34. Icon for indicating the join kind

Select 1 option(s):

VANE

BOX

NOODLE

PAPER CLIP

Q35. What is tableau online?

Select 1 option(s):

It not part of tableau product.

Tableau online is an open resource.

Tableau Online is a hosted version of Tableau Server.

None of above

Q36. To remove space from both sides of a string, we use the ________ function type.

Select 1 option(s):

LTRIM

RTRIM

TRIM

REPLACE

Q37. Which of the following is correct to explain about union?

Select 3 option(s):

It is possible on a physical table.

Sheet level

To create union we have to place the second table below the first table on the canvas shelf.

It append the no of row for both table

Q38. Default color of secondary data source: ORANGE

Select 1 option(s):

TRUE

FALSE

Q39. A workbook is what?

Select 1 option(s):

FOLDER

GRAPH

SHEET

A workbook contains one or more sheets. A sheet can be a worksheet, a dashboard, or a story.

Q40. Which of the following is correct in the ORDER of Operation?

Select 3 option(s):

Data source filter execute after extract filter

Data source filter execute at same time at context filter

Dimension filters then measure filter comes

Table calculation occurs at last

Q41. Which of the following represents a measure?

Select 3 option(s):

Quantitative

Numerical

State, student name, category etc. under measure

We can’t create set.

Q42. We can format only at the sheet level.

Select 1 option(s):

TRUE

FALSE

Q43. Which of the following is true about published and embedded data sources?

Select 3 option(s):

The embedded data source is dependent on the workbook.

If we delete the workbook in the embedded data source, then the data source will also be deleted.

We can create calculated fields on published data sources at the server level.

Published data sources are also dependent on the workbook.

Q44. Different ways to create calculated fields inside a worksheet

Select 2 option(s):

Analysis in tool bar -> create -> create calculated field

Drop down in data pane -> create calculated field

Analytic pane -> create calculated field

Worksheet -> create -> calculated field

Q45. Which of the following is true about a Tableau reader?

Select 3 option(s):

Print view

Can’t present the view

Export view

We can open and interact with workbook

Q46. What is the default mark type for a heat map?

Select 1 option(s):

Circle

Polygon

Bar

Square

Q47. Why do we use combined sets in Tableau?

Select 1 option(s):

To get all members on one sheet

Compare the members on one sheet.

To get proper visualization

Change dynamically

Q48. The value of R in the regression model varies as

Select 1 option(s):

R = 0

R > 0

0 < R < 1

R = 1

Q49. Which of the following best explains the use of URL actions?

Select 1 option(s):

We can switch from one sheet to another.

Connect tableau to outside of tableau (web).

To filter sheet

To swap sheet using parameters.

[/ppwp]