Free Tableau Desktop Specialist TDS-C01 Ultimate Study Guide (Updated 318 Questions)
Get to the Top with TDS-C01 Practice Exam Questions
Tableau TDS-C01: Tableau Desktop Specialist Exam is a valuable certification for professionals who work with data analysis and visualization. Tableau Desktop Specialist certification exam validates an individual's skills and knowledge of using Tableau Desktop software. Tableau Desktop Specialist certification can help professionals to advance their careers by demonstrating their expertise in data analysis and visualization.
Tableau TDS-C01 (Tableau Desktop Specialist) Certification Exam is an excellent program designed for professionals who want to enhance their Tableau Desktop skills. Tableau Desktop Specialist certification program provides individuals with a comprehensive understanding of Tableau Desktop and prepares them for the certification exam. With the certification, individuals can improve their career prospects and organizations can ensure that their employees are using Tableau Desktop effectively.
NEW QUESTION # 116
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. Remote Field Name, Field Name
- B. Local Name, Actual Name
- C. Local Field, Global Field
- D. Column Name, Actual Name
Answer: A
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 # 117
Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.
- A. Web Page
- B. Extension
- C. Video
- D. Text
- E. Image
Answer: A,B,D,E
Explanation:
Video is NOT a valid object type while creating dashboards in Tableau! All others are valid object types.
NEW QUESTION # 118
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. 4.87
- B. 65.67
- C. 68.77
- D. 76.25
Answer: D
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 # 119
You have the following visualization.
Where should you place a field named Region to show multiple distinct lines on the same axis?
- A. Color on the Marks card
- B. Path on the Marks card
- C. The Rows shelf
- D. The Columns shelf
Answer: A
Explanation:
To display multiple distinct lines on the same axis based on a field, you should place the field on the Color shelf in the Marks card. This will encode each distinct value in the Region field with a different color, resulting in separate lines for each region on the same axis.
NEW QUESTION # 120
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
- A. Tableau Server
- B. Tableau Online
- C. Tableau Desktop
- D. Tableau Reader
Answer: D
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION # 121
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. Remote Field Name, Field Name
- B. Local Name, Actual Name
- C. Local Field, Global Field
- D. Column Name, Actual Name
Answer: A
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 # 122
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Click on Data in the Menu bar and Choose Show Mark Labels
- B. Click on Analysis in the Menu bar and choose Show Mark Labels
- C. Click on the Show mark labels icon in the Toolbar
- D. Drag the measure to the Text label in the Marks Card
Answer: B,C,D
Explanation:
Explanation
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let's create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )
2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:
NEW QUESTION # 123
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Fading
- B. Continuous
- C. Mixed
- D. Discrete
Answer: B
Explanation:
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.
When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:
Desktop Version:
For more information about color palettes, see Color Palettes and Effects.
NEW QUESTION # 124
Which two analytics options are available for a scatter plot view? Choose two.
- A. Totals IS
- B. Reference lines
- C. Trend lines
- D. Forecast
Answer: B,C
Explanation:
For a scatter plot view in Tableau, you can add reference lines and trend lines as part of the analytics options. Reference lines can be added to a visualization to mark certain values or to provide context, such as an average line across a scatter plot. Trend lines, on the other hand, are used to show the relationship between two variables in the view, indicating the general direction or pattern of the data points in a scatter plot.
NEW QUESTION # 125
When using a data source that has relationships, how can you add a join between two or more tables?
- A. From the Tables pane, double-click a table.
- B. From the Tables pane, drag a table directly on top of an existing logical table.
- C. From the Connections pane, select Add.
- D. Double-click a logical table in the canvas.
Answer: B
Explanation:
When using a data source that has relationships, you can add a join between two or more tables by dragging a table directly on top of an existing logical table from the Tables pane. This will create a logical table that contains the joined tables. You can then edit the join type, join clauses, and join calculation as needed2 The other options are not valid ways to add a join between tables when using relationships. From the Tables pane, double-clicking a table will add it to the data source as a separate logical table, not joined with any other table. From the Connections pane, selecting Add will allow you to add another connection to the data source, not join tables within the same connection. Double-clicking a logical table in the canvas will open the Data Source page, where you can view and edit the fields in the logical table, not join it with another table2
NEW QUESTION # 126
_________________ 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 Blending
- B. Union
- C. Data segregation
- D. Data Joining
Answer: A
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 # 127
What is a story point in Tableau?
- A. A single worksheet or dashboard
- B. A collection of worksheets
- C. A collection of dashboards
- D. A collection of both worksheets and dashboards
Answer: A
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 # 128
________________ can only create header. _______________ will create header and axis both.
- A. Measures, Dimensions
- B. Groups, Sets
- C. Dates, Strings
- D. Dimensions, Measures
Answer: D
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.
Reference:
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 # 129
What are three benefits of using an extract as compared to a live connection to a data source? Choose three.
- A. An extract reduces the amount of data stored on a client computer as compared to a live data connection.
- B. A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.
- C. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
- D. A live connection to a data source provides the best performance for data connections.
- E. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
Answer: B,C,E
Explanation:
There are three benefits of using an extract as compared to a live connection to a data source:
* A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance. An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can reduce the load on the data source and speed up queries.
* Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections. When you use an extract, Tableau loads the data into memory and optimizes it for analysis.
This allows Tableau to perform calculations and aggregations faster than with live connections.
* Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source. Calculated fields are customfields that you create using formulas or expressions. When you use an extract, Tableau can process calculated fields more efficiently than with live connections.
NEW QUESTION # 130
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 # 131
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 innermostfields, 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.
( Simple Scatter Plot)
(Matrix of Scatter Plots)
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 # 132
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
- A. Joining
- B. Unioning
- C. Blending
- D. Combining
Answer: B
Explanation:
Unioning is the correct answer!
From the official documentation:
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."
NEW QUESTION # 133
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Marks Card
- C. Data Pane
- D. Analytics Pane
Answer: B
Explanation:
Explanation
The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!
The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.
You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.
In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.
After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.
Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.
NEW QUESTION # 134
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. 52,678 and 311,404
- B. 5,129 and 88,872
- C. 1,807 and 34,571
- D. 4,888 and 17,817
Answer: D
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 # 135
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Red, Blue
- C. Blue, Orange
- D. Orange, Blue
Answer: C
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 # 136
Which of the following are valid Dashboard size options?
- A. Range
- B. Scaled
- C. Fixed Size
- D. Automatic
Answer: A,C,D
Explanation:
Scaled is NOT a valid size options when creating Dashboards in Tableau!
After you create a dashboard, you might need to resize and reorganize it to work better for your users.
NEW QUESTION # 137
Which statement accurately describes aliases?
- A. You can create an alias for a continuous dimension.
- B. You can assign an alias to a field member before creating a visualization.
- C. You can create an alias for a discrete measure.
- D. When you assign an alias, the name changes in the database.
Answer: B
Explanation:
You can assign an alias to a field member before creating a visualization. An alias is an alternative name that you can assign to a value in a dimension field. You can use aliases to rename specific values within a dimension to make them more relevant or descriptive in your view than what the original data provides. For example, you can use aliases to shorten long names, correct spelling errors, or replace codes with meaningful labels6 You can create aliases for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures. To create an alias for a dimension member, you can right-click the dimension in the Data pane and select Aliases, then enter a new name for each member under Value (Alias). You can also create an alias by right-clicking a dimension member in the view and selecting Edit Alias. You can do this before or after creating a visualization6 The other options are not accurate statements about aliases. You cannot create an alias for a discrete measure, because measures are not discrete fields. You cannot create an alias for a continuous dimension, because aliases are only available for discrete dimensions. When you assign an alias, the name does not change in the database, only in Tableau. Aliases are stored as part of the workbook or data source, and do not affect the original data6
NEW QUESTION # 138
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 # 139
How would you calculate GDP per capita in Tableau?
- A. SUM([Population]/[GDP]])
- B. SUM([GDP]*[POPULATION])
- C. SUM([GDP]/[POPULATION])
- D. SUM([GDP]) / SUM([Population])
Answer: D
Explanation:
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
NEW QUESTION # 140
......
Pass Tableau TDS-C01 exam - questions - convert Tets Engine to PDF: https://realpdf.free4torrent.com/TDS-C01-valid-dumps-torrent.html