ExamGecko
Home Home / Tableau / TDS-C01

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

Question list
Search
Search

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

A.
5,129 and 88,872
A.
5,129 and 88,872
Answers
B.
52,678 and 311,404
B.
52,678 and 311,404
Answers
C.
1,807 and 34,571
C.
1,807 and 34,571
Answers
D.
4,888 and 17,817
D.
4,888 and 17,817
Answers
Suggested answer: D

Explanation:

To reach the correct answer, follow these steps:

1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS

The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that's your choice:

THEREFORE,

2012 = 4,888

2011 -> 2014 = 17,817

True or False : Bins can be created on dimensions

A.
False
A.
False
Answers
B.
rue
B.
rue
Answers
Suggested answer: B

Explanation:

Bin are a user-defined grouping of numerical data in the data source.

According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.

Have a look at the following image. When we right click a measure, we get the following options:

However, for a dimension (this is because theDATA TYPEof this dimension is a string:

But what if we have a dimension of typeNUMBER (NUMERIC DIMENSION)? See below:

We can clearly create bins from dimensions too - they just have to be numeric :)

For more information, please refer to :https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm

True or False: The Highlighting action can be disabled for the entire workbook.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Yes, it is possible to disable highlighting for the entire workbook.

For more information :https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

A.
Yes
A.
Yes
Answers
B.
No
B.
No
Answers
Suggested answer: A

Explanation:

Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:

We are usingBOTHtheSumof the revenue and theAVGof the revenue in the same view!

By definition, Tableau displays measures over time as a ____________

A.
Packed Bubble
A.
Packed Bubble
Answers
B.
Bar
B.
Bar
Answers
C.
Stacked Bar
C.
Stacked Bar
Answers
D.
Line
D.
Line
Answers
Suggested answer: D

Explanation:

Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.

Please refer to the images below:

Which of the following would you use to connect to multiple tables in a single data source at once?

A.
A Blend
A.
A Blend
Answers
B.
A Hierarchy
B.
A Hierarchy
Answers
C.
A Set
C.
A Set
Answers
D.
A Join
D.
A Join
Answers
Suggested answer: D

Explanation:

The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.

For example, consider the following two tables originating from a single data source:

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, 'How much was paid in royalties for authors from a given publisher?'. By combining tables using a join, you can view and use related data from different tables in your analysis.

What is the minimum amount of RAM recommended for any production use of Tableau Server?

A.
8GB
A.
8GB
Answers
B.
16GB
B.
16GB
Answers
C.
32GB
C.
32GB
Answers
D.
64GB
D.
64GB
Answers
Suggested answer: B

Explanation:

The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.

These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

Which of the following chart type makes use of 'binned' data?

A.
Gantt Chart
A.
Gantt Chart
Answers
B.
Bullet chart
B.
Bullet chart
Answers
C.
Histogram
C.
Histogram
Answers
D.
Treemaps
D.
Treemaps
Answers
Suggested answer: C

Explanation:

A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

True or False: Trend lines can only be used with numeric or date fields

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

You can show trend lines in a visualization to highlight trends in your data.

To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.

However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

True or False: All rows from both tables are returned in an INNER JOIN

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables 'Orders' and 'Customers'.

If there are records in the 'Orders' table that do not have matches in 'Customers', these orders will not be shown!

Total 318 questions
Go to page: of 32