A fully updated 2022 Desktop-Specialist Exam Dumps exam guide from training expert SurePassExams [Q31-Q51]

Rate this post

A fully updated 2022 Desktop-Specialist Exam Dumps exam guide from training expert SurePassExams

Provides complete coverage of every objective on exam and exam preparation Desktop-Specialist

Topics of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam

Candidates must know the exam topics before they start preparation. Because it will help them to hit the core. Tableau Desktop Specialist exam tests will include the following topics:
1 Design for Organizational Complexity

Determine how to design networks for complex organizations (for example, an organization with varying compliance requirements, multiple business units, and varying scalability requirements)
Determine a solution design and implementation strategy to meet reliability requirements
Determine a solution design to ensure business continuity
Select a cost-effective pricing model for a solution
Identify opportunities to reduce cost in an existing solution
5 Continuous Improvement for Existing Solutions
Determine how to improve the deployment of an existing solution
Determine a strategy to improve the performance of an existing solution
Determine a strategy for migrating existing on-premises workloads to the cloud
4 Cost Control
Determine a deployment strategy to meet business requirements when designing and implementing a solution
3 Migration Planning
Determine a strategy to improve the security of an existing solution
Determine which controls to design and implement that will ensure cost optimization
Determine security requirements and controls when designing and implementing a solution
Determine a solution design to meet performance objectives

NO.31 True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

True

False

NO.32 ________________ can only create header. _______________ will create header and axis both.

Dimensions, Measures

Measures, Dimensions

Groups, Sets

Dates, Strings

NO.33 True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

rue

False

NO.34 For Bullet Graphs we need at least ____________ measures

NO.35 Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

584

901

Correct)

205

660

NO.36 Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

September 2017

March 2018

December 2017

January 2018

NO.37 The row and column shelves contain ___________________

Pills

Grand Totals

Filters

Parameters

NO.38 Which of the following returns the Absolute Value of a given number?

ABS(Number)

CEILING(Number)

FLOOR(Number)

ZN(Number)

NO.39 ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Joining

Blending

Combining

Unioning

NO.40 By default, measures placed in a view are aggregated by ______________

COUNT

AVERAGE

MEDIAN

SUM

NO.41 Which of the following are interactive elements that can be added to a dashboard for users?

URL Action

Filter Action

Highlight Action

Edit Tooltip Action

NO.42 Is it possible to make a Measure discrete?

Yes

NO.43 Which of the following is a valid way to create Sets in Tableau?

In the Data pane, right-click a dimension and select Create > Set.

In the Tableau Main Menu, Choose Worksheet and select Create > Set

In the Tableau Main Menu, choose Dashboard and select Create > Set

In the Data pane, right-click a measure and select Create > Set.

NO.44 When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

Data source Filter

Extract Filter

Context Filter

None of the these

NO.45 The View Data window displays as much of the data as possible by default, up to _______________ rows.

20,000

5,000

10,000

15,000

NO.46 Which of the following is the correct way to calculate Profit Ratio in Tableau?

Profit / Sales

Sales / Profit

SUM(Profit) / SUM(Sales)

SUM(Sales)/SUM(Profit)

NO.47 For a relative date filter, the default anchor is _________________

The current time

Today’s date

The target date

The date we specify

NO.48 For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Random

Manual

Topological

Hierarchical

NO.49 True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

True

False

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

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

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 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 don’t have access to the original data.

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.

NO.51 When using Animations in a Tableau, which of the following is the default duration for animations?

0.4s

0.3s

0.5s

0.2s