[Aug-2021] Get 100% Real Desktop-Specialist Exam Questions, Accurate & Verified Lead1Pass Dumps in the Real Exam!
Pass Your Tableau Desktop Specialist Exams Fast. All Top Desktop-Specialist Exam Questions Are Covered.
NEW QUESTION 42
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?
- A. 74,683
- B. 37,455
- C. 46,493
- D. 68,620
Answer: B
Explanation:
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:
NEW QUESTION 43
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
- A. top right, bottom right
- B. top left, bottom right
- C. top right, bottom left
- D. top left bottom left
Answer: C
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 44
_____________ 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 Workbook (.twb)
- D. Tableau Data Source (.tds)
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 45
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 46
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
- A. Tableau Desktop
- B. Tableau Online
- C. Tableau Reader
- D. Tableau Server
Answer: C
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION 47
True or False: It is possible to add a field to more than one hierarchy
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
NEW QUESTION 48
What is a story point in Tableau?
- A. A collection of worksheets
- B. A collection of dashboards
- C. A single worksheet or dashboard
- D. A collection of both worksheets and dashboards
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 49
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
- A. 96.46%
- B. 99.46%
- C. 97.12%
- D. 95.12%
Answer: C
Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :
NEW QUESTION 50
Which of the following would you use to connect to multiple tables in a single data source at once?
- A. A Hierarchy
- B. A Join
- C. A Blend
- D. A Set
Answer: B
Explanation:
Explanation
The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.
For example, consider the following two tables originating from a single data source:
We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.
NEW QUESTION 51
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
- A. Mexico
- B. Argentina
- C. Brazil
- D. Peru
Answer: A
Explanation:
Explanation
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION
1) To find the number of days between order date and shipping date, we will make use of a calculated field:
In the data pane, click on the dropdown arrow, and choose create calculated field.
Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )
2) Use the DATEDIFF() function, and pass it the arguments as follows:
'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is
'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.
Click OK.
3) You should now have a new measure as follows:
4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:
5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you're choosing the Largest value*
Clearly, Mexico has the highest Shipping Delay!
NEW QUESTION 52
The default path for all supporting files, data sources, icons, logs etc is in ______________________
- A. Documents -> Tableau Files
- B. Downloads -> Tableau Support Files
- C. Documents -> My Tableau Repository
- D. Documents -> Tableau
Answer: C
Explanation:
Explanation
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
NEW QUESTION 53
How can you change the default Tableau repository location?
- A. By Moving the repository location manually to wherever we want
- B. By clicking on File -> Repository Location and choosing a new location
- C. By clicking on Help -> Change Repository Location
- D. By clicking on Window -> Repository Location
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 54
________________ can only create header. _______________ will create header and axis both.
- A. Measures, Dimensions
- B. Dates, Strings
- C. Dimensions, Measures
- D. Groups, Sets
Answer: C
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 55
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
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:
NEW QUESTION 56
If you see the following Filter, then you're working with _______________________ Larger image
- A. Date Values
- B. Date Parts
- C. Grouped Dates
- D. Date Functions
Answer: A
Explanation:
Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.
NEW QUESTION 57
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of orders placed in that duration
- B. Number of unique orders placed between these dates
- C. Number of orders shipped between these dates
- D. Number of days between these dates
Answer: D
Explanation:
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.
NEW QUESTION 58
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?
- A. If we want to use filters in the visualisation.
- B. If we want a static view of the visualisation.
- C. If we want to interact with the visualisation.
- D. If we want to dynamically enter parameters to the visualisation.
Answer: B
Explanation:
Explanation
Exporting the visualisation gives us a static view of the visualisation.
It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.
In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.
When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)
NEW QUESTION 59
A field that shows average home values for the United States in 2016 is most likely :
- A. An aggregated measure
- B. A continuous date value dimension
- C. A geographical dimension
- D. A discrete date part dimension
Answer: A
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 60
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.
- A. True
- B. False
Answer: A
Explanation:
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.
NEW QUESTION 61
......
Penetration testers simulate Desktop-Specialist exam: https://www.lead1pass.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Free Test Engine For Tableau Desktop Specialist Exam Certification Exams: https://drive.google.com/open?id=1Cy_pkerBsMb6O3-8qo7gvTEfAI-yrHOx