You create the following visualization. What is the first step to create the visual grouping of the 10 marks shown in blue?
Correct Answer: A
To create a visual grouping of the top 10 marks shown in blue, the first step is to select the desired 10 marks directly in the view. Once selected, you can then use options such as creating a group or set from the selected marks to differentiate them visually in the chart. This selection method provides an efficient way to highlight or isolate specific data points based on the view itself.
Question 82
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
Correct Answer: C
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.
Question 83
Tableau will automatically create a hierarchy for which two kinds of data? Choose two.
Correct Answer: A,D
Tableau will automatically create a hierarchy for date and geographic data. A hierarchy is a way of organizing data into different levels of detail. For example, a date hierarchy can have year, quarter, month, and day levels. A geographic hierarchy can have country, state, city, and zip code levels. Tableau recognizes date and geographic data based on their data types and formats, and creates hierarchies for them by default. Tableau does not automatically create hierarchies for date & time or string data3
Question 84
How can you format numbers in Tableau as currency?
Correct Answer: A
According to the official Tableau documentation:
Question 85
If you see the following Filter, then you're working with _______________________ Larger image
Correct Answer: D
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display. The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values. Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter. Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.
