[Dec 06, 2021] Tableau Desktop-Specialist Real Exam Questions and Answers FREE
Pass Tableau Desktop-Specialist Exam Info and Free Practice Test
How much Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Cost
The cost of the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is $150. For more information related to exam prices, please visit the official website Tableau Website as the cost of exams may be subjected to vary county-wise.
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
NEW QUESTION 48
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 49
What does it imply if a field has a blue background?
- A. It is continuous
- B. It is discrete
- C. It is a dimension
- D. It is a measure
Answer: B
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 50
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):
Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
NEW QUESTION 51
Which of the following is NOT a valid official data source in Tableau Desktop?
- A. Google Firebase
- B. Amazon Redshift
- C. SAP HANA
- D. PostgreSQL
Answer: B
Explanation:
Explanation
Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.
A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.
But then again, it is a workaround and not an official out-of-the-box solution.
The following are the available Data sources available as of now:
* Server
* File
NEW QUESTION 52
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Binders
- B. Labels
- C. Envelopes
- D. Fasteners
Answer: D
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 53
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. (Correct)
- B. $33,768
- C. $48,115
- D. $16,581
- E. $147,950
Answer: D
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 54
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Packaged Workbook (.twbx)
- B. Tableau Data Extract (.tde)
- C. Tableau Workbook (.twb)
- D. Tableau Data Source (.tds)
Answer: B
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 55
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. October
- B. July
- C. June
- D. September
Answer: A
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:
NEW QUESTION 56
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Measure Names
- C. Number of Records
- D. Calculated Fields
Answer: A,B
Explanation:
Explanation
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
NEW QUESTION 57
Is SUM a table calculation?
- A. Yes
- B. No
Answer: B
Explanation:
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!
NEW QUESTION 58
Are animations enabled by default in Tableau?
- A. Yes
- B. No
Answer: B
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 59
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Manual
- B. Random
- C. Hierarchical
- D. Topological
Answer: A
Explanation:
Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:
NEW QUESTION 60
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?
- A. 1,461
- B. 111,060
- C. 1,222
- D. 112,256
Answer: D
Explanation:
Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!
* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October
NEW QUESTION 61
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. True
- B. False
Answer: A
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 62
For a relative date filter, the default anchor is _________________
- A. The date we specify
- B. Today's date
- C. The target date
- D. The current time
Answer: C
Explanation:
Explanation
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.
Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.
Here, you can clearly see that the default date is TODAY
NEW QUESTION 63
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?
- A. If we want a static view of the visualisation.
- B. If we want to use filters in the visualisation.
- C. If we want to dynamically enter parameters to the visualisation.
- D. If we want to interact with the visualisation.
Answer: A
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 64
How can you format numbers in Tableau as currency?
- A. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 65
How can you format an axis as Bold in Tableau?
- A. By right clicking on the axis, choosing format, and then setting its font to bold.
- B. By choosing the axis and selecting Command/Control + B on your keyboard
- C. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
- D. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
Answer: A
Explanation:
Explanation
To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:
None of the other options are valid ways to make the axis bold.
Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm
NEW QUESTION 66
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. Tagged Image File Format (TIFF)
- B. JPEG Image (.JPG, .JPEG)
- C. Windows Bitmap (.BMP)
- D. Portable Network Graphic (.PNG)
Answer: B,C,D
Explanation:
Explanation
The following options are available when an image is Exported:
NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.
NEW QUESTION 67
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
- A. False
- B. rue
Answer: A
Explanation:
Explanation
It is possible in Tableau to use a sheet within a story directly.
Moreover, 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.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
NEW QUESTION 68
The icon associated with the field that has been grouped is a ______________
- A. Paper Clip
- B. Globe
- C. Intersection
- D. =#
Answer: A
Explanation:
Explanation
You can create a group to combine related members in a field. The icon associated with a group is a paper clip!
NEW QUESTION 69
To use a quick table calculation, which of the following programming languages do you need to know?
- A. None of these
- B. Javascript
- C. ython
- D. Java
Answer: A
Explanation:
Explanation
You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.
The visualization updates to look like this:
Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.
NEW QUESTION 70
What term is used to describe the following picture?
- A. Hierarchy
- B. Larger image
- C. Parameter
- D. Set
- E. Group
Answer: D
Explanation:
Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.
NEW QUESTION 71
How does Tableau know at which level to aggregate values?
- A. Aggregation is always done by using Tableau special formulas
- B. Tableau doesn't aggregate values, we do!
- C. Values are always aggregated at the level of granularity of the worksheet.
- D. Values are always aggregated at the level of the Date Part
Answer: C
Explanation:
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:
NEW QUESTION 72
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?
- A. United Kingdom
- B. France
- C. Canada
- D. United States
Answer: B
Explanation:
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
NEW QUESTION 73
......
Latest Desktop-Specialist Exam Dumps Tableau Exam: https://prep4sure.dumpexams.com/Desktop-Specialist-vce-torrent.html