[Oct 19, 2024] Actual4Dumps TDS-C01 Exam Practice Test Questions (Updated 318 Questions)
Pass Tableau TDS-C01 Exam Info and Free Practice Test
NEW QUESTION # 171
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Context Filter
- B. Dimension Filter
- C. Extract Filter
- D. Measure Filter
Answer: C
Explanation:
Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
NEW QUESTION # 172
True or False: Trend lines can only be used with numeric or date fields
- A. True
- B. False
Answer: B
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.
NEW QUESTION # 173
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. 65.67
- B. 76.25
- C. 4.87
- D. 68.77
Answer: B
Explanation:
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:
NEW QUESTION # 174
Which of the following points are True about Viz Animations?
- A. Sequential animations take more time but make complex changes
clearer by presenting them step-by-step - B. They can be turned on for certain worksheets only
- C. Animations work well with maps, polygons, and density marks in web
browsers - D. It is possible to turn them on for the entire workbook at once
Answer: A,B,D
Explanation:
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.
NEW QUESTION # 175
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Multiple Values (dropdown)
- B. Single Value (slider)
- C. Regex Match
- D. Wildcard Match
Answer: C
Explanation:
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION # 176
Which of the following are valid Layout Container types when using Dashboards in Tableau?
- A. Vertical Container
- B. Split Container
- C. Diagonal Container
- D. Horizontal Container
Answer: A,D
Explanation:
NEW QUESTION # 177
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. 4,888 and 17,817
- B. 5,129 and 88,872
- C. 1,807 and 34,571
- D. 52,678 and 311,404
Answer: A
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
NEW QUESTION # 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?
- A. January 2018
- B. September 2017
- C. March 2018
- D. December 2017
Answer: A
Explanation:
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/
NEW QUESTION # 179
Which of the following returns the Absolute Value of a given number?
- A. FLOOR(Number)
- B. ABS(Number)
- C. ZN(Number)
- D. CEILING(Number)
Answer: B
Explanation:
Explanation
From the official Tableau website:
NEW QUESTION # 180
Which of the following can you add a reference line to?
- A. Calculated Fields
- B. Measures
- C. Dimensions
- D. Groups
Answer: A,B
Explanation:
You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.
Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.
NEW QUESTION # 181
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can
__________________ the view.
- A. disaggregate the measures
- B. aggregate the measures
- C. break-down the measures
- D. split the measures
- E. sort the measures
Answer: A
Explanation:
The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values.
For a complete list of the available aggregations, check out - List of Predefined Aggregations in Tableau.
The level of detail is determined by the dimensions in your view-for information about the concept of level of detail, see How dimensions affect the level of detail in the view.
Disaggregating your data can be useful for analyzing measures that you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product.
Disaggregating data can be useful when you are viewing data as a scatter plot. See Example: Scatter Plots, Aggregation, and Granularity.
NEW QUESTION # 182
How does Tableau know at which level to aggregate values?
- A. Aggregation is always done by using Tableau special formulas
- B. Values are always aggregated at the level of granularity of the worksheet.
- C. Values are always aggregated at the level of the Date Part
- D. Tableau doesn't aggregate values, we do!
Answer: B
Explanation:
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:
NEW QUESTION # 183
When field names in the Union do not match, then:
- A. Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch
- B. Only one field name is present in the Union with null values
- C. Both field names are present in the Union, but contain several null values
- D. An error is raised and both fields are dropped from the resulting Union
Answer: C
Explanation:
By default, both field names are present in the Union, but contain several null values!
When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields.
You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.
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." Table Description automatically generated
A union of these tables creates the following single table that contains all rows from all tables.
Table Description automatically generated
Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard
"Customer" field name, it contains an abbreviated version called "Cust." Table Description automatically generated
Table Description automatically generated
NEW QUESTION # 184
What should you use to apply bold text formatting to rows or columns independent of each other?
- A. Text on the Marks card
- B. The Field Format Font pane
- C. The Sheets tab on the Format Font pane
- D. The Rows tab or the Columns tab on the Format Font pane
Answer: D
Explanation:
To apply bold text formatting to rows or columns independently in Tableau, you should use the Rows tab or the Columns tab on the Format Font pane. This approach provides control over the formatting of text within individual rows or columns. By selecting the appropriate tab (Rows or Columns), you can apply formatting settings, including bold text, to only the selected rows or columns. This is a crucial feature for enhancing the readability and visual appeal of specific parts of a Tableau worksheet, allowing for emphasis on particular data points or categories.
NEW QUESTION # 185
By definition, Tableau displays measures over time as a ____________
- A. Packed Bubble
- B. Stacked Bar
- C. Line
- D. Bar
Answer: C
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:
NEW QUESTION # 186
Which of the following can help us focus on specific data without removing data in the visualization?
- A. Filters
- B. Clusters
- C. Sets
- D. Highlighters
Answer: D
Explanation:
From the official documentation:
When you have a view with a large amount of data you might want to explore your data interactively and highlight a specific mark or group of marks while still maintaining the context of where those marks show in your view.
To do this you can turn on the Highlighter for one or more discrete fields that are included in your view and that affect the level of detail Example - Here we just want to focus on Public Affairs college dimension, but don't want to filter out or remove the rest of the data:
Note that filtering is not the correct option since that would REMOVE the data that doesn't match the filtering criteria.
NEW QUESTION # 187
Which of the following are valid ways to make the font more readable in Tableau?
- A. Make the Font color sharper / darker than the background
- B. use a clear and readable font
- C. Increase the font size
- D. Decrease the font size
- E. Don't use backgrounds
Answer: A,B,C
Explanation:
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!
NEW QUESTION # 188
A union of two tables usually results in an
- A. increase in the number of rows
- B. decrease in the number of rows
- C. increase in the number of columns
- D. decrease in the number of columns
Answer: A
Explanation:
From the official Tableau documentation:
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.
Graphical user interface, text Description automatically generated
NEW QUESTION # 189
To use a quick table calculation, which of the following programming languages do you need to know?
- A. Java
- B. Javascript
- C. None of these
- D. ython
Answer: C
Explanation:
You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.
The visualization updates to look like this:
Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.
NEW QUESTION # 190
Which three statements accurately describes the capabilities of dashboard actions? Choose three.
- A. Can have multiple source and target sheets
- B. Can be set to run on Hover, Select, or Menu
- C. Can be set to be triggered on a data value
- D. Can be set to Filter, Highlight, or Go to URL
- E. Can be set to dynamically update when a workbook opens
Answer: A,B,D
Explanation:
Dashboard actions in Tableau are interactive elements that can be used to create a more dynamic experience. These actions can be set to filter data on the dashboard, highlight specific elements, or even direct the user to a URL when interacting with a visualization. They can be triggered by user interaction such as hover, selection, or accessing a context menu. Moreover, dashboard actions can have multiple source sheets (where the action originates) and target sheets (where the action takes effect), allowing for a complex interactivity between different parts of the dashboard.
NEW QUESTION # 191
DOWNLOAD THE DATASET FROM - https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!
2) Or, you can simply go to Data Source -> Country Tab -> Describe
As you can see, 147 members exist in this Country column!
NEW QUESTION # 192
________________ can only create header. _______________ will create header and axis both.
- A. Dimensions, Measures
- B. Measures, Dimensions
- C. Groups, Sets
- D. Dates, Strings
Answer: A
Explanation:
Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
NEW QUESTION # 193
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?
- A. https://en.wikipedia.org/wiki/<Salt-Lake-City>
- B. https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City
- C. https://en.wikipedia.org/wiki/<Car Dropoff City>
- D. https://en.wikipedia.org/wiki/Salt.LakeXity
Answer: B
Explanation:
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.
NEW QUESTION # 194
Which of the following are true about dimensions?
- A. They contain contain numeric, quantitative values
- B. They affect the level of detail in the view
- C. They contain qualitative values (such as names, dates, or
geographical data) - D. Dates are mostly placed in dimensions by default for relational data sources
Answer: B,C,D
Explanation:
Measures contain numeric quantitative values hence that option is incorrect.
Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm
NEW QUESTION # 195
Creating a scatter plot requires a minimum of how many measures?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
We can use scatter plots to visualize relationships between numerical variables!
In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum). If these shelves contain both dimensions and measures, Tableau places the measures as the innermost fields, which means that measures are always to the right of any dimensions that you have also placed on these shelves. The word "innermost" in this case refers to the table structure.
A scatter plot can use several mark types. By default, Tableau uses the shape mark type. Depending on your data, you might want to use another mark type, such as a circle or a square. For more information, see Change the Type of Mark in the View.
To create a scatter plot, follow the steps below:
NEW QUESTION # 196
......
The Tableau Desktop Specialist certification exam is conducted online and is available in multiple languages. TDS-C01 exam is time-bound, and candidates are required to complete it within the given time frame. The passing score for the exam is 70%, and candidates who pass the exam are awarded the Tableau Desktop Specialist certification. Tableau Desktop Specialist certification remains valid for three years, after which the candidate is required to renew it by taking an updated version of the exam.
Pass Your Tableau Exam with TDS-C01 Exam Dumps: https://www.actual4dumps.com/TDS-C01-study-material.html
TDS-C01 Exam Dumps PDF Updated Dump from Actual4Dumps Guaranteed Success: https://drive.google.com/open?id=15EQkXh9T-OK1YtTvYtBKs_XDo3G3AHhg