Tableau TDS-C01 Practice Test - Questions Answers, Page 20
List of questions
Question 191

When field names in the Union do not match, then:
Explanation:
By default, both field names are present in the Union, but contain several null values!
When field names in the union do not match, fields in the union contain null values.You can merge the non-matching fields into a single field using the merge option to remove the null values.When you use the merge option, the original fields are replaced by a new field that displays thefirstnon-null value for each row in the non-matching fields.
You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.
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.
Now suppose a fourth table, 'August2016', is added to the underlying data. Instead of the standard 'Customer' field name, it contains an abbreviated version called 'Cust.'
Question 192

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.
Explanation:
Beginning in version 10.5, when you create a new extract, it uses the.hyperformat instead of the .tde format.
Extracts in the .hyper format take advantage of the improved data engine, which supports the same fast analytical and query performance as the data engine before it, but foreven larger extracts.
Although there are many benefits of using .hyper extracts, the primary benefits include the following:
1) Create larger extracts:You can create extracts with billions of rows of data. Because .hyper extracts can support more data, you can consolidate .tde extracts that you previously had to create separately into a single .hyper extract.
2) Create and refresh extracts faster:While Tableau has always optimized performance for creating and refreshing extracts, version 2020.3 supports faster extract creation and refreshes for even larger data sets.
3) Experience better performance when interacting with views that use extract data sources:Although smaller extracts continue to perform efficiently, larger extracts perform more efficiently.
Question 193

Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?
Explanation:
Very important question for the exam and appears quite a lot too.
The correct answer is -By dragging another dimension to Color on the Marks card.
This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.
The rest won't create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.
Question 194

In which of the following scenarios would having a live connection be more beneficial than using an extract?
Explanation:
Extractswould be more beneficial for analyzing historical prices where we won't be making use of any real time data being streamed. Same is the case for enormous datasets having billions of rows (extracts will be more efficient in analyzing subsets of such large data).
As forlivestock prices, flight updates, real time updates from production or mission critical systems - having a live connection is the most logical choice, since we need access to the most fresh and recent data possible at all times!
Question 195

What does the following marker/icon do in Tableau?
Explanation:
The correct answer isToggle the highlighting ON/OFF. If selected, whichever value you choose from this legend will be highlighted in the view. However, if it is deselected, then even if you choose a value in the Legend, it will NOTbe highlighted.
See below:
Question 196

Which of the following sets would you use to compare the members?
Explanation:
You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.
Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets.
To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.
Question 197

Which of the following are True for Measure Names?
Explanation:
It contains all the measures in your data, collected into a single field with continuous values -This is the definition for 'Measure Values'.
All others are True w.r.t. Measure Names!
TheMeasure Namesfield contains the names of all measures in your data, collected into a single field with discrete values.
Documentation :https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow_meavalues.htm
Question 198

Which of the following are valid use-cases for the 'Manage Metadata' functionality?
Explanation:
To clean and automatically fix the data issues in our data source -This is the definition of Data Interpreter.
To rename the field in the original data source -We never modify the original data source when managing metadata. All changes are local to Tableau for our convenience only.
All other options can be modified using the Manage Metadata property.
Question 199

When you connect to a new data source, all worksheets that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields are marked with an exclamation point
. Which feature helps us fix this issue?
Explanation:
Replace References:
For example, say you have a workbook connected to a data source that contains a Customer Name field. Then you edit the data source to point to a new data source that has all the same data but instead of Customer Name, the field name has been changed to Name. The Customer Name field remains in the Data pane but is marked as invalid. To make the field valid, you can replace the references, which means you can map the invalid field to a valid field in the new data source (for example, Customer Name corresponds to Name).
Read more at:https://help.tableau.com/current/pro/desktop/en-us/howto_connect.htm
Question 200

True or False:Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.
Explanation:
This is true. aManualSortlets you select a value and move it to the desired position, either by dragging it in the list or using the arrows to the right.
However, as soon as you choose some other type of sort - be it field, nested, or alphabetic, our custom created manual sort gets deleted/cleared.
Question