Dumps of Desktop-Specialist Cover all the requirements of the Real Exam

Correct Practice Tests of Desktop-Specialist Dumps with Practice Exam

NEW QUESTION 47
What will the following function return?
LEFT("Tableau", 3)

• A. Tab
• B. eau
• C. ble
• D. An error

Answer: D

Explanation:
Explanation
The following is the official documentation for the String function LEFT:

 

NEW QUESTION 48
What is the minimum amount of RAM recommended for any production use of Tableau Server?

• A. 64GB
• B. 32GB
• C. 8GB
• D. 16GB

Answer: B

Explanation:
Explanation
The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.
These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

 

NEW QUESTION 49
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

• A. Sets
• B. Parameters
• C. Calculation
• D. Groups

Answer: B

Explanation:
Explanation
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter.
Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -

 

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

• A. Sets
• B. Union
• C. Grouping
• D. Clustering

Answer: D

Explanation:
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.

 

NEW QUESTION 51
________________ 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.

• A. .tds
• B. .tde
• C. .twb
• D. .tbm

Answer: A

Explanation:
Explanation
According to the official Tableau documentation:
Tableau data source files have the .tds file extension. Data source 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. For more information, see Save Data Sources.

 

NEW QUESTION 52
Which of the following are valid ways of Grouping Data?

• A. Using Marks in the view
• B. From the Dimensions Shelf
• C. Using Labels in the View
• D. From the Analytics Pane

Answer: A,B,C

Explanation:
Explanation
**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:

Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:

They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):

Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:

Finally, we can group directly from the Dimensions shelf as follows:

Now choose Phones, Chairs and Storage and Click Group:

You will now automatically have a new Dimension as follows:

 

NEW QUESTION 53
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

• A. top left, bottom right
• B. top right, bottom left
• C. top right, bottom right
• D. top left bottom left

Answer: B

Explanation:
Explanation
Tree maps size begins from maximum in top left to smallest in bottom right.

See below to learn how to create a TreeMap and add colours to it:

 

NEW QUESTION 54
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

• A. The colours of the members selected are now the same, and different for the rest of the members.
• B. A new mark (bar) is created, which consolidates all members of the group.
• C. Nothing changes in the view, but a group is created in the Dimensions shelf.
• D. Trick question! It is not possible to group by labels.

Answer: B

Explanation:
Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:

Then on grouping, a new bar is created, and the colour of all bars remain the same.

Had we grouped by choosing the marks instead of the labels, the following would be the result:

 

NEW QUESTION 55
Which Sub-Category had the least Profit in the Office Supplies category?

• A. Binders
• B. Envelopes
• C. Fasteners
• D. Labels

Answer: C

Explanation:
Explanation
To reach the correct answer, follow the steps below:

1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'

As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!

 

NEW QUESTION 56
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?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

Explanation:
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 )

 

NEW QUESTION 57
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.

• A. Wildcard Search
• B. Pattern Search
• C. Union Search
• D. Regex Search

Answer: A

Explanation:
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.

 

NEW QUESTION 58
Which of the following is a benefit of using a Tableau Data Source (.tds)?

• A. 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
• B. To hold one or more worksheets, plus zero or more dashboards and stories.
• C. 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.
• D. 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.

Answer: A

Explanation:
Explanation
The following are the official definitions from the Tableau documentation for the various file types:
1) .tds (Tableau Data Source) - 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. (CORRECT ANSWER)
2) .twbx ( Tableau packaged workbook) - 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.
3) Extract (.hyper or .tde) - 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.
3) (.twb) Workbooks - To hold one or more worksheets, plus zero or more dashboards and stories.

 

NEW QUESTION 59
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

• A. 2 , 2
• B. 2 , 3
• C. 1 , 4
• D. 1 , 2

Answer: C

Explanation:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)

 

NEW QUESTION 60
How can you format an axis as Bold in Tableau?

• A. By choosing the axis and selecting Command/Control + B on your keyboard
• B. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
• C. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
• D. By right clicking on the axis, choosing format, and then setting its font to bold.

Answer: D

Explanation:
Explanation
To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:

None of the other options are valid ways to make the axis bold.

Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm

 

NEW QUESTION 61
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?

• A. July
• B. October
• C. September
• D. June

Answer: B

Explanation:
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:

 

NEW QUESTION 62
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

• A. 112,256
• B. 1,222
• C. 1,461
• D. 111,060

Answer: A

Explanation:
Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!


* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

 

NEW QUESTION 63
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

• A. Fields used in Blends must first be aggregated
• B. The calculated fields created in Blends cannot be edited once created
• C. The calculated fields created in Blends cannot use more than 2 fields
• D. No difference, calculated fields cannot be created in Blends

Answer: A

Explanation:
Explanation
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:


In addition to handling calculations slightly differently, there are some limitations on secondary data sources.
You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.

 

NEW QUESTION 64
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.

• A. rue
• B. False

Answer: B

Explanation:
Explanation
It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

 

NEW QUESTION 65
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

• A. Tableau Data Extract (.tde)
• B. Tableau Packaged Workbook (.twbx)
• C. Tableau Data Source (.tds)
• D. Tableau Workbook (.twb)

Answer: A

Explanation:
Explanation
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.
When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

 

NEW QUESTION 66
Which of the following chart type makes use of 'binned' data?

• A. Treemaps
• B. Gantt Chart
• C. Histogram
• D. Bullet chart

Answer: C

Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

 

NEW QUESTION 67
Is it possible to make a Measure discrete?

• A. Yes
• B. No

Answer: A

Explanation:
Explanation
Of course! Follow along:
Right click on any measure, and choose Discrete as shown:

Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

 

NEW QUESTION 68
For a relative date filter, the default anchor is _________________

• A. Today's date
• B. The target date
• C. The current time
• D. The date we specify

Answer: B

Explanation:
Explanation
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

 

NEW QUESTION 69
Which of the following returns the Absolute Value of a given number?

• A. FLOOR(Number)
• B. ABS(Number)
• C. CEILING(Number)
• D. ZN(Number)

Answer: B

Explanation:
Explanation
From the official Tableau website:

 

NEW QUESTION 70
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. 22.404%
• B. 28.415%
• C. 23.497%
• D. 25.683%

Answer: A

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 71
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

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

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

Sample Questions of Desktop-Specialist Dumps With 100% Exam Passing Guarantee: https://pass4sure.dumptorrent.com/Desktop-Specialist-braindumps-torrent.html