[Jul 21, 2023] Pass Your Desktop-Specialist Dumps Free Latest Tableau Practice Tests [Q70-Q87]

[Jul 21, 2023] Pass Your Desktop-Specialist Dumps Free Latest Tableau Practice Tests

Get Top-Rated Tableau Desktop-Specialist Exam Dumps Now

For more info read reference:

NEW QUESTION # 70
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.

A. 99.46%
B. 95.12%
C. 96.46%
D. 97.12%

Answer: D

Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :

NEW QUESTION # 71
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

A. Blue, Orange
B. Blue, Red
C. Orange, Blue
D. Red, Blue

Answer: A

Explanation:
Explanation
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:

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

A. dimension, measure
B. type, role
C. role, type
D. Data type, Value

Answer: C

Explanation:
Explanation
When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.
Role can be of the following two types:
1) Dimension
2) Measure
Type can be of the following :
1) String
2) Number
3) Geographic
4) Boolean
5) Date
6) Date and Time

NEW QUESTION # 73
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)?

A. Mexico
B. Argentina
C. Peru
D. Brazil

Answer: A

Explanation:
Explanation
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION
1) To find the number of days between order date and shipping date, we will make use of a calculated field:

In the data pane, click on the dropdown arrow, and choose create calculated field.
Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )
2) Use the DATEDIFF() function, and pass it the arguments as follows:

'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is
'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.
Click OK.
3) You should now have a new measure as follows:

4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:

5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you're choosing the Largest value*

Clearly, Mexico has the highest Shipping Delay!

NEW QUESTION # 74
A Tableau Support case can be opened in which of the following valid ways?

A. Contacting Salesforce using their website
B. Using the Developer Community Forum
C. Using the Tableau learn website
D. Using the support option on the Tableau website

Answer: D

Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case

NEW QUESTION # 75
What term is used to describe the following picture?

A. Group
B. Larger image
C. Parameter
D. Hierarchy
E. Set

Answer: E

Explanation:
Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.

NEW QUESTION # 76
True or False: It is possible to add a field to more than one hierarchy

A. False
B. True

Answer: B

Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

NEW QUESTION # 77
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

A. Tableau Data Extract (.tde)
B. Tableau Bookmark (.tbm)
C. Tableau Packaged Workbook (.twbx)
D. Tableau Workbook (.twb)

Answer: C

Explanation:
Explanation
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.

3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)

NEW QUESTION # 78
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________

A. Labels and Values
B. Numbers and Headers
C. Dimensions and Measures
D. Rows and Columns

Answer: C

Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
Further,

NEW QUESTION # 79
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?

A. 25.683%
B. 22.404%
C. 28.415%
D. 23.497%

Answer: B

Explanation:
Explanation
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.
Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:

NEW QUESTION # 80
The default path for all supporting files, data sources, icons, logs etc is in ______________________

A. Downloads -> Tableau Support Files
B. Documents -> My Tableau Repository
C. Documents -> Tableau Files
D. Documents -> Tableau

Answer: B

Explanation:
Explanation
By default, all of the above mentioned are stored in Documents -> My Tableau Repository

NEW QUESTION # 81
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient

A. Geographic Value, Discrete Value
B. Discrete value, Continuous Value
C. Longitude, Latitude
D. Continuous Value, Discrete Value

Answer: B

Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:

NEW QUESTION # 82
Which of the following is NOT a valid official data source in Tableau Desktop?

A. Amazon Redshift
B. SAP HANA
C. Google Firebase
D. PostgreSQL

Answer: A

Explanation:
Explanation
Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.
A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.
But then again, it is a workaround and not an official out-of-the-box solution.
The following are the available Data sources available as of now:
* Server
* File

NEW QUESTION # 83
________________ can only create header. _______________ will create header and axis both.

A. Groups, Sets
B. Dates, Strings
C. Measures, Dimensions
D. Dimensions, Measures

Answer: D

Explanation:
Explanation
Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):

Now we have the option to edit BOTH the axis and the header.

NEW QUESTION # 84
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

A. Data Pane
B. Marks Card
C. Analytics Pane
D. Filter Shelf

Answer: B

Explanation:
Explanation
The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!

The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.

You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.

In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.
After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.
Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.

NEW QUESTION # 85
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

A. False
B. True

Answer: B

Explanation:
Explanation
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

NEW QUESTION # 86
Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

A. 37,455
B. 74,683
C. 46,493
D. 68,620

Answer: A

Explanation:
Explanation
If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!
To create a dual axis chart for the problem mentioned:
1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is: