100% Real Desktop-Specialist dumps – Brilliant Desktop-Specialist Exam Questions PDF [Q31-Q45]

Rate this post

100% Real Desktop-Specialist dumps – Brilliant Desktop-Specialist Exam Questions PDF

Desktop-Specialist Exam PDF [2023] Tests Free Updated Today with Correct 150 Questions

QUESTION 31
Which of the following calculations DO NOT need a quick table calculation?

Variance

Rank

Moving Average

Standard Deviation

Explanation
For Standard Deviation and Variance, we don’t need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

QUESTION 32
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?

Explanation
If you chose 2, then you were very close but probably didn’t plot the actual Percent Difference on your view. ( One of the marks is just over the line).
* Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
* 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

3) This should be your view now. Click on the Show Mark Labels icon as shown:
The final view is as follows, with 3 points below 0 ( i.e negative )

QUESTION 33
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

October

September

July

June

Explanation
Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:

It is clear that October with -55.3% had the lowest Year on Year growth.

QUESTION 34
How can you format numbers in Tableau as currency?

Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.

Explanation
According to the official Tableau documentation:

QUESTION 35
When is an axis created for the visualisation in Tableau?

When we drag a measure to the row/column shelf

When we drag a dimension to the row/column shelf

When we drag a discrete field to the row/column shelf

When we drag a continuous field to the row/column shelf

Explanation
An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.
Example:
In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.

Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).

QUESTION 36
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

To support additional functionality such as count distinct

Fast to create

Help improve performance

To have access to the freshest possible data at all times

Explanation
From the official documentation, the following are the major advantages of using Tableau Data Extracts:

From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!

QUESTION 37
By definition, Tableau displays measures over time as a ____________

Packed Bubble

Bar

Stacked Bar

Line

Explanation
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Please refer to the images below:

QUESTION 38
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

Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance – If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

QUESTION 39
__________ is a technique in Tableau which will identify marks with similar characteristics

Clustering

Grouping

Sets

Union

Explanation
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.

QUESTION 40
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

Explanation
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

QUESTION 41
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

Explanation
After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: 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.
twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.
twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.

QUESTION 42
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don’t allow relationships or joins

Union

Data Joining

Data segregation

Data Blending

Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

According to the official Tableau Documentation:

To read more about Data Blending, click on THIS link.

QUESTION 43
The calculation [Ship Date] – [Order Date] will return _______________

Number of orders placed in that duration

Number of days between these dates

Number of unique orders placed between these dates

Number of orders shipped between these dates

Explanation
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.

QUESTION 44
You want to add Custom shapes to your visualisation. Where can you add these new shapes?

In Downloads -> My Tableau Repository -> Shapes

In My Computer -> C: -> Tableau -> Shapes

In Program Files -> Tableau -> Shapes

In My Documents -> My Tableau Repository -> Shapes

Explanation
Here’s how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your “edit shapes” menu.

QUESTION 45
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data.

.twbx file

.tbm file

.twb file

.tde file

Explanation
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. For more information, see Packaged Workbooks.

Loading …