TDS-C01 Practice Exam Questions and Answers

Important question! You cannot use a context filter to replace a data source filter since each filter type has its own use case. Also, a content filter is an Independent filter and all other filters are called dependent since they only process the data that passes through a context filter.

According to the official documentation : 

To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

Explanation

Extracts are advantageous for several reasons:

1) Supports large data sets: You can create extracts that contain billions of rows of data.

2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.

3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.

4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.

5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

To work with the MOST up-do-date data, use a live connection instead!

From the official Tableau documentation:

As we can see below, Bar charts can be used as a floating object.

By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter (Option stating - To create a dependent filter eliminated here). Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

You may create a context filter to:

1) Improve performance – If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.

2) Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

For example, suppose you’re in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source is very large, you can set a context filter to include only breakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.

Graphical user interface, application Description automatically generated

Explanation

You can export the data in a Tableau data source, including all or part of the records from your original data. Alternatively, you can export only the portion of data used to generate the view.

Since the question mentions the data used to build the view, we'll focus on that :

*Export data in the view to Microsoft Access or .csv*

Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).

1) In Tableau Desktop, select Worksheet > Export > Data.

2) Select a location and type a name for your Access database or .csv file.

3) Click Save.

4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

Graphical user interface, text, application, email Description automatically generated

Video is NOT a valid object type while creating dashboards in Tableau! All others are valid object types.

For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

Names and Categories would be mostly used as dimensions (categorical data).

Profit and measures contain quantitative data and would be more suitable for Measures!