Online Desktop-Specialist Test Brain Dump Question and Test Engine
Real Tableau Desktop-Specialist Exam Dumps with Correct 150 Questions and Answers
To prepare for the exam, candidates can take advantage of Tableau's extensive training resources, including online courses, practice exams, and study guides. These resources are designed to help candidates master the skills and knowledge required to pass the exam and become certified Tableau Desktop Specialists.
NEW QUESTION # 17
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?
- A. Context Filter
- B. Extract Filter
- C. Data source Filter
- D. None of the these
Answer: A
Explanation:
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.
NEW QUESTION # 18
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A. union
- B. concatenate
- C. join
- D. blend
Answer: A
Explanation:
Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."
A union of these tables creates the following single table that contains all rows from all tables.
NEW QUESTION # 19
Which of the following is not a Trend Line Model?
- A. Logarithmic Trend Line
- B. Exponential Trend Line
- C. Linear Trend Line
- D. binomial Trend Line
Answer: A
Explanation:
Explanation
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:
For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
NEW QUESTION # 20
How can you change the default Tableau repository location?
- A. By clicking on Help -> Change Repository Location
- B. By clicking on Window -> Repository Location
- C. By Moving the repository location manually to wherever we want
- D. By clicking on File -> Repository Location and choosing a new location
Answer: C
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION # 21
True or False : Bins can be created on dimensions
- A. False
- B. rue
Answer: B
Explanation:
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
NEW QUESTION # 22
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. parameters
- B. duplicates
- C. aliases
- D. copies
Answer: C
Explanation:
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
NEW QUESTION # 23
Larger image
What is this entire view referred to as in Tableau?
- A. Analytics Pane
- B. Data pane
- C. Distribution Pane
- D. Summary Pane
Answer: A
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION # 24
What does the box in a box plot represent?
- A. Maximum value of the data
- B. Minimum value of the data
- C. The median of the middle half of the data points
- D. The interquartile range
Answer: D
Explanation:
Explanation
In a box and whisker plot:
1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range
2) The median is marked by a vertical line inside the box
3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
NEW QUESTION # 25
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
- A. Blending
- B. Unioning
- C. Combining
- D. Joining
Answer: B
Explanation:
Explanation
Unioning is the correct answer!
From the official documentation:
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."
NEW QUESTION # 26
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. Topological
- D. Hierarchical
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 # 27
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.
- A. Local Name, Actual Name
- B. Remote Field Name, Field Name
- C. Column Name, Actual Name
- D. Local Field, Global Field
Answer: B
Explanation:
Explanation
Using the Sample superstore as a reference, click on the manage metadata icon as follows:
We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:
Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source.
The remote field name let's us see what the name of the column is in the ORIGINAL Data source.
NEW QUESTION # 28
How can you format an axis as Bold in Tableau?
- A. By choosing the axis and selecting Command/Control + B on your keyboard
- B. By right clicking on the axis, choosing format, and then setting its font to bold.
- 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: B
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 # 29
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?
- A. 0
- B. 1
- C. Correct)
- D. 2
- E. 3
Answer: D
Explanation:
Explanation
Follow along the steps below:
* Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:
NEW QUESTION # 30
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Calculated Fields
- C. Measure Names
- D. Number of Records
Answer: A,C
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 # 31
What is the minimum amount of RAM recommended for any production use of Tableau Server?
- A. 64GB
- B. 8GB
- C. 16GB
- D. 32GB
Answer: D
Explanation:
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.
NEW QUESTION # 32
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. 112,256
- C. 1,222
- D. 111,060
Answer: B
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 # 33
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?
- A. 3.000
- B. 3.840
- C. 3.704
- D. 3.500
Answer: C
Explanation:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.
2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:
Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)
NEW QUESTION # 34
Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
- A. 416,702
- B. 293,202
- C. 336,908
- D. 592,593
Answer: A
Explanation:
Explanation
Since you need BOTH State and the YEAR, we need to use an Inner Join.
Follow the steps below:
NEW QUESTION # 35
......
Tableau Desktop-Specialist Certification Exam covers a wide range of topics that include connecting to and preparing data, creating charts and graphs, and analyzing data using Tableau Desktop. Desktop-Specialist exam also evaluates an individual's knowledge of advanced features such as organizing data, creating calculated fields, and using data blending. Tableau Desktop Specialist Exam certification exam is designed to test an individual's ability to work with different data sources, including spreadsheets, databases, and cloud-based systems. Desktop-Specialist exam also evaluates an individual's ability to create interactive dashboards and reports that can be shared with others. With the Tableau Desktop-Specialist Certification, individuals can showcase their expertise in Tableau Desktop and gain an edge in today's competitive job market.
Valid Desktop-Specialist Test Answers & Tableau Desktop-Specialist Exam PDF: https://www.newpassleader.com/Tableau/Desktop-Specialist-exam-preparation-materials.html
Tableau Desktop-Specialist Certification Real 2023 Mock Exam: https://drive.google.com/open?id=1rCvRSYmrnW05WC6sx8gSAoLKwQkBegBi