[Q171-Q194] Tableau TDS-C01 Practice Verified Answers – Pass Your Exams For Sure! [2024]

[Q171-Q194] Tableau TDS-C01プラクティスの検証済み解答-確実に試験に合格する！ [2024］

この記事を評価する

Tableau TDS-C01 Practice Verified Answers – Pass Your Exams For Sure! [2024]

Valid Way To Pass Tableau Desktop Specialist’s TDS-C01 Exam

Tableau TDS-C01 Exam is a computer-based exam that consists of 36 multiple-choice questions. Test-takers have 2 hours to complete the exam and must score 75% or higher to pass. TDS-C01 exam is designed to test the practical knowledge of individuals and is not limited to theoretical questions. TDS-C01 exam is available in English and Japanese and can be taken at any Tableau testing center or online. Upon passing the exam, individuals will receive a digital badge and certificate that they can use to showcase their skills in Tableau Desktop.

NO.171 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?

5,129 and 88,872

52,678 and 311,404

1,807 and 34,571

4,888 and 17,817

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

NO.172 Which of the following are valid ways to make the font more readable in Tableau?

Decrease the font size

Don’t use backgrounds

use a clear and readable font

Make the Font color sharper / darker than the background

Increase the font size

This is one of the most common questions on the Tableau Desktop Specialist Exam.
Wrong options –
1) Don’t use backgrounds – This is not a solution. What if we want to use backgrounds? We can’t just stop using backgrounds to solve this problem.
2) Decrease the font size – Do you think using a smaller font will make the text more readable? No right? Hence, this is wrong too.
All other options are ways recommended to make your text more readable!

NO.173 Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Tom Ashbrook

Sanjit Engle

Penelope Sewall

Tamara Chand

As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name –> Create –> Set

2) Let’s Name the Set – Customer>30k ( you can name it anything you want 🙂 ) Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:

NO.174 Which of the following are valid ways to add Totals to a view?

Using the Data Pane

Using the Analytics Pane

From the Analysis Tab in the Menu bar on top

Using the Marks shelf

説明
To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

NO.175 True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

真

偽

In fact, the opposite of this is true.
Trick : Whenever you think of joins -> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer.
If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!
Refer to logical layer vs physical layer from the official documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

NO.176 Which two filter modes can you use with dimension filters? Choose two

Multiple Values (drop-down)

At most

Wildcard Match

Range of Values

With dimension filters in Tableau, you can use several filter modes, including “Multiple Values (drop-down)” which allows users to select one or more values from a drop-down list of all the dimension’s members.
Another mode is “Wildcard Match,” which lets users filter the view by typing in a text box to match dimension members that contain the typed string. These filter types are particularly useful for string or categorical dimensions where users need to search or select specific members to display in the view.

NO.177 The View Data window displays as much of the data as possible by default, up to _______________ rows.

20,000

5,000

10,000

15,000

The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm

NO.178 Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

September 2017

March 2018

December 2017

January 2018

Follow the steps to get the correct answer : January 2018

We are talking about dates, so use the Time series sheet as follows:

Next, the following should be your view and clearly, January 2018 is the lowest point:

Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/

NO.179 You have a dashboard that shows car rental statistics by city, including a field named Car Dropoff City in the view. A URL action in the dashboard uses https://en.wikipedia.org/wiki/<Car Dropoff City> as the URL target.
When you click Salt Lake City in the view, to where will the URL action direct you?

https://en.wikipedia.org/wiki/<Car Dropoff City>

https://en.wikipedia.org/wiki/<Salt-Lake-City>

https://en.wikipedia.org/wiki/Salt.LakeXity

https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City

When you click Salt Lake City in the view, the URL action will direct you to https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City. A URL action is a hyperlink that points to a web page or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs3 In this case, the URL action uses https://en.wikipedia.org/wiki/<Car Dropoff City> as the URL target, where <Car Dropoff City> is a field value from the view. When you click Salt Lake City in the view, Tableau will replace <Car Dropoff City> with Salt Lake City in the URL target. However, since spaces are not allowed in URLs, Tableau will encode them as + signs instead. Therefore, the final URL will be https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City3 The other options are not correct because they do not reflect how Tableau encodes field values in URL actions.

NO.180 Which type of filter affects a fixed Level of Detail (LOD) expression?

Table calculation filter

Measure filter

Context filter

Dimension filter

In Tableau, a Fixed Level of Detail (LOD) expression calculates values at a specific level of granularity, regardless of the dimensions in the view. The computation of a fixed LOD expression can be influenced by a context filter. A context filter serves as a primary filter, setting the context for the rest of the filters in the view.
When a context filter is applied, it effectively changes the level at which the fixed LOD expression is computed, thereby affecting its outcome. Other types of filters, such as table calculation, measure, and dimension filters, do not have this influence on fixed LOD expressions.

NO.181 True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

真

偽

Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.
To disaggregate all measures in the view:
Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.

NO.182 Are animations enabled by default in Tableau?

いいえ

はい

No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.

NO.183 If you have a dashboard and are displaying its filter, how can you rearrange it?

