TDS-C01 Exam Dumps - Tableau Desktop Specialist Questions and Answers

1) Right click on Rows or Columns, and choose format. In the Font option click on Bold. (CORRECT) - this will modify only the selected axis (row or column)

2) Choose Format then Font from the Menu bar, and select Bold under the Header option (INCORRECT) - this modifies both rows and columns at the same time

3) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option (CORRECT) -  this will modify only the selected axis (row or column)

4) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. (INCORRECT) - no such option exists

According to the official Tableau documentation:

Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. For more information, see Save Data Sources.

In Tableau, you can rename a field directly in the Data pane by clicking and holding on the field name until it becomes editable, allowing you to type a new name. Alternatively, you can use the drop-down menu associated with the field in the Data pane and select the "Rename" option. Both methods provide a quick and easy way to change the name of a field without affecting the underlying data structure. The "Format menu" and "Replace References" option do not apply to renaming fields.

According to the official Tableau documentation:

An example of an area chart is shown below:

Explanation

Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways:

1) Select

2) Hover

3) Menu

Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)

Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them.

If no constraints are detected, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.

You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.

Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets.

To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

Explanation

GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

When you use the 'Create Set' option in Tableau, it creates a dynamic set if the conditions for inclusion in the set are based on a calculation or an aggregation that may change as the data is updated or as filters are applied. Fixed sets are static and do not change with data refreshes, while dynamic sets can update to reflect the current state of the data.

You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.

When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.