Desktop-Specialist Training & Certification Get Latest Tableau Desktop Specialist Updated on Sep 22, 2023
Certification Training for Desktop-Specialist Exam Dumps Test Engine
Tableau Desktop-Specialist Exam is a professional certification exam that evaluates the candidate's proficiency in using Tableau Desktop software for data analysis and visualization. Tableau Desktop Specialist Exam certification is aimed at professionals in the field of business intelligence and data analytics who want to demonstrate their skills and knowledge of Tableau Desktop. Obtaining the certification can enhance the career prospects of professionals in this field and demonstrate their ability to analyze and visualize complex data sets.
NEW QUESTION # 34
Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?
- A. 23.497%
- B. 22.404%
- C. 28.415%
- D. 25.683%
Answer: B
Explanation:
Explanation
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.
Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:
NEW QUESTION # 35
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Calculated Fields
- C. Number of Records
- D. Measure Names
Answer: A,D
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 # 36
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. False
- B. True
Answer: B
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 # 37
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. Correct)
- C. 1
- D. 2
- E. 3
Answer: A
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 # 38
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.840
- B. 3.000
- C. 3.500
- D. 3.704
Answer: D
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 # 39
Which of the following are valid ways to copy a worksheet visualisation as an image?
- A. By right clicking on the worksheet visualisation and selecting Copy->Image
- B. By simply clicking Control + V on the keyboard
- C. By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
- D. Using the Marks shelf and choosing Copy->Image
Answer: A,C
Explanation:
Explanation
The following are 2 correct ways to copy the worksheet visualisation as an image:
AND
NEW QUESTION # 40
What is the following icon in the Data pane used to do?
Larger image
- A. Clean Data
- B. Sort Data
- C. Extract Data
- D. View Data
Answer: D
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 # 41
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A. To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
- B. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
- C. To hold one or more worksheets, plus zero or more dashboards and stories.
- D. To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc
Answer: D
Explanation:
Explanation
The following are the official definitions from the Tableau documentation for the various file types:
1) .tds (Tableau Data Source) - To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc. (CORRECT ANSWER)
2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
3) Extract (.hyper or .tde) - To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
3) (.twb) Workbooks - To hold one or more worksheets, plus zero or more dashboards and stories.
NEW QUESTION # 42
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A. concatenate
- B. union
- C. blend
- D. join
Answer: B
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 # 43
True or False: It is possible to add a field to more than one hierarchy
- A. False
- B. True
Answer: B
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 # 44
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. False
- B. True
Answer: B
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 # 45
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. Regex Search
- B. Pattern Search
- C. Wildcard Search
- D. Union Search
Answer: C
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 # 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 Reader
- C. Tableau Server
- D. Tableau Online
Answer: B
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION # 47
Which of the following charts types always includes bars sorted in descending order?
- A. Pie Chart
- B. Gantt Chart
- C. Pareto Chart
- D. Stacked Bar Chart
Answer: C
Explanation:
Explanation
A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.
On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.
On the secondary axis, a line graph is used to show the cumulative total in percent format.
NEW QUESTION # 48
If you see the following Filter, then you're working with _______________________ Larger image
- A. Date Parts
- B. Grouped Dates
- C. Date Values
- D. Date Functions
Answer: C
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 # 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. 95.12%
- D. 97.12%
Answer: D
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
You can use the __________________ in Tableau to clean / organise your data.
- A. Data organiser
- B. Data interpreter
- C. Data cleaner
- D. Data manager
Answer: B
Explanation:
Explanation
When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.
NEW QUESTION # 51
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. France
- B. United Kingdom
- C. Canada
- D. United States
Answer: A
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 # 52
True or False: It is possible to change the Geographic Role of a dimension
- A. False
- B. True
Answer: B
Explanation:
Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles.
If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.
NEW QUESTION # 53
True or False: To concatenate fields, they must be of same data type
- A. False
- B. True
Answer: B
Explanation:
Explanation
Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use
- Type casting. See below:
Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!
NEW QUESTION # 54
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 # 55
How can you format numbers in Tableau as currency?
- A. Right-click on the data source used 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 a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: D
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION # 56
_____________ 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 Extract (.tde)
- C. Tableau Packaged Workbook (.twbx)
- 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 # 57
......
Step by Step Guide to Prepare for Desktop-Specialist Exam: https://www.validvce.com/Desktop-Specialist-exam-collection.html
Tableau Desktop Specialist Desktop-Specialist Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1GNA_ERObcKorXvV5Rvve4kOM363dz-MG
