Tableau TDS-C01 Tableau Desktop Specialist Online Training
Tableau TDS-C01 Online Training
The questions for TDS-C01 were last updated at Nov 19,2024.
- Exam Code: TDS-C01
- Exam Name: Tableau Desktop Specialist
- Certification Provider: Tableau
- Latest update: Nov 19,2024
Which of the following 2 fields CANNOT be deleted in Tableau?
- A . Number of Records
- B . Measure Names
- C . Measure Values
- D . Calculated Fields
B,C
Explanation:
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
For a relative date filter, the default anchor is _________________
- A . The current time
- B . Today’s date
- C . The target date
- D . The date we specify
B
Explanation:
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.
Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter.
For example, to show only the three most recent weeks, select Weeks.
Here, you can clearly see that the default date is TODAY
Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_relative_dates.htm
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A . No
- B . Yes
B
Explanation:
Of course! As an example, see below:
1) Using the Sample Superstore data, let’s plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks – Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark, and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark – a single continous axis, but 3 different marks (Technology, Furniture and Office supplies) on the x-axis.
2) Now let’s add subcategory to the view as well (another dimension):
Observe that the number of marks has increased – i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
What is the following icon in the Data pane used to do?
Larger image
- A . View Data
- B . Clean Data
- C . Extract Data
- D . Sort Data
A
Explanation:
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
Reference: https://help.tableau.com/current/pro/desktop/en-us/inspectdata_viewdata.htm
By definition, Tableau displays measures over time as a ____________
- A . Packed Bubble
- B . Bar
- C . Stacked Bar
- D . Line
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:
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm
Which of the following returns the Absolute Value of a given number?
- A . ABS(Number)
- B . CEILING(Number)
- C . FLOOR(Number)
- D . ZN(Number)
A
Explanation:
From the official Tableau website:
Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_number.htm
True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.
- A . True
- B . False
B
Explanation:
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
Which of the following is an example of a Date Part?
- A . Q4 2017
- B . March 2019
- C . September 2020
- D . November
D
Explanation:
All answers except November are examples of Date Values (continuous in nature).
See below:
You can see that the option in Green symbolizes our correct answer, i.e only a Month. In our case that month is November (the correct answer).
All other options are combinations of a year with one other value (like a month, quarter, or day). So this is how by looking at an option you can know if its a date part or date value!
Which of the following are required to create a trend line?
- A . 2 measures on opposing axes, or a date and a measure on opposing axes.
- B . 1 measure, or a date and a dimension on opposing axes.
- C . 1 measure only
- D . 2 dimensions, or a date and a dimension on opposing axes.
A
Explanation:
To create a trend line, we need:
Graphical user interface, application
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
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)
- A . 76.25
- B . 65.67
- C . 68.77
- D . 4.87
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:
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:
3) Now, let’s create a dashboard, and use both these sheets in it:
4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:
Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
Latest TDS-C01 Dumps Valid Version with 151 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
