ExamGecko
Home / Tableau / TDS-C01 / List of questions
Ask Question

Tableau TDS-C01 Practice Test - Questions Answers, Page 20

List of questions

Question 191

Report
Export
Collapse

When field names in the Union do not match, then:

An error is raised and both fields are dropped from the resulting Union
An error is raised and both fields are dropped from the resulting Union
Only one field name is present in the Union with null values
Only one field name is present in the Union with null values
Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch
Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch
Both field names are present in the Union, but contain several null values
Both field names are present in the Union, but contain several null values
Suggested answer: D

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.'

Tableau TDS-C01 image Question 191 explanation 76534 09232024004744000000

A union of these tables creates the following single table that contains all rows from all tables.

Tableau TDS-C01 image Question 191 explanation 76534 09232024004744000000

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.'

Tableau TDS-C01 image Question 191 explanation 76534 09232024004744000000

Tableau TDS-C01 image Question 191 explanation 76534 09232024004744000000

asked 23/09/2024
Piyush Zope
41 questions

Question 192

Report
Export
Collapse

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

.tds
.tds
.tdex
.tdex
.hyper
.hyper
.twbx
.twbx
Suggested answer: C

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.

asked 23/09/2024
Unai M
39 questions

Question 193

Report
Export
Collapse

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?

By dragging another dimension to the Rows shelf
By dragging another dimension to the Rows shelf
By dragging another measure to Color on the Marks card
By dragging another measure to Color on the Marks card
By dragging another dimension to Color on the Marks card
By dragging another dimension to Color on the Marks card
By dragging another measure to the Columns shelf
By dragging another measure to the Columns shelf
Suggested answer: C

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.

Tableau TDS-C01 image Question 193 explanation 76536 09232024004744000000

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.

Tableau TDS-C01 image Question 193 explanation 76536 09232024004744000000

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.

asked 23/09/2024
Emily Luijten
46 questions

Question 194

Report
Export
Collapse

In which of the following scenarios would having a live connection be more beneficial than using an extract?

Analyzing real time stock prices
Analyzing real time stock prices
Analyzing real time data from production systems
Analyzing real time data from production systems
Analyzing historical housing prices
Analyzing historical housing prices
Analyzing and tracking real time flight updates
Analyzing and tracking real time flight updates
Analyzing a subset of a dataset having 1 billion rows
Analyzing a subset of a dataset having 1 billion rows
Suggested answer: A, B, D

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!

asked 23/09/2024
Sathiyaraj Arulprakasam
47 questions

Question 195

Report
Export
Collapse

What does the following marker/icon do in Tableau?

Tableau TDS-C01 image Question 195 76538 09232024004744000000

Format the Legends
Format the Legends
Edit the Colors
Edit the Colors
Toggle the highlighting on/off.
Toggle the highlighting on/off.
Highlight the largest value
Highlight the largest value
Suggested answer: C

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:

Tableau TDS-C01 image Question 195 explanation 76538 09232024004744000000

Tableau TDS-C01 image Question 195 explanation 76538 09232024004744000000

asked 23/09/2024
aakriti grover
51 questions

Question 196

Report
Export
Collapse

Which of the following sets would you use to compare the members?

None of these
None of these
Dynamic Sets
Dynamic Sets
Static Sets
Static Sets
Combined Sets
Combined Sets
Suggested answer: D

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.

Tableau TDS-C01 image Question 196 explanation 76539 09232024004744000000

Tableau TDS-C01 image Question 196 explanation 76539 09232024004744000000

Tableau TDS-C01 image Question 196 explanation 76539 09232024004744000000

asked 23/09/2024
Keletso Rafedile
34 questions

Question 197

Report
Export
Collapse

Which of the following are True for Measure Names?

It contains all the measures in your data, collected into a single field with continuous values.
It contains all the measures in your data, collected into a single field with continuous values.
When you add it to a view, all of the measure names appear as row or column headers in the view.
When you add it to a view, all of the measure names appear as row or column headers in the view.
When working with a text table showing Profit for each Category, when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves.
When working with a text table showing Profit for each Category, when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves.
It contains the names of all measures in your data, collected into a single field with discrete values.
It contains the names of all measures in your data, collected into a single field with discrete values.
Suggested answer: B, C, D

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.

Tableau TDS-C01 image Question 197 explanation 76540 09232024004744000000

Documentation :https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow_meavalues.htm

asked 23/09/2024
Wissam Aoun
38 questions

Question 198

Report
Export
Collapse

Which of the following are valid use-cases for the 'Manage Metadata' functionality?

To clean and automatically fix the data issues in our data source
To clean and automatically fix the data issues in our data source
To see the field name in the original data source
To see the field name in the original data source
To view all hidden fields
To view all hidden fields
To see the table a field belongs to
To see the table a field belongs to
Suggested answer: B, C, D

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.

Tableau TDS-C01 image Question 198 explanation 76541 09232024004744000000

asked 23/09/2024
Ian Wilson
45 questions

Question 199

Report
Export
Collapse

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

Tableau TDS-C01 image Question 199 76542 09232024004744000000

. Which feature helps us fix this issue?

Replace References
Replace References
Fix Metadata
Fix Metadata
Renaming
Renaming
Aliases
Aliases
Suggested answer: A

Explanation:

Replace References:

Tableau TDS-C01 image Question 199 explanation 76542 09232024004744000000

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

asked 23/09/2024
Thembinkosi Sibiya
34 questions

Question 200

Report
Export
Collapse

True or False:Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.

True
True
False
False
Suggested answer: A

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.

asked 23/09/2024
Chien Fang
40 questions
Total 318 questions
Go to page: of 32