Free Practice Questions for Tableau Desktop-Specialist Exam

Beginning in version 10.5, when you create a new extract, it uses the .hyper format instead of the .tde format.

Extracts in the .hyper format take advantage of the improved data engine, which supports the same fast analytical and query performance as the data engine before it, but for even larger extracts.

Although there are many benefits of using .hyper extracts, the primary benefits include the following:

1) Create larger extracts: You can create extracts with billions of rows of data. Because .hyper extracts can support more data, you can consolidate .tde extracts that you previously had to create separately into a single .hyper extract.

2) Create and refresh extracts faster: While Tableau has always optimized performance for creating and refreshing extracts, version 2020.3 supports faster extract creation and refreshes for even larger data sets.

3) Experience better performance when interacting with views that use extract data sources: Although smaller extracts continue to perform efficiently, larger extracts perform more efficiently.

To create a packaged data source (.tdsx file) in Tableau, you would right-click on the data connection in the Data pane and select the option to add it to saved data sources. This action packages the data source with the metadata that you've defined in Tableau, such as calculations, groups, and sets, so that you can easily share it with others. This does not package the data itself, which is a separate step if you're working with local file-based data.

With dimension filters in Tableau, you can use several filter modes, including "Multiple Values (drop-down)" which allows users to select one or more values from a drop-down list of all the dimension's members. Another mode is "Wildcard Match," which lets users filter the view by typing in a text box to match dimension members that contain the typed string. These filter types are particularly useful for string or categorical dimensions where users need to search or select specific members to display in the view.

Explanation

There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.

To create a dynamic set:

1) In the Data pane, right-click a dimension and select Create > Set.

2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:

General: Use the General tab to select one or more values that will be considered when computing the set.

You can alternatively select the Use all option to always consider all members even when new members are added or removed.

None of the other options exist, and therefore are incorrect answers.

In Tableau, when you initially add a measure to the rows shelf, you create one mark in the view that represents the aggregate value of that measure. When you then add a dimension with 11 members to the columns shelf, the view is subdivided into 11 separate marks, each representing the measure for one of the dimension members. This results in a total of 11 marks in the view after the dimension is added, one for each member of the dimension.

You should change the mark type of the view to configure the visualization as a density map. A density map is a type of mark that shows how data points are distributed in a two-dimensional space. To change the mark type, you can use the Marks card or Show Me. Changing the mark shape, creating a custom color palette, or selecting heat maps from Show Me will not create a density map2

Date values in Tableau represent specific points in time and are typically formatted in a standard date format.

Option A, "2020-05-01", is a standard date format representing the 1st of May, 2020.

Option D, "January 1, 1995", is another example of a date value, representing the 1st of January, 1995. Options B ("December") and C ("Wednesday") represent a month and a day of the week, respectively, but do not specify a particular date.

Explanation

Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.

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.

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.

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.

When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.

When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.

Web version:

Desktop Version:

For more information about color palettes, see Color Palettes and Effects.