Practice Tableau Desktop Specialist Desktop-Specialist exam. Online Exam Practice Tests with detailed explanations! Pass Desktop-Specialist with confidence!
Desktop-Specialist - Tableau Desktop Specialist Exam Practice Tests 2021 | VCEEngine
NEW QUESTION 52
Which of the following would you use to connect to multiple tables in a single data source at once?
- A. A Hierarchy
- B. A Join
- C. A Blend
- D. A Set
Answer: B
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 53
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Random
- B. Hierarchical
- C. Manual
- D. Topological
Answer: C
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 54
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. No
- B. Yes
Answer: B
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 55
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A. True
- B. False
Answer: A
Explanation:
Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
NEW QUESTION 56
True or False: Sets can be created on Measures
- A. False
- B. True
Answer: A
Explanation:
Explanation
Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source.
They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.
Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/
NEW QUESTION 57
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 58
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Workbook (.twb)
- B. Tableau Data Extract (.tde)
- C. Tableau Packaged Workbook (.twbx)
- D. Tableau Bookmark (.tbm)
Answer: C
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 59
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient
- A. Geographic Value, Discrete Value
- B. Longitude, Latitude
- C. Continuous Value, Discrete Value
- D. Discrete value, Continuous Value
Answer: D
Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:
NEW QUESTION 60
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.
- A. .twbx file
- B. .tde file
- C. .tbm file
- D. .twb file
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. For more information, see Packaged Workbooks.
NEW QUESTION 61
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. 97.12%
- D. 95.12%
Answer: C
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 62
For creating variable sized bins we use __________________
- A. Sets
- B. Calculated Fields
- C. Groups
- D. Table Calculations
Answer: B
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 63
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A. 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.
- B. To hold one or more worksheets, plus zero or more dashboards and stories.
- C. 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
- D. 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.
Answer: C
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 64
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In My Computer -> C: -> Tableau -> Shapes
- B. In My Documents -> My Tableau Repository -> Shapes
- C. In Downloads -> My Tableau Repository -> Shapes
- D. In Program Files -> Tableau -> Shapes
Answer: B
Explanation:
Explanation
Here's how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.
NEW QUESTION 65
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. October
- D. June
Answer: C
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 66
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Tom Ashbrook
- B. Penelope Sewall
- C. Sanjit Engle
- D. Tamara Chand
Answer: B
Explanation:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set
2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
c
NEW QUESTION 67
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 68
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 69
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Measure Filter
- B. Extract Filter
- C. Context Filter
- D. Dimension Filter
Answer: B
Explanation:
Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
NEW QUESTION 70
......
Get instant access to Desktop-Specialist practice exam questions: https://drive.google.com/open?id=1eHT4UCbtOCWnyFEE1YpKnsOgMgK-KGmf
The best Desktop-Specialist exam study material and preparation tool is here: https://www.vceengine.com/Desktop-Specialist-vce-test-engine.html
