ExamGecko
Home Home / Tableau / TDS-C01

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

Question list
Search
Search

You need to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age (for example: John Doe, 32).

What should you include in the calculation?

A.
[Customer Name] + ',' + 'STR[Age]''
A.
[Customer Name] + ',' + 'STR[Age]''
Answers
B.
STR([Customer Name]) + ',' STR(''Age')
B.
STR([Customer Name]) + ',' STR(''Age')
Answers
C.
'Customer Name,' + [Age]
C.
'Customer Name,' + [Age]
Answers
D.
[Customer Name] + ',' + STR([Age])
D.
[Customer Name] + ',' + STR([Age])
Answers
Suggested answer: D

Explanation:

According to theTableau Desktop Specialist Exam Readiness, to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age, you should use the formula [Customer Name] + '','' + STR([Age]). This is because you need to concatenate strings using the + operator, and convert the numeric field [Age] to a string using the STR() function.

What are three geographic roles that you can assign to a field? Choose three.

A.
Address
A.
Address
Answers
B.
Time zone
B.
Time zone
Answers
C.
City
C.
City
Answers
D.
Country
D.
Country
Answers
E.
Airport
E.
Airport
Answers
Suggested answer: C, D, E

Explanation:

According to theTableau Desktop Specialist Exam Guide, city, country, and airport are three geographic roles that you can assign to a field. Address and time zone are not geographic roles in Tableau.

Which statement accurately describes a join?

A.
Away to combine multiple Tableau workbooks using similar data sources
A.
Away to combine multiple Tableau workbooks using similar data sources
Answers
B.
A combination of rows appended from different tables that have the same column names
B.
A combination of rows appended from different tables that have the same column names
Answers
C.
Away to combine table columns in relational databases by using shared values
C.
Away to combine table columns in relational databases by using shared values
Answers
D.
A combination of columns appended from different tables that have similar values
D.
A combination of columns appended from different tables that have similar values
Answers
Suggested answer: C

Explanation:

According to the [Tableau Desktop Specialist Exam Guide], a join is a way to combine table columns in relational databases by using shared values. A join can be inner, left, right, or full, depending on how the matching rows are included or excluded.

What are two correct methods to change the data type of a field? Choose two.

A.
From the Data Source tab, click on the drop-down menu of the field.
A.
From the Data Source tab, click on the drop-down menu of the field.
Answers
B.
From the Data pane, click on the drop-down menu of the field.
B.
From the Data pane, click on the drop-down menu of the field.
Answers
C.
From the Data Source tab, click the data type icon of the field.
C.
From the Data Source tab, click the data type icon of the field.
Answers
D.
From the Data pane, select and hold the field.
D.
From the Data pane, select and hold the field.
Answers
Suggested answer: A, C

Explanation:

you can change the data type of a field from the Data Source tab by clicking on the drop-down menu of the field or by clicking the data type icon of the field. You cannot change the data type of a field from the Data pane or by selecting and holding the field.

You have a bar chart that has a dimension on the Columns shelf and a measure on the Rows shelf.

How can you make a stacked bar chart?

A.
Drag another dimension to Color on the Marks card
A.
Drag another dimension to Color on the Marks card
Answers
B.
Drag another measure to Color on the Marks card.
B.
Drag another measure to Color on the Marks card.
Answers
C.
Drag another dimension to Size on the Marks card.
C.
Drag another dimension to Size on the Marks card.
Answers
D.
Drag another measure to the left of the measure on the Rows shelf.
D.
Drag another measure to the left of the measure on the Rows shelf.
Answers
Suggested answer: A

Explanation:

To create a stacked bar chart in Tableau, you can drag a second dimension to the Color shelf onthe Marks card. This action will segment the bars already present in the chart by the newdimension, stacking the segments on top of each other within each bar. This is a commonmethod to add additional layers of detail to a bar chart and effectively compare parts to awhole across categories.

In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.

A.
An incremental refresh only adds rows that are new
A.
An incremental refresh only adds rows that are new
Answers
B.
A full refresh must be configured. An incremental refresh is the default extract in Tableau.
B.
A full refresh must be configured. An incremental refresh is the default extract in Tableau.
Answers
C.
An incremental refresh can only be run from Tableau Server.
C.
An incremental refresh can only be run from Tableau Server.
Answers
D.
A full refresh is usually very slow. An incremental refresh can take less time.
D.
A full refresh is usually very slow. An incremental refresh can take less time.
Answers
E.
A full refresh replaces all the extracted data with the data in the underlying data source.
E.
A full refresh replaces all the extracted data with the data in the underlying data source.
Answers
Suggested answer: A, D, E

Explanation:

According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.

What is created by a calculated field that has a formula of SUM(Sales)/SUM(Profit)?

A.
A parameter
A.
A parameter
Answers
B.
A measure
B.
A measure
Answers
C.
A dimension
C.
A dimension
Answers
D.
A set
D.
A set
Answers
Suggested answer: B

Explanation:

a calculated field that has a formula of SUM(Sales)/SUM(Profit) is a measure, because it returns a numeric value that can be aggregated and used for analysis. A parameter is a user-defined variable that can be used in calculations or filters. A dimension is a categorical field that can be used to group or slice data. A set is a subset of data based on some condition.

Which of the following is a discrete date part?

A.
07Mar20l7
A.
07Mar20l7
Answers
B.
20Sep2016:9:8:8:6546
B.
20Sep2016:9:8:8:6546
Answers
C.
01/23/2021
C.
01/23/2021
Answers
D.
February
D.
February
Answers
Suggested answer: D

Explanation:

February is a discrete date part, because it is a specific value that can be used to group or filter data by month. 07Mar2017, 20Sep2016:9:8:8:6546, and 01/23/2021 are continuous date values, because they represent points along a continuous timeline that can be used for analysis.


Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?

A.
Right-click the field in the Data pane and select Default Properties to change it.
A.
Right-click the field in the Data pane and select Default Properties to change it.
Answers
B.
Add the field to the view, right-click the axis, and select Format to change it.
B.
Add the field to the view, right-click the axis, and select Format to change it.
Answers
C.
Right-click the field in the Data pane and select Change Data Type to change it.
C.
Right-click the field in the Data pane and select Change Data Type to change it.
Answers
D.
Right-click and drag the field into the view to change it.
D.
Right-click and drag the field into the view to change it.
Answers
Suggested answer: A

Explanation:

To change a measure so that it automatically aggregates as an average instead of a sum, you should right-click the field in the Data pane and select Default Properties. In the Default Properties menu, you can set the default aggregation for the measure, such as setting it to calculate an average by default when added to a view.

You have a continuous numeric measure named Sales.

Which chart type is created when you double-click the Sales measure?

A.
A text table
A.
A text table
Answers
B.
A line chart
B.
A line chart
Answers
C.
A pie chart
C.
A pie chart
Answers
D.
A bar chart
D.
A bar chart
Answers
Suggested answer: D

Explanation:

When you double-click a continuous numeric measure named Sales in Tableau, it automatically creates a bar chart. Tableau's default behavior for a single measure is to display it as a bar chart, with the measure values represented on the Y-axis and an automatic range on the X-axis.

Total 318 questions
Go to page: of 32