Updated Sep-2022 Test Engine to Practice Test for Desktop-Specialist Exam Questions and Answers!

Tableau Desktop Specialist Exam Certification Sample Questions and Practice Exam

How to study the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam

A wide variety of Tableau Desktop-Specialist exam dumps have been recognized for qualification concerns for Tableau Certified Developer-Professional Certifications. The fact that students have to study carefully doesn’t facilitate certificates. The training from Tableau Accredited Developer-Professional often takes a long time. Each test contains answers and questions that allow students to pass their final test. After taking and studying our courses, you can pass the exam. But it doesn’t stop there; you can always be successful with your profession thanks to our complete guides. In the future, you will manufacture your own merchandise. We have an innovative approach to preparing some content for you. We also applied the new data to production and commodities.

Introduction to Tableau Desktop-Specialist: Tableau Desktop Specialist Exam

As companies switch employment quickly into the public cloud, cloud storage has become a deep sector. Tableau is regarded as a leader in the field and the most seasoned cloud service as a pioneer in ideas and a benchmark amongst all its adversaries. This transformation requires a range of features for designing, deploying and managing cloud computing services. Get certified Tableau programs with all the credentials (plus top performers) that one of the most successful cloud storage companies will better assess. The credential represents, within the enterprise, a shared network concept, understood terms, and a fundamental degree of cloud experience that can speed up the cloud job assessment. The guidelines below contain the Tableau Architect-Professional Certification Examination, the Tableau Architect/Professional Qualification Pay, and all test facts, such as Tableau Desktop-Specialist practice exams.

Tableau eLearning offers self-running learning modules and a demo for each subject. It is the main resource. We found, however, that most but not all the competencies in the Exam Prep Guide covered the suggested Desktop I: Basic course. In reality, Desktop II has been able to use the following skills: midway through the course – data (included in a joint, mix, or union), create a set, apply a background filter, use bins and histograms, and add a parameter. We have now completed our intermediate level course – but, if you wish, all you can do is take the modules. We suggest you take notice of important principles, such as the distinction between discrete and continuous fields, as you look at the demonstrations. It was also useful to do the analysis exercises .The price of e-learning is USD 10/user per month. To access the activity files, you will also need a personal or technical Tableau Desktop license. If you are a specialist, it is worth asking if they will cover the costs of your preparation, website, and qualification. You can use Tableau eLearning and desktop for free for a year if you have a valid email address from your university.

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

 Sets

 Groups

 Calculation

 Parameters

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 –

Q54. True or False: It is possible to change the Geographic Role of a dimension

 True

 False

Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.

When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles.
If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.

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

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

 True

 False

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.

Q57. _______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

 Tableau Server

 Tableau Prep

 Tableau Public

 Tableau myServer

Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

Q58. The default path for all supporting files, data sources, icons, logs etc is in ______________________

 Documents -> Tableau Files

 Documents -> Tableau

 Documents -> My Tableau Repository

 Downloads -> Tableau Support Files

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

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

Explanation
Unioning is the correct answer!
From the official documentation:

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are “May2016” , “June2016” and “July2016.”

Q60. Which of the following are valid ways to copy a worksheet visualisation as an image?

 By simply clicking Control + V on the keyboard

 By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image

 Using the Marks shelf and choosing Copy->Image

 By right clicking on the worksheet visualisation and selecting Copy->Image

Explanation
The following are 2 correct ways to copy the worksheet visualisation as an image:

AND

Q61. DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven’t already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

 United States

 France

 United Kingdom

 Canada

Explanation
Follow along to get the correct answer:
* Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :
2) But, this isn’t all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:
2.1 As it is (continuous)

2.2 Converting to discrete first & then using it

and then :

3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013

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

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

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:

Q64. Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

 9

 7

 10

 8

Explanation
Follow along to reach the correct answer:
1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:
Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

Q65. For creating variable sized bins we use __________________

 Calculated Fields

 Table Calculations

 Sets

 Groups

Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:

Q66. Which data type in Tableau does this icon represent?
Larger image

 String

 True or False

 Boolean

 Geographic

Explanation
The following is the table for the data types in Tableau along with their icons:

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

 68,620

 74,683

 37,455

 46,493

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:

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

 True

 False

Explanation
Yes, it is possible to create worksheet-specific filters in Tableau.
When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.
Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.

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

 False

 rue

Explanation
Bin are a user-defined grouping of numerical data in the data source.
According to the official Tableau documentation: It’s sometimes useful to convert a continuous measure (or a numeric dimension) into bins.
Have a look at the following image. When we right click a measure, we get the following options:

However, for a dimension (this is because the of this dimension is a string:

But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:

We can clearly create bins from dimensions too – they just have to be numeric 🙂
For more information, please refer to: https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm

Q70. Which of the following are valid ways to add Totals to a view?

 Using the Data Pane

 Using the Analytics Pane

 From the Analysis Tab in the Menu bar on top

 Using the Marks shelf

Explanation
To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

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

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:

Q72. Which of the following charts types always includes bars sorted in descending order?

 Pareto Chart

 Pie Chart

 Gantt Chart

 Stacked Bar Chart

Explanation
A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.
On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.
On the secondary axis, a line graph is used to show the cumulative total in percent format.

 Loading …

Certification dumps Tableau Desktop Specialist Desktop-Specialist guides – 100% valid: https://www.braindumpsit.com/Desktop-Specialist_real-exam.html