TDS-C01 Online Practice Questions and Answers

Correct Answer: ACD

https://help.tableau.com/current/pro/desktop/en-us/datasource_datamodel_faq.htm#can-i-use-joins-between-logical-tables Use joins only when you absolutely need to. Situations where you might still use joins include when you want to: Continue to use a data source from a pre-2020.2 version to Tableau that you have upgraded to 2020.2 (https://www.youtube.com/watch?v=bypr1QPclao), Join only can be done between data that come from the same connection. Explicitly use a specific join type Use a data model that supports shared dimensions Join need to implement row level security

Correct Answer: D

Correct Answer: CD

Correct Answer: B

Drop Sales on row ==> 1Mark - 1row by 1 column drop Segment on Column==> 3 Mark - 1row by 3 column if you drop Sales and Segment ==> 3 Mark - 1row by 3 column

Correct Answer: D

Correct Answer: C

If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).

Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question. 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

3) This should be your view now. Click on the Show Mark Labels icon as shown: The final view is as follows, with 3 points below 0 ( i.e negative )

Correct Answer: A

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:

Correct Answer: C

You can adjust the size for all charts except the Tree Map. You use dimensions to define the structure of the treemap, and measures to define the size or color of the individual rectangles. Treemaps are a relatively simple data visualization

that can provide insight in a visually attractive format.

In a Tree Map, the measure itself defines the size and colour! The greater the sum of Measure for each category, the darker and larger its box.

Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_treemap.htm

Correct Answer: BD

The following are 2 correct ways to copy the worksheet visualisation as an image:

AND

Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_image.htm

Correct Answer: C

According to the official Tableau documentation:

Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

Correct Answer: C

Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.

The Data pane includes:

Dimension fields ?Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.

Examples of dimensions include dates, customer names, and customer segments. Measure fields ?Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a

measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures:

sales, profit, number of employees, temperature, frequency. For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.

Calculated fields If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called

calculated fields. For more information on calculated fields, see Create Custom Fields with Calculations. Sets

Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets. Named sets from an MS Analysis Services server or from a Teradata OLAP connector

also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau. Parameters Values that can be used as placeholders in formulas, or replace

constant values in calculated fields and filters. For more information, see Create Parameters.

Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow.htm

Correct Answer: C

By default, all of the above mentioned are stored in Documents-> My Tableau Repository Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

Correct Answer: C

When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add

white space, and you probably have multiple tabs of data too.

When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.

Reference: https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm

Correct Answer: A

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:

Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm

Correct Answer: B

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. The basic building blocks for a histogram are as follows:

Demo :

Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm