TDS-C01 Tableau Desktop Specialist - Practice Questions

Question 7

If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Select all that apply, then click Submit answer.

○
Improve query performance
○
To make the context filter a dependent filter
○
To help clean the data
○
To include only the data of interest

Reference / correct answer:

Improve query performance

To include only the data of interest

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

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

Question 8

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

Select an option, then click Submit answer.

○
.twb files
○
.tbm files
○
.twbx files
○
.tde files

Question 9

The calculation [Ship Date] - [Order Date] will return _______________

Select an option, then click Submit answer.

○
Number of orders placed in that duration
○
Number of days between these dates
○
Number of unique orders placed between these dates
○
Number of orders shipped between these dates

TDS-C01 – Tableau Desktop Specialist