Desktop Specialist Tableau Free Online Dumps

Posted by: Pdfprep Category: Tableau Online Questions Tags: Desktop Specialist Online Questions Post Date: January 15, 2021

Pdfprep2021-01-15T16:36:13+00:00

Desktop Specialist exam is an important Tableau Certification which can test your professional skills. Candidates want to pass the exam successfully to prove their competence. Our technical experts have collected and certified all of Desktop Specialist questions and answers, which are designed to cover the knowledge points of the Tableau Desktop Specialist Exam Desktop Specialist exam. With these Desktop Specialist prep questions, you can pass the Desktop Specialist easily and go further on Tableau career path.

Page 1 of 7

1. Which one of the following is a dimension?

Longitude

Measure Names

Number of records

Latitude

2. You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases.

Which of the following would BEST satisfy this requirement?

Save it as a .twm file

Save it as a .twb file

Save it as a .tds file

Save it as a .twbx file

3. Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Yes

4. 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)

5. _________________ are 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.

.twb files

.tbm files

.twbx files

.tde files

6. Which of the following is NOT a valid official data source in Tableau Desktop?

PostgreSQL

SAP HANA

Google Firebase

Amazon Redshift

7. Which of the following are valid ways of Grouping Data?

Using Marks in the view

Using Labels in the View

From the Analytics Pane

From the Dimensions Shelf

8. Which Sub-Category had the least Profit in the Office Supplies category?

Fasteners

Labels

Envelopes

Binders

9. Which of the following is a good reason for using a bullet graph?

Comparing the actual sales against the target sales

Analysing the trend over a given time period

Forecasting future sales

Displaying the year-on-year growth in sales

10. Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.

role, type

Data type, Value

type, role

dimension, measure

Page 2 of 7

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

COUNT

AVERAGE

MEDIAN

SUM

12. 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.

13. True or False: Context Filters are executed after Data Source filters

True

False

14. Question 30: Skipped Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view.

What is its R-squared value?

0.783262

0.739284

0.759329

0.748472

15. What does it imply if a field has a blue background?

It is continuous

It is discrete

It is a dimension

It is a measure

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

Variance

Rank

Moving Average

Standard Deviation

17. Is it possible to make a Measure discrete?

Yes

18. When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

Monitor, Default, Phone, Tablet

Phone, Tablet, Laptop, Desktop

Default, Phone, Tablet, Desktop

Phone, Monitor, Laptop, Default

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

parameters

duplicates

copies

aliases

20. You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

join

blend

concatenate

union

Page 3 of 7

21. We can join a maximum of ______ tables in Tableau

128

22. If you see the following Filter, then you're working with _______________________ Larger image

Grouped Dates

Date Functions

Date Parts

Date Values

23. Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________

Dimensions and Measures

Rows and Columns

Labels and Values

Numbers and Headers

24. How can you add color to marks in the view in Tableau?

Click on Data in the main menu above, and click on choose color.

From the Data pane, drag a field to Color on the Marks card.

In the column/row shelf, right click the field and click on edit in shelf to select the color.

From the Analytics pane, drag a model to Color on the Marks card.

25. __________ is a technique in Tableau which will identify marks with similar characteristics

Clustering

Grouping

Sets

Union

26. Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Yes

27. When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Remote Field Name, Field Name

Local Name, Actual Name

Column Name, Actual Name

Local Field, Global Field

28. Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

If we want a static view of the visualisation.

If we want to use filters in the visualisation.

If we want to interact with the visualisation.

If we want to dynamically enter parameters to the visualisation.

29. Which of the following is NOT a new feature introduced in Tableau 2020.1?

Dynamic Paramaters

Viz Animations

Buffer Calculations

Set Control

30. Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM.

Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Brazil

Peru

Argentina

Mexico

Page 4 of 7

31. Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color.

What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

96.46%

95.12%

97.12%

99.46%

32. For Bullet Graphs we need at least ____________ measures

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

True

False

34. Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK).

For the University of Manchester, what percent of the total publications were contributed in 2014?

28.415%

23.497%

25.683%

22.404%

35. Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?

YES, we can do this with the help of a plugin

NO, this is not currently possible in Tableau

YES, we can do this with the help of a Web-Page object

YES, we can do this with the help of Tableau Public

36. True or False:

The Highlighting action can be disabled for the entire workbook.

True

False

37. True or False: Tableau can create worksheet-specific filters

True

False

38. Which of the following chart type makes use of 'binned' data?

Gantt Chart

Bullet chart

Histogram

Treemaps

39. Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.

How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

40. Which data type in Tableau does this icon represent?

Larger image

String

True or False

Boolean

Geographic

Page 5 of 7

41. Dates in Tableau are typically treated as ______________

Dimensions

Measures

42. Larger image

What is this entire view referred to as in Tableau?

Data pane

Analytics Pane

Summary Pane

Distribution Pane

43. True or False: Bins can be created on dimensions

False

rue

44. ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do 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, adding groups, and so on.

.tbm

.tds

.tde

.twb

45. When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Discrete

Fading

Continuous

Mixed

46. How do you identify a continuous field in Tableau?

It is identified by a blue pill in the visualization

It is identified by a green pill in a visualization

It is preceded by a '=#' symbol in the data window

It is preceded by a 'Abc' symbol in the data window

47. 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

48. ________________ is hosted by Tableau to share our visualisations publically with the world.

Tableau Reader

Tableau Desktop

Tableau Server

Tableau Public

49. When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Red, Blue

Orange, Blue

Blue, Red

Blue, Orange

50. What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

No difference, calculated fields cannot be created in Blends

Fields used in Blends must first be aggregated

The calculated fields created in Blends cannot be edited once created

The calculated fields created in Blends cannot use more than 2 fields

Page 6 of 7

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

52. By definition, Tableau displays measures over time as a ____________

Packed Bubble

Bar

Stacked Bar

Line

53. When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Regex Search

Union Search

Pattern Search

Wildcard Search

54. In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

top left bottom left

top right, bottom right

top left, bottom right

top right, bottom left

55. Which of the following are the options to export the data used to build the view / visualisations?

CSV file

PDF File

JSON format

MS Access Database

56. A field that shows average home values for the United States in 2016 is most likely :

A discrete date part dimension

A continuous date value dimension

A geographical dimension

An aggregated measure

57. You can use the __________________ in Tableau to clean / organise your data.

Data cleaner

Data manager

Data interpreter

Data organiser

58. 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

59. Which of the following can you add a reference line to?

Groups

Calculated Fields

Measures

Dimensions

60. Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan.

What was the average Quantity in the State of Tokyo?

3.000

3.840

3.704

3.500

Page 7 of 7

61. How would you calculate GDP per capita in Tableau?

SUM([GDP]/[POPULATION])

SUM([Population]/[GDP]])

SUM([GDP]*[POPULATION])

SUM([GDP]) / SUM([Population])

Desktop Specialist Tableau Free Online Dumps

Author