(2023) PASS TDS-C01 exam with Tableau TDS-C01 Real Exam Questions
Real exam questions are provided for Tableau Desktop Specialist tests, which can make sure you 100% pass
Tableau is a popular data visualization tool that allows users to create interactive and meaningful visualizations from their data. The Tableau Desktop Specialist Certification Exam, also known as the TDS-C01, is an exam designed to test a user's proficiency in using Tableau Desktop. Tableau Desktop Specialist certification is ideal for individuals who want to demonstrate their expertise in using Tableau and to validate their skills, knowledge, and ability to use the tool effectively.
NEW QUESTION # 87
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. 68.77
- C. 4.87
- D. 65.67
Answer: A
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 # 88
How can you change the Default Aggregation for a measure in Tableau?
- A. By right clicking the dimension -> Default properties and choosing Aggregation
- B. By changing its properties manually every time we need to use it
- C. By double clicking on the measure, and then choosing Window -> Default Aggregation
- D. By right clicking the measure -> Default properties and choosing Aggregation
Answer: C
Explanation:
According to the official Tableau documentation:
Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!
NEW QUESTION # 89
Which of the following are interactive elements that can be added to a dashboard for users?
- A. Filter Action
- B. Highlight Action
- C. Edit Tooltip Action
- D. URL Action
Answer: B,C,D
Explanation:
We can perform filter, URL and highlight actions out of the above given choices on a dashboard. Please refer to the image below:
NEW QUESTION # 90
Which of the following are valid ways to add Totals to a view?
- A. Using the Data Pane
- B. Using the Marks shelf
- C. Using the Analytics Pane
- D. From the Analysis Tab in the Menu bar on top
Answer: C,D
Explanation:
Explanation
To add totals to a view using the Analytics pane:
Also, you can add totals from the Analytics tab in the Menu above:
NEW QUESTION # 91
Which of the following are valid ways to export a dashboard with multiple visualisations as an image?
- A. Right click on the dashboard, and choose Copy, then image.
- B. Click on Worksheet in the Menu bar followed by Export, then choose Image
- C. using the floating export worksheet option on the Dashboard
- D. Click on Dashboard in the Menu bar followed by Copy Image
Answer: D
Explanation:
Only 1 option is correct -
Click on Dashboard in the Menu bar followed by Copy Image
Right click on the dashboard, and choose Copy, then image - Try doing this, you will end up copying just one of the worksheets not the entire dashboard Click on Worksheet in the Menu bar followed by Export, then choose Image - Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard Using the floating export worksheet option on the Dashboard - No such option exists
NEW QUESTION # 92
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. An error is raised and both fields are dropped from the resulting Union
- C. Only one field name is present in the Union with null values
- D. Both field names are present in the Union, but contain several null
Answer: D
Explanation:
values
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."
A union of these tables creates the following single table that contains all rows from all tables.
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."
NEW QUESTION # 93
Which of the following chart type makes use of 'binned' data?
- A. Histogram
- B. Bullet chart
- C. Gantt Chart
- D. Treemaps
Answer: A
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.
NEW QUESTION # 94
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
- A. False
- B. rue
Answer: A
Explanation:
It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
NEW QUESTION # 95
Which of the following returns the Absolute Value of a given number?
- A. FLOOR(Number)
- B. CEILING(Number)
- C. ABS(Number)
- D. ZN(Number)
Answer: C
Explanation:
From the official Tableau website:
NEW QUESTION # 96
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.
- A. Local Name, Actual Name
- B. Column Name, Actual Name
- C. Remote Field Name, Field Name
- D. Local Field, Global Field
Answer: C
Explanation:
Explanation
Using the Sample superstore as a reference, click on the manage metadata icon as follows:
We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:
Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source.
The remote field name let's us see what the name of the column is in the ORIGINAL Data source.
NEW QUESTION # 97
Larger image
What is this entire view referred to as in Tableau?
- A. Analytics Pane
- B. Summary Pane
- C. Distribution Pane
- D. Data pane
Answer: A
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION # 98
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?
- A. None of the these
- B. Data source Filter
- C. Extract Filter
- D. Context Filter
Answer: D
Explanation:
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.
NEW QUESTION # 99
True or False: It is not possible to blend axes for multiple measures into a single axis
- A. True
- B. False
Answer: B
Explanation:
We can very much blend multiple measures into a single axis. Such charts are called Combined-Axis / Blended-Axis charts. Follow along:
Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis.
Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. For example, the view below shows quarterly sales and profit on a shared axis.
Note: If you drag a measure on to the canvas and only see a single ruler indicator instead of the double ruler indicator shown below, Tableau creates dual axes instead of a blended axis. For more information about how to create dual axes, see Compare two measures using dual axes.
NEW QUESTION # 100
Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?
- A. 0.759329
- B. 0.783262
- C. 0.739284
- D. 0.748472
Answer: B
Explanation:
Trend lines have become popular questions in recent Tableau examinations. Follow along:
1) First drag Sales to the Rows shelf and Profit to the Columns shelf:
You will only see a single mark since the view is aggregated.
2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):
3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:
4) The following is our view. Hover over the trend line to see the R-squared value:
NEW QUESTION # 101
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?
- A. 74,683
- B. 68,620
- C. 37,455
- D. 46,493
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:
2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:
3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:
4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.
Now the chart looks like this:
Now we change the Profit chart type to line:
5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'
And, our final view and answer is:
NEW QUESTION # 102
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 5,000
- B. 15,000
- C. 20,000
- D. 10,000
Answer: D
Explanation:
Explanation
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
NEW QUESTION # 103
You may create a context filter to:
- A. To replace a data source filter
- B. Create a dependent numerical or top N filter
- C. To create a dependent filter
- D. Improve performance
Answer: B,D
Explanation:
Important question! You cannot use a context filter to replace a data source filter since each filter type has its own use case. Also, a content filter is an Independent filter and all other filters are called dependent since they only process the data that passes through a context filter.
According to the official documentation :
NEW QUESTION # 104
By definition, Tableau displays measures over time as a ____________
- A. Line
- B. Stacked Bar
- C. Bar
- D. Packed Bubble
Answer: A
Explanation:
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 # 105
To use a quick table calculation, which of the following programming languages do you need to know?
- A. Java
- B. ython
- C. Javascript
- D. None of these
Answer: D
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 # 106
......
Tableau TDS-C01 certification is an industry-recognized credential that demonstrates proficiency with Tableau Desktop software. Individuals who pass the exam receive a digital badge that can be shared on social media and added to their resume or LinkedIn profile. Tableau Desktop Specialist certification is valid for two years and can be renewed by passing a recertification exam or by completing Tableau’s Continuing Education program.
Latest TDS-C01 Pass Guaranteed Exam Dumps Certification Sample Questions: https://www.testsdumps.com/TDS-C01_real-exam-dumps.html
TDS-C01 Exam with Guarantee Updated 270 Questions: https://drive.google.com/open?id=1z6I8hJMOefRqoeG2RJdlC4DoYQtiltHq
