Tableau TDS-C01 Practice Test - Questions Answers, Page 9
List of questions
Question 81

What term is used to describe the following picture?
Explanation:
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.
Question 82

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.
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.
Question 83

__________ is a technique in Tableau which will identify marks with similar characteristics
Explanation:
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
Question 84

Which of the following is the correct way to calculate Profit Ratio in Tableau?
Explanation:
THIS IS A VERY IMPORTANT QUESTION Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid. If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view. In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect! BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't! An example:
Question 85

Which of the following returns the Absolute Value of a given number?
Explanation:
From the official Tableau website:
Question 86

Which of the following 2 columns CANNOT be deleted in Tableau?
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.
Question 87

_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
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.)
Question 88

________________ is hosted by Tableau to share our visualisations publically with the world.
Explanation:
Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public (''vizzes'') can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.
Check it out : https://public.tableau.com/en-us/s/
Question 89

What will the following function return?
LEFT('Tableau', 3)
Explanation:
The following is the official documentation for the String function LEFT:
Question 90

The row and column shelves contain ___________________
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:
Question