IT Certification Exam Questions & Answers

[UPDATED 2022] Getting Desktop-Specialist Certification Made Easy!

Desktop-Specialist Exam Crack Test Engine Dumps Training With 150 Questions

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

To apply for the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam, You have to follow these steps:

• Step 1: Go to the Tableau-Solutions-Architect-Professional Official Site
• Step 2: Read the instruction carefully
• Step 3: Follow the given steps
• Step 4: Apply for the Tableau-Solutions-Architect-Professional Exam

Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Certification Path

Exam Training teaches you how to interpret test questions and how long you will be absent from class.Our Readiness for Examination: Tableau Certified Solutions Architect – A training class in the class room or engaging in a physical or virtual classroom with Tableau Approved Learner is provided in different formats. Free digital training for learning whenever needed. The course reviews sample questions in each subject and how the tested subjects are to be learned and makes it possible to prevent incorrect responses. Find the best selection for you.

Experience of Tableau in computation, networking, storage and database applications Practical experience in Tableau deployment and operating systems
The ability of Tableau-based software to identify and establish functional criteria. The opportunity to define which Tableau systems meet specific technical requirements. Knowledge of recommended best practices for secure and effective Tableau platform implementations. Understanding Tableau Cloud’s main architectural tenets. Tableau worldwide understanding of infrastructure. An awareness of network infrastructure relevant to Tableau. Understand the safety features and services of Tableau and its links to traditional providers.

Topics of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam

Candidates must know the exam topics before they start preparation. Because it will help them to hit the core. Tableau Desktop Specialist exam tests will include the following topics:
1 Design for Organizational Complexity

• Determine how to design networks for complex organizations (for example, an organization with varying compliance requirements, multiple business units, and varying scalability requirements)
• Select migration tools and/or services for new and migrated solutions based on detailed Tableau knowledge
• Determine how to design a multi-account Tableau environment for complex organizations (for example, an organization with varying compliance requirements, multiple business units, and varying scalability requirements)
  2 Design for New Solutions
• Identify opportunities to reduce cost in an existing solution
  5 Continuous Improvement for Existing Solutions
• Determine a solution design to ensure business continuity
• Determine how to improve the deployment of an existing solution
• Determine a strategy to improve the reliability of an existing solution
• Determine a deployment strategy to meet business requirements when designing and implementing a solution
  3 Migration Planning
• Determine a strategy to improve the performance of an existing solution
• Determine cross-account authentication and access strategy for complex organizations (for example,
  an organization with varying compliance requirements, multiple business units, and varying scalability
  requirements)
• Determine a new cloud architecture for an existing solution
• Determine which controls to design and implement that will ensure cost optimization
• Determine a solution design and implementation strategy to meet reliability requirements
• Select a cost-effective pricing model for a solution
• Determine a solution design to meet performance objectives
• Determine a strategy for migrating existing on-premises workloads to the cloud
  4 Cost Control
• Determine a strategy to improve the security of an existing solution
• Determine security requirements and controls when designing and implementing a solution
• Determine a strategy to improve an existing solution for operational excellence

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

Q88. True or False: It is possible to add a field to more than one hierarchy

 True

 False

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

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

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

Q91. True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

 True

 False

Explanation
Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.
To disaggregate all measures in the view:
Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.

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

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

Q94. True or False: Trend lines can only be used with numeric or date fields

 True

 False

Explanation
You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

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

Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm

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

Q97. Is SUM a table calculation?

 Yes

 No

Explanation
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile


These can be calculated using : Table(across), Cell, or Specific dimensions!

Q98. DOWNLOAD THE DATASET FROM –
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven’t already from the test instructions page! ) How many different countries are present in the dataset?

 150

 147

 140

 156

Explanation
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop – 147 marks!

2) Or, you can simply go to Data Source -> Country Tab -> Describe


As you can see, 147 members exist in this Country column!

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

Q100. Which of the following can you use to create a Histogram?

 2 measures

 1 measure

 2 dimensions

 1 dimension

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.
The basic building blocks for a histogram are as follows:


Demo :

Q101. How can you MANUALLY assign geographic roles to a dimension from the data pane?

 Edit the config file in My Documents -> MyTableauRepository for a quick fix

 Right click it -> Geographic role -> and then assign the appropriate geographic role

 Edit the data source manually for a quick resolution

 Right click it -> Edit Default properties -> Assign geographic roles

Explanation
From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:

Q102. How does Tableau know at which level to aggregate values?

 Values are always aggregated at the level of granularity of the worksheet.

 Tableau doesn’t aggregate values, we do!

 Values are always aggregated at the level of the Date Part

 Aggregation is always done by using Tableau special formulas

Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure’s name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:

Q103. Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

 76.25

 65.67

 68.77

 4.87

Explanation
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

2) Now, for sheet 2 – Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:


3) Now, let’s create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

Q104. What is the one most important thing you should do after creating a Dual-axis chart?

 Synchronise the axis

 Change the colours

 Edit the labels

 Hide the axis

Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

Q105. What is the minimum amount of RAM recommended for any production use of Tableau Server?

 8GB

 16GB

 32GB

 64GB

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.

Q106. Which of the following are valid ways to trigger actions for a Dashboard?

 Hover

 Click

 Select

 Menu

 Double click

Explanation
Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways:
1) Select
2) Hover
3) Menu
Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)

 Loading …

Desktop-Specialist Exam Dumps Contains FREE Real Quesions from the Actual Exam: https://www.it-tests.com/Desktop-Specialist.html

         

Related Links: myportal.utt.edu.tt myportal.utt.edu.tt myportal.utt.edu.tt www.stes.tyc.edu.tw myportal.utt.edu.tt www.stes.tyc.edu.tw