ExamGecko
Home Home / Tableau / TDS-C01

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

Question list
Search
Search

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

A.
An error is raised and both fields are dropped from the resulting Union
A.
An error is raised and both fields are dropped from the resulting Union
Answers
B.
Only one field name is present in the Union with null values
B.
Only one field name is present in the Union with null values
Answers
C.
Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch
C.
Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch
Answers
D.
Both field names are present in the Union, but contain several null values
D.
Both field names are present in the Union, but contain several null values
Answers
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.'

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

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

A.
.tds
A.
.tds
Answers
B.
.tdex
B.
.tdex
Answers
C.
.hyper
C.
.hyper
Answers
D.
.twbx
D.
.twbx
Answers
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.

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?

A.
By dragging another dimension to the Rows shelf
A.
By dragging another dimension to the Rows shelf
Answers
B.
By dragging another measure to Color on the Marks card
B.
By dragging another measure to Color on the Marks card
Answers
C.
By dragging another dimension to Color on the Marks card
C.
By dragging another dimension to Color on the Marks card
Answers
D.
By dragging another measure to the Columns shelf
D.
By dragging another measure to the Columns shelf
Answers
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.

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.

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

A.
Analyzing real time stock prices
A.
Analyzing real time stock prices
Answers
B.
Analyzing real time data from production systems
B.
Analyzing real time data from production systems
Answers
C.
Analyzing historical housing prices
C.
Analyzing historical housing prices
Answers
D.
Analyzing and tracking real time flight updates
D.
Analyzing and tracking real time flight updates
Answers
E.
Analyzing a subset of a dataset having 1 billion rows
E.
Analyzing a subset of a dataset having 1 billion rows
Answers
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!

What does the following marker/icon do in Tableau?

A.
Format the Legends
A.
Format the Legends
Answers
B.
Edit the Colors
B.
Edit the Colors
Answers
C.
Toggle the highlighting on/off.
C.
Toggle the highlighting on/off.
Answers
D.
Highlight the largest value
D.
Highlight the largest value
Answers
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:

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

A.
None of these
A.
None of these
Answers
B.
Dynamic Sets
B.
Dynamic Sets
Answers
C.
Static Sets
C.
Static Sets
Answers
D.
Combined Sets
D.
Combined Sets
Answers
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.

Which of the following are True for Measure Names?

A.
It contains all the measures in your data, collected into a single field with continuous values.
A.
It contains all the measures in your data, collected into a single field with continuous values.
Answers
B.
When you add it to a view, all of the measure names appear as row or column headers in the view.
B.
When you add it to a view, all of the measure names appear as row or column headers in the view.
Answers
C.
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.
C.
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.
Answers
D.
It contains the names of all measures in your data, collected into a single field with discrete values.
D.
It contains the names of all measures in your data, collected into a single field with discrete values.
Answers
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.

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

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

A.
To clean and automatically fix the data issues in our data source
A.
To clean and automatically fix the data issues in our data source
Answers
B.
To see the field name in the original data source
B.
To see the field name in the original data source
Answers
C.
To view all hidden fields
C.
To view all hidden fields
Answers
D.
To see the table a field belongs to
D.
To see the table a field belongs to
Answers
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.

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?

A.
Replace References
A.
Replace References
Answers
B.
Fix Metadata
B.
Fix Metadata
Answers
C.
Renaming
C.
Renaming
Answers
D.
Aliases
D.
Aliases
Answers
Suggested answer: A

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

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

A.
True
A.
True
Answers
B.
False
B.
False
Answers
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.

Total 318 questions
Go to page: of 32