Full Desktop-Specialist Practice Test and 150 unique questions with explanations waiting just for you!
Tableau Desktop Specialist Dumps Desktop-Specialist Exam for Full Questions - Exam Study Guide
NEW QUESTION 76
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?
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. September
- C. October
- D. June
Answer: C
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:
It is clear that October with -55.3% had the lowest Year on Year growth.
NEW QUESTION 77
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient
- A. Geographic Value, Discrete Value
- B. Longitude, Latitude
- C. Continuous Value, Discrete Value
- D. Discrete value, Continuous Value
Answer: D
Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:
NEW QUESTION 78
Which of the following are benefits of using Data Extracts in Tableau?
- A. Working with freshest data at all times
- B. Improved Performance
- C. Ability to use the data offline
- D. Faster to work with
Answer: B,C,D
Explanation:
Explanation
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.
To work with the MOST up-do-date data, use a live connection instead!
NEW QUESTION 79
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?
- A. YES, we can do this with the help of a Web-Page object
- B. YES, we can do this with the help of a plugin
- C. NO, this is not currently possible in Tableau
- D. YES, we can do this with the help of Tableau Public
Answer: A
Explanation:
Explanation
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.
NEW QUESTION 80
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 81
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins
- A. Data Joining
- B. Data Blending
- C. Union
- D. Data segregation
Answer: B
Explanation:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.
According to the official Tableau Documentation:
To read more about Data Blending, click on THIS link.
NEW QUESTION 82
What is the following icon in the Data pane used to do?
Larger image
- A. Sort Data
- B. Extract Data
- C. View Data
- D. Clean Data
Answer: C
Explanation:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
NEW QUESTION 83
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Tom Ashbrook
- B. Penelope Sewall
- C. Sanjit Engle
- D. Tamara Chand
Answer: B
Explanation:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set
2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
c
NEW QUESTION 84
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In My Computer -> C: -> Tableau -> Shapes
- B. In My Documents -> My Tableau Repository -> Shapes
- C. In Downloads -> My Tableau Repository -> Shapes
- D. In Program Files -> Tableau -> Shapes
Answer: B
Explanation:
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.
NEW QUESTION 85
What does it imply if a field has a blue background?
- A. It is continuous
- B. It is a measure
- C. It is discrete
- D. It is a dimension
Answer: C
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
NEW QUESTION 86
True or False: A reference line cannot be added from the Analytics Pane
- A. False
- B. True
Answer: A
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 87
How do you identify a continuous field in Tableau?
- A. It is preceded by a '=#' symbol in the data window
- B. It is identified by a green pill in a visualization
- C. It is preceded by a 'Abc' symbol in the data window
- D. It is identified by a blue pill in the visualization
Answer: A
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
NEW QUESTION 88
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 89
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]) / SUM([Population])
- B. SUM([GDP]*[POPULATION])
- C. SUM([GDP]/[POPULATION])
- D. SUM([Population]/[GDP]])
Answer: A
Explanation:
Explanation
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
NEW QUESTION 90
Which of the following is a valid way to create Sets in Tableau?
- A. In the Data pane, right-click a dimension and select Create > Set.
- B. In the Tableau Main Menu, Choose Worksheet and select Create > Set
- C. In the Tableau Main Menu, choose Dashboard and select Create > Set
- D. In the Data pane, right-click a measure and select Create > Set.
Answer: A
Explanation:
Explanation
There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
To create a dynamic set:
1) In the Data pane, right-click a dimension and select Create > Set.
2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:
General: Use the General tab to select one or more values that will be considered when computing the set.
You can alternatively select the Use all option to always consider all members even when new members are added or removed.
None of the other options exist, and therefore are incorrect answers.
NEW QUESTION 91
Are animations enabled by default in Tableau?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
NEW QUESTION 92
......
Authentic Best resources for Desktop-Specialist Online Practice Exam: https://www.prep4pass.com/Desktop-Specialist_exam-braindumps.html
Get the superior quality Desktop-Specialist Dumps Questions from Prep4pass: https://drive.google.com/open?id=1P78O3gJ3CFjtWVrx9wtq-OSWM4dZQy4q
