Pass the Tableau Desktop Specialist TDS-C01 Questions and answers with ValidTests

According to the official documentation, the following are the requirements for using relationships:

1) When relating tables, the fields that define the relationships must have the same data type. Changing the data type in the Data Source page does not change this requirement. Tableau will still use the data type in the underlying database for queries.

2) You can't define relationships based on geographic fields.

3) Circular relationships aren't supported in the data model.

4) You can't edit relationships in a published data source.

5) You can't define relationships between published data sources.

6) Your workbook must use an embedded data source for you to be able to edit relationships and performance options in the Data Source page in Tableau Online or Tableau Server.

Extracts are saved subsets of data that you can use to improve performance or to take advantage of Tableau functionality not available or supported in your original data. When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data.

When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

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.

According to the Tableau Help, a highlight table is “a cross-tabulation that uses color to encode values”. The help also states that “Highlight tables use the Square mark type” (page 1).

When you double-click a continuous numeric measure named Sales in Tableau, it automatically creates a bar chart. Tableau's default behavior for a single measure is to display it as a bar chart, with the measure values represented on the Y-axis and an automatic range on the X-axis.

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.

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/

According to the official Tableau documentation:

Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. For more information, see Extract Your Data.

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.)

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