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

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

List of questions

Question 91

Report
Export
Collapse

You can create _______________ for members in a dimension so that their labels appear differently in the view.

parameters
parameters
duplicates
duplicates
copies
copies
aliases
aliases
Suggested answer: D

Explanation:

You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.

Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.

To create an alias:

Tableau TDS-C01 image Question 91 explanation 76434 09232024004744000000

1) In the Data pane, right-click a dimension and select Aliases.

2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.

Tableau TDS-C01 image Question 91 explanation 76434 09232024004744000000

To submit your changes: In Tableau Desktop, click OK.

Tableau TDS-C01 image Question 91 explanation 76434 09232024004744000000

On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.

When you add the field to the view, the alias names appear as labels in the view. For example:

asked 23/09/2024
shikeba barakzei
34 questions

Question 92

Report
Export
Collapse

You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

join
join
blend
blend
concatenate
concatenate
union
union
Suggested answer: D

Explanation:

You can union your data to combine two or more tables by appending values (rows) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.

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 92 explanation 76435 09232024004744000000

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

Tableau TDS-C01 image Question 92 explanation 76435 09232024004744000000

asked 23/09/2024
Michael Ulrich
41 questions

Question 93

Report
Export
Collapse

Larger image

Tableau TDS-C01 image Question 93 76436 09232024004744000000

What is this view referred to as in Tableau?

Analytics Pane
Analytics Pane
Window Pane
Window Pane
Data Pane
Data Pane
Dimensions & Measures
Dimensions & Measures
Suggested answer: C

Explanation:

Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.

The Data pane includes:

Dimension fields -- Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments.

Measure fields -- Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.

For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.

Calculated fields -- If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.

For more information on calculated fields, see Create Custom Fields with Calculations.

Sets -- Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.

Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.

Parameters -- Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.

asked 23/09/2024
Sebasteen Lawrance
43 questions

Question 94

Report
Export
Collapse

DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already)

Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

United States
United States
France
France
United Kingdom
United Kingdom
Canada
Canada
Suggested answer: B

Explanation:

Follow along to get the correct answer:

Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :

Tableau TDS-C01 image Question 94 explanation 76437 09232024004744000000

2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

2.1 As it is (continuous)

Tableau TDS-C01 image Question 94 explanation 76437 09232024004744000000

2.2 Converting to discrete first & then using it

Tableau TDS-C01 image Question 94 explanation 76437 09232024004744000000

and then :

Tableau TDS-C01 image Question 94 explanation 76437 09232024004744000000

3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013

Tableau TDS-C01 image Question 94 explanation 76437 09232024004744000000

asked 23/09/2024
Johnny Tien
47 questions

Question 95

Report
Export
Collapse

Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

28.415%
28.415%
23.497%
23.497%
25.683%
25.683%
22.404%
22.404%
Suggested answer: D

Explanation:

Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations(percent of total) for this one.

1) Firstly, let's dragCountryandInstitutionto the Rows shelf, and year (discrete) to the Columns shelf. Then, dragPublicationsto the Text Icon in the Marks Shelf. The following is our view:

Tableau TDS-C01 image Question 95 explanation 76438 09232024004744000000

asked 23/09/2024
Vasco Ricardo Ribeiro
30 questions

Question 96

Report
Export
Collapse

Using the atheletes table:

i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)

ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)

Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?

(Ignore any nulls / unknowns)

76.25
76.25
65.67
65.67
68.77
68.77
4.87
4.87
Suggested answer: A

Explanation:

Pretty common question on the Tableau Desktop Specialist exam.

1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

Tableau TDS-C01 image Question 96 explanation 76439 09232024004744000000

2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.

NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

Tableau TDS-C01 image Question 96 explanation 76439 09232024004744000000

3) Now, let's create a dashboard, and use both these sheets in it:

Tableau TDS-C01 image Question 96 explanation 76439 09232024004744000000

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Tableau TDS-C01 image Question 96 explanation 76439 09232024004744000000

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

Tableau TDS-C01 image Question 96 explanation 76439 09232024004744000000

asked 23/09/2024
Matthew Farrington
35 questions

Question 97

Report
Export
Collapse

Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

68,620
68,620
74,683
74,683
37,455
37,455
46,493
46,493
Suggested answer: C

Explanation:

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!

To create a dual axis chart for the problem mentioned:

1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

Now the chart looks like this:

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

Now we change the Profit chart type to line:

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

Tableau TDS-C01 image Question 97 explanation 76440 09232024004744000000

And, our final view and answer is:

asked 23/09/2024
RODRIGO BALISTA
40 questions

Question 98

Report
Export
Collapse

Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

25.79%
25.79%
23.39%
23.39%
27.73%
27.73%
29.49%
29.49%
Suggested answer: C

Explanation:

We need to use the concept of Groups for this question. Follow along:

1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

Tableau TDS-C01 image Question 98 explanation 76441 09232024004744000000

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

Tableau TDS-C01 image Question 98 explanation 76441 09232024004744000000

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

Tableau TDS-C01 image Question 98 explanation 76441 09232024004744000000

We can see the answer already : 23.386% in the view above (even before grouping!)

4) Finally, we get the following view and our answer:

Tableau TDS-C01 image Question 98 explanation 76441 09232024004744000000

asked 23/09/2024
Josefa Vera Gago
39 questions

Question 99

Report
Export
Collapse

Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

9
9
7
7
10
10
8
8
Suggested answer: C

Explanation:

Follow along to reach the correct answer:

1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

Click on Date in the Column shelf and convert it to continuous month :

Tableau TDS-C01 image Question 99 explanation 76442 09232024004744000000

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

Tableau TDS-C01 image Question 99 explanation 76442 09232024004744000000

3) Finally, click on the Show mark Labels icon:

Tableau TDS-C01 image Question 99 explanation 76442 09232024004744000000

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

Tableau TDS-C01 image Question 99 explanation 76442 09232024004744000000

asked 23/09/2024
Max Lenin Dos Santos Torres
50 questions

Question 100

Report
Export
Collapse

When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Portable Network Graphic (.PNG)
Portable Network Graphic (.PNG)
JPEG Image (.JPG, .JPEG)
JPEG Image (.JPG, .JPEG)
Tagged Image File Format (TIFF)
Tagged Image File Format (TIFF)
Windows Bitmap (.BMP)
Windows Bitmap (.BMP)
Suggested answer: A, B, D

Explanation:

The following options are available when an image is Exported:

Tableau TDS-C01 image Question 100 explanation 76443 09232024004744000000

NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.

asked 23/09/2024
Rebecca Gillespie
40 questions
Total 318 questions
Go to page: of 32
Search