Free Practice Questions for Tableau TDS-C01 Exam

Explanation

Follow along to reach the correct answer:

1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

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:

Padding lets you precisely space items on dashboard, while borders and background colors let you visually highlight them. Inner padding sets the spacing between item contents and the perimeter of the border and background color; outer padding provides additional spacing beyond the border and background color.

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 :

All answers except November are examples of Date Values (continuous in nature).

See below:

You can see that the option in Green symbolizes our correct answer, i.e only a Month. In our case that month is November (the correct answer).

All other options are combinations of a year with one other value (like a month, quarter, or day). So this is how by looking at an option you can know if its a date part or date value!

By default, both field names are present in the Union, but contain several null values!

When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields.

You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

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

Table Description automatically generated

A union of these tables creates the following single table that contains all rows from all tables.

Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."

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.

Explanation

Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.

The following are the steps to import a CSV file:

1) From the data connection screen, click on Text:

2) Choose the appropriate file, and click Open:

3) Finally, Tableau imports the data as shown below:

All of the given options are true except - Animations work well with maps, polygons, and density marks in web browsers.

From the official documentation: 

As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )

1) Simultaneous animations

The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

2) Sequential animations

Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places.

By default, when you connect a data source to Tableau, Tableau will create a live connection to the data.

Live connection refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. With a live connection, Tableau makes queries directly against the database or other source, and returns the results of the query for use in a workbook. Users can create live connections and then share them on Tableau Server so that other Tableau users can use the same data using the same connection and filtering settings.