[Jan-2022] Tableau Desktop Specialist Desktop-Specialist Exam Practice Test Questions Dumps Bundle!
2022 Updated Desktop-Specialist PDF for the Desktop-Specialist Tests Free Updated Today!
For more info read reference:
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 13
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. June
- D. October
Answer: D
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 14
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 Analysis in the Menu bar and choose Show Mark Labels
- C. Click on Data in the Menu bar and Choose Show Mark Labels
- D. Click on the Show mark labels icon in the Toolbar
Answer: A,B,D
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 15
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. Pattern Search
- B. Regex Search
- C. Union Search
- D. Wildcard Search
Answer: D
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 16
For creating variable sized bins we use __________________
- A. Calculated Fields
- B. Table Calculations
- C. Groups
- D. Sets
Answer: A
Explanation:
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:
NEW QUESTION 17
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. 111,060
- B. 112,256
- C. 1,461
- D. 1,222
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 18
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 5,000
- B. 15,000
- C. 10,000
- D. 20,000
Answer: C
Explanation:
Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.
Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm
NEW QUESTION 19
Which of the following is a good reason for using a bullet graph?
- A. Forecasting future sales
- B. Displaying the year-on-year growth in sales
- C. Comparing the actual sales against the target sales
- D. Analysing the trend over a given time period
Answer: C
Explanation:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.
NEW QUESTION 20
Which data type in Tableau does this icon represent?
Larger image
- A. True or False
- B. String
- C. Boolean
- D. Geographic
Answer: D
Explanation:
Explanation
The following is the table for the data types in Tableau along with their icons:
NEW QUESTION 21
Which of the following returns the Absolute Value of a given number?
- A. ABS(Number)
- B. CEILING(Number)
- C. ZN(Number)
- D. FLOOR(Number)
Answer: A
Explanation:
Explanation
From the official Tableau website:
NEW QUESTION 22
_________________ 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 segregation
- B. Union
- C. Data Joining
- D. Data Blending
Answer: D
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 23
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Numbers and Headers
- B. Labels and Values
- C. Dimensions and Measures
- D. Rows and Columns
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.
Further,
NEW QUESTION 24
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
- A. Trick question! It is not possible to group by labels.
- B. The colours of the members selected are now the same, and different for the rest of the members.
- C. A new mark (bar) is created, which consolidates all members of the group.
- D. Nothing changes in the view, but a group is created in the Dimensions shelf.
Answer: C
Explanation:
Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:
Then on grouping, a new bar is created, and the colour of all bars remain the same.
Had we grouped by choosing the marks instead of the labels, the following would be the result:
NEW QUESTION 25
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Workbook (.twb)
- B. Tableau Data Source (.tds)
- C. Tableau Packaged Workbook (.twbx)
- D. Tableau Data Extract (.tde)
Answer: D
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 26
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A. Phone, Tablet, Laptop, Desktop
- B. Monitor, Default, Phone, Tablet
- C. Phone, Monitor, Laptop, Default
- D. Default, Phone, Tablet, Desktop
Answer: C
Explanation:
Explanation
The following options are available in the Device preview section when creating a Dashboard:
NEW QUESTION 27
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.704
- B. 3.500
- C. 3.840
- D. 3.000
Answer: A
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 28
Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)
- A. 4.87
- B. 76.25
- C. 68.77
- D. 65.67
Answer: B
Explanation:
Explanation
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:
2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:
3) Now, let's create a dashboard, and use both these sheets in it:
4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:
Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
NEW QUESTION 29
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
- A. Tableau myServer
- B. Tableau Public
- C. Tableau Server
- D. Tableau Prep
Answer: A
Explanation:
Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
NEW QUESTION 30
By definition, Tableau displays measures over time as a ____________
- A. Packed Bubble
- B. Bar
- C. Line
- D. Stacked Bar
Answer: C
Explanation:
Explanation
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Please refer to the images below:
NEW QUESTION 31
......
Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Certification Path
Exam Training teaches you how to interpret test questions and how long you will be absent from class.Our Readiness for Examination: Tableau Certified Solutions Architect â A training class in the class room or engaging in a physical or virtual classroom with Tableau Approved Learner is provided in different formats. Free digital training for learning whenever needed. The course reviews sample questions in each subject and how the tested subjects are to be learned and makes it possible to prevent incorrect responses. Find the best selection for you.
Experience of Tableau in computation, networking, storage and database applications Practical experience in Tableau deployment and operating systems The ability of Tableau-based software to identify and establish functional criteria. The opportunity to define which Tableau systems meet specific technical requirements. Knowledge of recommended best practices for secure and effective Tableau platform implementations. Understanding Tableau Cloud’s main architectural tenets. Tableau worldwide understanding of infrastructure. An awareness of network infrastructure relevant to Tableau. Understand the safety features and services of Tableau and its links to traditional providers.
Fully Updated Dumps PDF - Latest Desktop-Specialist Exam Questions and Answers: https://www.braindumpquiz.com/Desktop-Specialist-exam-material.html
100% Free Desktop-Specialist Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1vIa5uH1VvkKkZN0AlatwkAavCc_bUKW0