Get Jan-2024 updated TDS-C01 Certification Exam Sample Questions
TDS-C01 Study Guide Cover to Cover as Literally
Tableau TDS-C01 (Tableau Desktop Specialist) Certification Exam is a certification program designed for professionals who want to enhance their skills in using Tableau Desktop. This program is ideal for individuals who want to learn how to create and share visualizations, dashboards, and stories using Tableau. Tableau Desktop Specialist certification program is designed to provide a comprehensive understanding of Tableau Desktop and prepare individuals for the Tableau Desktop Specialist Certification Exam.
Tableau TDS-C01 (Tableau Desktop Specialist) Certification Exam is a popular certification exam designed for individuals seeking to validate their skills and knowledge in Tableau Desktop. TDS-C01 exam is ideal for those who want to become experts in data visualization, analysis, and reporting using Tableau Desktop. It is also suitable for professionals who want to enhance their career opportunities and gain recognition in the industry.
NEW QUESTION # 66
What is the one most important thing you should do after creating a Dual-axis chart?
- A. Change the colours
- B. Hide the axis
- C. Edit the labels
- D. Synchronise the axis
Answer: D
Explanation:
Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.
To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.
NEW QUESTION # 67
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Numbers and Headers
- B. Dimensions and Measures
- C. Rows and Columns
- D. Labels and Values
Answer: B
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
Further,
NEW QUESTION # 68
Data blending simulates a traditional _________________ Join
- A. Right
- B. Full Outer
- C. Left
- D. Inner
Answer: C
Explanation:
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:
NEW QUESTION # 69
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
Explanation:
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the AVG of the revenue in the same view!
NEW QUESTION # 70
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. Local Field, Global Field
- C. Column Name, Actual Name
- D. Remote Field Name, Field Name
Answer: D
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 # 71
When should you use a relationship instead of a join for two data sets?
- A. The data sets include similar data aggregated up to the highest level.
- B. The data sets are in two separate tables within a single spreadsheet.
- C. To use both data sets across multiple sheets in a visualization.
- D. The data sets include similar data aggregated at different levels of detail.
Answer: D
Explanation:
You should use a relationship instead of a join for two data sets when the data sets include similar data aggregated at different levels of detail. A relationship is a way of combining data from different tables based on common fields without creating a single table with all fields. A relationship allows you to query data from multiple tables as needed and preserve the level of detail of each table. A relationship is useful when you have data sets that are aggregated at different levels of detail, such as sales by region and sales by product. A relationship can match data from different levels of detail without creating null values or duplicate rows. The other options are not valid situations for using a relationship instead of a join for two data sets. The data sets include similar data aggregated up to the highest level is not correct, because a relationship is not needed when both data sets have the same level of detail. You can use either a relationship or a join in this case, depending on your preference and performance. The data sets are in two separate tables within a single spreadsheet is not correct, because a relationship is not limited by the location or format of the data sets. You can use a relationship to combine data from different sources or connections, such as databases, files, or web services. To use both data sets across multiple sheets in a visualization is not correct, because a relationship does not affect how you use data in your visualization. You can use either a relationship or a join to create multiple sheets and dashboards with your data sets.
NEW QUESTION # 72
Which of the following are benefits of using Data Extracts in Tableau?
- A. Faster to work with
- B. Working with freshest data at all times
- C. Ability to use the data offline
- D. Improved Performance
Answer: A,C,D
Explanation:
Explanation
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
To work with the MOST up-do-date data, use a live connection instead!
NEW QUESTION # 73
True or False: Sets can be created on Measures
- A. False
- B. True
Answer: A
Explanation:
Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source. They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.
NEW QUESTION # 74
Which of the following is not a Trend Line Model?
- A. binomial Trend Line
- B. Linear Trend Line
- C. Logarithmic Trend Line
- D. Exponential Trend Line
Answer: A
Explanation:
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:
For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
NEW QUESTION # 75
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
- A. A full refresh replaces all the extracted data with the data in the underlying data source.
- B. An incremental refresh can only be run from Tableau Server.
- C. An incremental refresh only adds rows that are new
- D. A full refresh must be configured. An incremental refresh is the default extract in Tableau.
- E. A full refresh is usually very slow. An incremental refresh can take less time.
Answer: A,C,E
Explanation:
According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.
NEW QUESTION # 76
Which of the following are true about dimensions?
- A. They contain qualitative values (such as names, dates, or geographical data)
- B. They contain contain numeric, quantitative values
- C. Dates are mostly placed in dimensions by default for relational data sources
- D. They affect the level of detail in the view
Answer: A,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 # 77
Which of the following are valid options to define the scope of a reference line? Choose 3.
- A. Table
- B. Window
- C. Section
- D. cell
- E. Pane
- F. Axis
Answer: A,D,E
Explanation:
When we create a reference line, we get the following 3 options for the scope:
NEW QUESTION # 78
Most viewers scan content starting at the _____________ of a page.
- A. center
- B. top left
- C. bottom right
- D. bottom left
- E. top right
Answer: B
Explanation:
According to Tableau's official documentation:
NEW QUESTION # 79
Are animations enabled by default in Tableau?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
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.
NEW QUESTION # 80
What are three options to change the scope of a reference line? Choose three.
- A. Fill Above
- B. Maximum
- C. Per Cell
- D. Per Pane
- E. Entire Table
Answer: C,D,E
Explanation:
You can change the scope of a reference line by choosing one of the following options: Per Pane, Entire Table, or Per Cell. The scope determines how many reference lines are added to the view and how they are calculated. Per Pane adds one reference line for each pane in the view. Entire Table adds one reference line for the entire table in the view. Per Cell adds one reference line for each cell in the view
NEW QUESTION # 81
Which two actions can you perform when you join tables from multiple connections? Choose two.
- A. Create an extract.
- B. Create a union.
- C. Add a data source filter.
- D. Use a stored procedure.
Answer: A,C
Explanation:
You can perform two actions when you join tables from multiple connections: add a data source filter and create an extract. A data source filter is a filter that you can apply to the data source before it is loaded into Tableau. This can help improve performance and reduce the amount of data in the view. A data source filter can be applied to any data source, including those that use cross-database joins2 An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can also improve performance and enable offline analysis. You can create an extract from any data source, including those that use cross-database joins3 You cannot perform the other two actions when you join tables from multiple connections: create a union or use a stored procedure. A union is a method for combining data by appending rows of one table onto another table. To union your data in Tableau, the tables must come from the same connection. You cannot union tables from different data sources or connections4 A stored procedure is a set of SQL statements that can be executed on a database server. Tableau does not support using stored procedures as part of a cross-database join. You can only use stored procedures with some single-connection relational data sources, such as Microsoft SQL Server, Oracle, or PostgreSQL5
NEW QUESTION # 82
What does the following icon do in Tableau?
Larger image
- A. Create a Story and Dashboard both
- B. Create a Worksheet
- C. Create a Dashboard
- D. Create a Story
Answer: C
Explanation:
The icon shown is used to add a new Dashboard! From the official documentation:
NEW QUESTION # 83
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. Profit / Sales
- B. Sales / Profit
- C. SUM(Sales)/SUM(Profit)
- D. SUM(Profit) / SUM(Sales)
Answer: D
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:
NEW QUESTION # 84
You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?
- A. Clean the data
- B. Preview the data
- C. Rename the fields and change data types
- D. Create visualisations to analyze your data
Answer: D
Explanation:
The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.
The main thing you do in the workspace is to create visualisations to analyze your data.
Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.
NEW QUESTION # 85
......
Tableau TDS-C01 exam consists of 36 multiple-choice questions that must be completed within 120 minutes. TDS-C01 exam covers a wide range of topics, including data connections, data preparation, visualization creation, analysis, and dashboard creation. TDS-C01 exam also tests the candidate's understanding of best practices for designing and developing effective visualizations, as well as their ability to communicate insights clearly and effectively. Passing the Tableau TDS-C01 certification exam demonstrates that the candidate has the skills and knowledge required to use Tableau Desktop to solve complex business problems and communicate insights effectively.
100% Real & Accurate TDS-C01 Questions and Answers with Free and Fast Updates: https://www.actual4exams.com/TDS-C01-valid-dump.html
Get Unlimited Access to TDS-C01 Certification Exam Cert Guide: https://drive.google.com/open?id=1GX-eYXzSA1zRgmNJWiimiSCyPKzU5c18