By clicking on the 2 lines on top and dragging the filter.

By clicking on the dropdown and dragging the filter

By clicking on the filter title and dragging it.

By clicking anywhere inside the filter and dragging it.

You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

NO.184 Which two types of fields appear blue? Choose two.

Continuous measures

Discrete measures

Continuous dimensions

Discrete dimensions

Discrete measures and discrete dimensions appear blue in Tableau. Discrete fields are those that have a finite number of distinct values, such as names, categories, or dates. Discrete fields are usually used to create headers or labels in the view. Blue fields indicate that the field is discrete. Continuous measures and continuous dimensions appear green in Tableau. Continuous fields are those that have an infinite range of possible values, such as numbers or ratios. Continuous fields are usually used to create axes or color gradients in the view. Green fields indicate that the field is continuous1

NO.185 When creating a histogram in Tableau, to what does bin size refer?

The minimum number of axis ticks in the view.

The range of the continuous measure counted in each bin.

The count distinct (COUNTD) of items on either axis.

The maximum number of marks in the view.

When creating a histogram in Tableau, bin size refers to the range of the continuous measure counted in each bin. A histogram is a chart that displays the shape of a distribution of a continuous measure. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins. The basic building blocks for a histogram are as follows: Mark type: Automatic; Rows shelf: Continuous measure (aggregated by Count or Count Distinct); Columns shelf: Bin (continuous or discrete)4 To create bins from a continuous measure, you need to specify the size of bins, which determines how many bins are created and how wide they are. The size of bins is equal to the difference between consecutive values along the axis that represents the bins. For example, if you have bins with values 0-10, 10-20, 20-30, etc., then the size of bins is 10. You can either enter a value for the size of bins manually or have Tableau suggest an optimal bin size based on a formula that considers the number of distinct rows and the minimum and maximum values in the data5 The other options are not valid definitions of bin size when creating a histogram in Tableau. The minimum number of axis ticks in the view is determined by Tableau’s automatic scaling and formatting of axes, which can be adjusted manually if needed. The count distinct (COUNTD) of items on either axis is an aggregation function that returns the number of unique values in a field, which can be used as a measure in a histogram but not as bin size. The maximum number of marks in the view is limited by the performance and readability of the visualization, which can be improved by filtering, sorting, or aggregating the data4

NO.186 Which of the following is NOT a valid official data source in Tableau Desktop?

PostgreSQL

SAP HANA

Google Firebase

Amazon Redshift

Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.
A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.
But then again, it is a workaround and not an official out-of-the-box solution.
The following are the available Data sources available as of now:
1) Server

2) File

NO.187 How does Tableau know at which level to aggregate values?

Values are always aggregated at the level of granularity of the worksheet.

Tableau doesn’t aggregate values, we do!

Values are always aggregated at the level of the Date Part

Aggregation is always done by using Tableau special formulas

説明
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure’s name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:

NO.188 Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

3.000

3.840

3.704

3.500

Since we need to focus on 1 country -> Japan, let’s filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let’s do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward 🙂

NO.189 A Tableau Support case can be opened in which of the following valid ways?

Using the Developer Community Forum

Contacting Salesforce using their website

Using the support option on the Tableau website

Using the Tableau learn website

It is possible to open a Tableau support case by visiting the following link : https://www.tableau.com/support/case

NO.190 Which type of filter affects a fixed Level of Detail (LOD) expression?

Table calculation filter

Measure filter

Context filter

Dimension filter

In Tableau, a Fixed Level of Detail (LOD) expression calculates values at a specific level of granularity, regardless of the dimensions in the view. The computation of a fixed LOD expression can be influenced by a context filter. A context filter serves as a primary filter, setting the context for the rest of the filters in the view. When a context filter is applied, it effectively changes the level at which the fixed LOD expression is computed, thereby affecting its outcome. Other types of filters, such as table calculation, measure, and dimension filters, do not have this influence on fixed LOD expressions.

NO.191 What is a Tableau story point?

The pane where you set the size of the story

A collection of talking points to drive the story

An individual sheet or dashboard in the story

A collection of sheets arranged in a sequence

A Tableau story point is an individual container in a story that holds a sheet or dashboard. It’s like a slide in a presentation, and a story is a sequence of these points that can be used to convey a data narrative, showing how facts are connected and guiding the audience through a sequence of analysis steps.

NO.192 Which of the following points are True about Viz Animations?

Sequential animations take more time but make complex changes
clearer by presenting them step-by-step

They can be turned on for certain worksheets only

Animations work well with maps, polygons, and density marks in web
browsers

It is possible to turn them on for the entire workbook at once

All of the given options are true except – Animations work well with maps, polygons, and density marks in web browsers.
From the official documentation:

As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

NO.193 Which of the following chart type makes use of ‘binned’ data?

Gantt Chart

Bullet chart

Histogram

Treemaps

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.

NO.194 The row and column shelves contain ___________________

Pills

Grand Totals

Filters

Parameters

We can drag fields from the Data pane to create the structure for your visualizations.
The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
These FIELDS are also referred to as PILLS. See below: