Try 100% Updated Desktop-Specialist Exam Questions [2023]
Pass Desktop-Specialist Exam - Real Questions and Answers
NEW QUESTION # 13
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. Canada
- C. United States
- D. United Kingdom
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 # 14
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 plugin
- B. NO, this is not currently possible in Tableau
- C. YES, we can do this with the help of Tableau Public
- D. YES, we can do this with the help of a Web-Page object
Answer: D
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 # 15
We can join a maximum of ______ tables in Tableau
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
It is possible to join a maximum of 32 tables in Tableau!
NEW QUESTION # 16
You can use the __________________ in Tableau to clean / organise your data.
- A. Data organiser
- B. Data interpreter
- C. Data manager
- D. Data cleaner
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 # 17
Which of the following is NOT a valid official data source in Tableau Desktop?
- A. Google Firebase
- B. SAP HANA
- C. PostgreSQL
- D. Amazon Redshift
Answer: D
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 # 18
What will the following function return?
LEFT("Tableau", 3)
- A. eau
- B. Tab
- C. An error
- D. ble
Answer: C
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION # 19
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Binders
- B. Labels
- C. Fasteners
- D. Envelopes
Answer: C
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 # 20
Which of the following can you use to create a Histogram?
- A. 1 dimension
- B. 2 dimensions
- C. 2 measures
- D. 1 measure
Answer: D
Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
The basic building blocks for a histogram are as follows:
Demo :
NEW QUESTION # 21
The default path for all supporting files, data sources, icons, logs etc is in ______________________
- A. Downloads -> Tableau Support Files
- B. Documents -> Tableau
- C. Documents -> Tableau Files
- D. Documents -> My Tableau Repository
Answer: D
Explanation:
Explanation
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
NEW QUESTION # 22
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. Wildcard Search
- B. Union Search
- C. Pattern Search
- D. Regex Search
Answer: A
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 # 23
Is it possible to make a Measure discrete?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Of course! Follow along:
Right click on any measure, and choose Discrete as shown:
Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!
NEW QUESTION # 24
Which of the following chart type makes use of 'binned' data?
- A. Histogram
- B. Gantt Chart
- C. Bullet chart
- D. Treemaps
Answer: A
Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
NEW QUESTION # 25
Which one of the following is a dimension?
- A. Measure Names
- B. Longitude
- C. Number of records
- D. Latitude
Answer: A
Explanation:
Explanation
Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.
NEW QUESTION # 26
How do you identify a continuous field in Tableau?
- A. It is identified by a green pill in a visualization
- B. It is preceded by a '=#' symbol in the data window
- C. It is identified by a blue pill in the visualization
- D. It is preceded by a 'Abc' symbol in the data window
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 # 27
True or False: The Highlighting action can be disabled for the entire workbook.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes, it is possible to disable highlighting for the entire workbook.
For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
NEW QUESTION # 28
Which of the following would you use to connect to multiple tables in a single data source at once?
- A. A Set
- B. A Hierarchy
- C. A Blend
- D. A Join
Answer: D
Explanation:
Explanation
The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.
For example, consider the following two tables originating from a single data source:
We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.
NEW QUESTION # 29
How can you change the Default Aggregation for a measure in Tableau?
- A. By double clicking on the measure, and then choosing Window -> Default Aggregation
- B. By right clicking the dimension -> Default properties and choosing Aggregation
- C. By right clicking the measure -> Default properties and choosing Aggregation
- D. By changing its properties manually every time we need to use it
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!
NEW QUESTION # 30
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A. Monitor, Default, Phone, Tablet
- B. Phone, Tablet, Laptop, Desktop
- C. Default, Phone, Tablet, Desktop
- D. Phone, Monitor, Laptop, Default
Answer: D
Explanation:
Explanation
The following options are available in the Device preview section when creating a Dashboard:
NEW QUESTION # 31
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 # 32
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Data Extract (.tde)
- B. Tableau Packaged Workbook (.twbx)
- C. Tableau Bookmark (.tbm)
- D. Tableau Workbook (.twb)
Answer: B
Explanation:
Explanation
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.
3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)
NEW QUESTION # 33
If you see the following Filter, then you're working with _______________________ Larger image
- A. Date Parts
- B. Date Functions
- C. Date Values
- D. Grouped Dates
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 # 34
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
- A. 23.39%
- B. 29.49%
- C. 25.79%
- D. 27.73%
Answer: D
Explanation:
Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:
2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:
3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:
We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:
NEW QUESTION # 35
The row and column shelves contain ___________________
- A. Filters
- B. Parameters
- C. Grand Totals
- D. Pills
Answer: D
Explanation:
Explanation
We can drag fields from the Data pane to create the structure for your visualizations.
The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
These FIELDS are also referred to as PILLS. See below:
NEW QUESTION # 36
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 Data pane, right-click a measure and select Create > Set.
- D. In the Tableau Main Menu, choose Dashboard 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 # 37
......
Desktop-Specialist Exam Questions Get Updated [2023] with Correct Answers: https://www.validbraindumps.com/Desktop-Specialist-exam-prep.html
Free Tableau Desktop-Specialist Test Practice Test Questions Exam Dumps: https://drive.google.com/open?id=1p2XAHMIEWT86CxFm-2FkAcf3e0OpceZe