Valid Desktop-Specialist Practice Test Dumps with 100% Passing Guarantee [Oct-2022]
Desktop-Specialist PDF Dumps Are Helpful To produce Your Dreams Correct QA's
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 which controls to design and implement that will ensure cost optimization
- Determine a strategy to improve the security of an existing solution
- Determine a strategy to improve an existing solution for operational excellence
- 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 how to improve the deployment of an existing solution
- Identify opportunities to reduce cost in an existing solution 5 Continuous Improvement for Existing Solutions
- 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
- Determine a deployment strategy to meet business requirements when designing and implementing a solution 3 Migration Planning
- Select migration tools and/or services for new and migrated solutions based on detailed Tableau knowledge
- Select existing workloads and processes for a potential migration to the cloud
- Determine a strategy to improve the performance of an existing solution
- Determine a strategy for migrating existing on-premises workloads to the cloud 4 Cost Control
- Troubleshoot solution architectures
- Determine a strategy to improve the reliability of an existing solution
What is the duration, language, and format of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
- Language Exam: English, Japanese, Korean.
- Number of Questions: 65
- Passing score: 72%
- Type of Questions: Multiple choice (MCQs), multiple answers
NEW QUESTION 81
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Workbook (.twb)
- B. Tableau Packaged Workbook (.twbx)
- C. Tableau Data Extract (.tde)
- D. Tableau Bookmark (.tbm)
Answer: B
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 82
True or False: Trend lines can only be used with numeric or date fields
- A. True
- B. False
Answer: B
Explanation:
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.
NEW QUESTION 83
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the of the revenue in the same view!
NEW QUESTION 84
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. Union Search
- C. Regex Search
- D. Pattern 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 85
Dates in Tableau are typically treated as ______________
- A. Dimensions
- B. Measures
Answer: A
Explanation:
Explanation
For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:
When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.
NEW QUESTION 86
True or False: The Highlighting action can be disabled for the entire workbook.
- A. False
- B. True
Answer: B
Explanation:
Explanation
Yes, it is possible to disable highlighting for the entire workbook.
For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
NEW QUESTION 87
True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity
- A. False
- B. True
Answer: B
Explanation:
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.
NEW QUESTION 88
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Drag the measure to the Text label in the Marks Card
- B. Click on the Show mark labels icon in the Toolbar
- C. Click on Analysis in the Menu bar and choose Show Mark Labels
- D. Click on Data in the Menu bar and Choose Show Mark Labels
Answer: A,B,C
Explanation:
Explanation
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let's create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )
2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:
NEW QUESTION 89
True or False: Sets can be created on Measures
- A. True
- B. False
Answer: B
Explanation:
Explanation
Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source.
They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.
Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/
NEW QUESTION 90
Data blending simulates a traditional _________________ Join
- A. Left
- B. Inner
- C. Right
- D. Full Outer
Answer: A
Explanation:
Explanation
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:
NEW QUESTION 91
A field that shows average home values for the United States in 2016 is most likely :
- A. A discrete date part dimension
- B. A continuous date value dimension
- C. An aggregated measure
- D. A geographical dimension
Answer: C
Explanation:
Explanation
This question is directly from the Official Tableau Desktop Specialist exam guide.
Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES.
Date part and Date values don't really make much sense given the question, and neither does geography.
Therefore, the answer naturally is "An aggregated measure".
NEW QUESTION 92
How can you change the default Tableau repository location?
- A. By clicking on Window -> Repository Location
- B. By clicking on File -> Repository Location and choosing a new location
- C. By clicking on Help -> Change Repository Location
- D. By Moving the repository location manually to wherever we want
Answer: D
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 93
True or False: A reference line cannot be added from the Analytics Pane
- A. True
- B. False
Answer: B
Explanation:
Explanation
You can add a reference line to any continuous axis in the view.
To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
In a simple case, the drop target area offers three options:
NEW QUESTION 94
________________ can only create header. _______________ will create header and axis both.
- A. Measures, Dimensions
- B. Dimensions, Measures
- C. Groups, Sets
- D. Dates, Strings
Answer: B
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 95
What is the one most important thing you should do after creating a Dual-axis chart?
- A. Change the colours
- B. Edit the labels
- C. Synchronise the axis
- D. Hide the axis
Answer: C
Explanation:
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.
NEW QUESTION 96
Is it possible to make a Measure discrete?
- A. No
- B. Yes
Answer: B
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 97
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A. False
- B. True
Answer: B
Explanation:
Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
NEW QUESTION 98
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
- A. $16,581
- B. (Correct)
- C. $33,768
- D. $48,115
- E. $147,950
Answer: A
Explanation:
Explanation
Phew! Tricky one! You needed to use filters in this one.
Follow along:
2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :
ii) Next, drag Color to Filters and Choose only White:
iii) Next, drag State ID to Filters, and choose New York (NY):
And Voila! We have our answer as follows:
iv) Last, drag Sales to Label:
NEW QUESTION 99
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Fasteners
- B. Binders
- C. Labels
- D. Envelopes
Answer: A
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 100
Larger image
What is this entire view referred to as in Tableau?
- A. Data pane
- B. Distribution Pane
- C. Summary Pane
- D. Analytics Pane
Answer: D
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION 101
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Single Value (slider)
- B. Multiple Values (dropdown)
- C. Regex Match
- D. Wildcard Match
Answer: C
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION 102
What is a story point in Tableau?
- A. A collection of dashboards
- B. A collection of both worksheets and dashboards
- C. A single worksheet or dashboard
- D. A collection of worksheets
Answer: C
Explanation:
Explanation
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.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.
NEW QUESTION 103
......
Cover Desktop-Specialist Exam Questions Make Sure You 100% Pass: https://www.validvce.com/Desktop-Specialist-exam-collection.html
New Desktop-Specialist exam Free Sample Questions to Practice: https://drive.google.com/open?id=1GNA_ERObcKorXvV5Rvve4kOM363dz-MG
