Tableau TDS-C01 Study Guide Archives Updated on Feb 27, 2024
Download TDS-C01 Mock Test Study Material
Tableau TDS-C01 (Tableau Desktop Specialist) Exam is a certification exam for Tableau Desktop Specialist certification. TDS-C01 exam is designed to test the skills required to use Tableau Desktop to perform data analysis and visualization tasks. TDS-C01 exam is intended for individuals who have basic knowledge of Tableau Desktop and want to demonstrate their skills in using the software.
NEW QUESTION # 161
Which of the following can you add a reference line to?
- A. Calculated Fields
- B. Measures
- C. Dimensions
- D. Groups
Answer: A,B
Explanation:
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 # 162
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. Preview the data
- B. Create visualisations to analyze your data
- C. Rename the fields and change data types
- D. Clean the data
Answer: B
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 # 163
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Measure Names
- C. Number of Records
- D. Calculated Fields
Answer: A,B
Explanation:
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.
NEW QUESTION # 164
How do you identify a continuous field in Tableau?
- A. It is preceded by a 'Abc' symbol in the data window
- B. It is preceded by a '=#' symbol in the data window
- C. It is identified by a blue pill in the visualization
- D. It is identified by a green pill in a visualization
Answer: B
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.
NEW QUESTION # 165
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Dimension Filter
- B. Extract Filter
- C. Measure Filter
- D. Context Filter
Answer: B
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 # 166
True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.
- A. False
- B. True
Answer: B
Explanation:
Yes! We get different color palettes. They are:
*From the official Tableau documentation*
To change the color for a value
1) Click on an item on the left, under Select Data Item.
2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a swatch to identify the color.
3) Repeat for as many values that you want to change.
4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or Tableau Online, simply close the dialog box.
AND
NEW QUESTION # 167
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Dimension Filter
- B. Extract Filter
- C. Measure Filter
- D. Context Filter
Answer: B
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 # 168
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.783262
- B. 0.759329
- C. 0.739284
- D. 0.748472
Answer: A
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 # 169
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
- A. 25.79%
- B. 27.73%
- C. 29.49%
- D. 23.39%
Answer: B
Explanation:
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:
2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:
3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:
We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:
NEW QUESTION # 170
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. December 2017
- B. September 2017
- C. January 2018
- D. March 2018
Answer: C
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 # 171
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins
- A. Data segregation
- B. Data Blending
- C. Data Joining
- D. Union
Answer: B
Explanation:
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.
According to the official Tableau Documentation:
To read more about Data Blending, click on THIS link.
NEW QUESTION # 172
Which of the following can help us focus on specific data without removing data in the visualization?
- A. Sets
- B. Highlighters
- C. Clusters
- D. Filters
Answer: B
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 # 173
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Data Extract (.tde)
- B. Tableau Workbook (.twb)
- C. Tableau Packaged Workbook (.twbx)
- D. Tableau Bookmark (.tbm)
Answer: C
Explanation:
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.
3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)
NEW QUESTION # 174
How can you format numbers in Tableau as currency?
- A. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: D
Explanation:
According to the official Tableau documentation:
NEW QUESTION # 175
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Red, Blue
- B. Blue, Orange
- C. Orange, Blue
- D. Blue, Red
Answer: B
Explanation:
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:
NEW QUESTION # 176
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Rows and Columns
- B. Labels and Values
- C. Numbers and Headers
- D. Dimensions and Measures
Answer: D
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 # 177
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. Yes
- B. No
Answer: A
Explanation:
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 # 178
Data blending simulates a traditional _________________ Join
- A. Inner
- B. Full Outer
- C. Left
- D. Right
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 # 179
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
- A. Tableau Public
- B. Tableau Server
- C. Tableau Prep
- D. Tableau myServer
Answer: D
Explanation:
Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
NEW QUESTION # 180
True or False: It is possible to change the Geographic Role of a dimension
- A. False
- B. True
Answer: B
Explanation:
Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.
NEW QUESTION # 181
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
- A. 95.12%
- B. 96.46%
- C. 97.12%
- D. 99.46%
Answer: C
Explanation:
Not too tough. Follow along the steps:
Drag Color to Filter and choose Red:
3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
And your final view will look like :
NEW QUESTION # 182
What is a story point in Tableau?
- A. A collection of dashboards
- B. A collection of worksheets
- C. A collection of both worksheets and dashboards
- D. A single worksheet or dashboard
Answer: D
Explanation:
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.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.
NEW QUESTION # 183
Which of the following is a good reason for using a bullet graph?
- A. Analysing the trend over a given time period
- B. Forecasting future sales
- C. Comparing the actual sales against the target sales
- D. Displaying the year-on-year growth in sales
Answer: C
Explanation:
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.
NEW QUESTION # 184
Which of the following describes the best way to change the formatting at a workbook level?
- A. Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.
- B. Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.
- C. It is only possible to specify formatting at a worksheet level, not at the workbook level.
- D. Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.
Answer: D
Explanation:
It is very much possible to specify the formatting at a WORKBOOK level (all sheets) instead of a single worksheet level.
You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level.
For example, you might want to use a specific font, size, and color so that all views adhere to your company's brand. You might also want to remove grid lines from your views-or make them more noticeable by increasing their pixel size or color.
You can also change the theme used by your workbook. Themes control items like the default font, colors, and line thickness. When you create a new workbook, it automatically uses the Default theme, which uses visual best practices.
Change fonts in your workbook:
You can change all fonts in your workbook or you can change fonts for only certain areas, such as just worksheet titles.
1) On the Format menu, select Workbook.
2) The Format Workbook pane replaces the Data pane on the left and provides a series of drop-down lists where you can change all font settings in a workbook, as well as the font settings for titles of worksheets, stories, and dashboards.
Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.
Reset a workbook to its default settings
When you make changes to your workbook's font settings, a gray dot appears next to the setting in the Format Workbook pane. You can quickly switch back to default settings using the Reset to Defaults button.
1) On the Format menu, select Workbook.
2) In the Format Workbook pane, click Reset to Defaults.
NEW QUESTION # 185
......
The TDS-C01 exam consists of 36 multiple-choice questions that cover various topics related to Tableau Desktop, such as connecting to data sources, creating and formatting visualizations, and using calculations and analytics to gain insights from data. TDS-C01 exam is timed and you have 120 minutes to complete it. The passing score for the exam is 75%, and you can retake the exam if you do not pass on your first attempt.
Tableau TDS-C01: Tableau Desktop Specialist is one of the most popular and in-demand certification exams in the field of data visualization. It is designed to test the knowledge and skills of the candidates in creating effective and efficient visualizations using Tableau Desktop. TDS-C01 exam is conducted by Tableau, a leading data visualization software company, and is recognized globally as a benchmark for proficiency in Tableau Desktop.
TDS-C01 Questions Prepare with Learning Information: https://www.exams4sures.com/Tableau/TDS-C01-practice-exam-dumps.html
Practice Material for TDS-C01 Exam Question Preparation: https://drive.google.com/open?id=1PDGYv-CSSHGffXamtcgiMHaJ0JxZm_Tp