Exam 1 Flashcards
Relationships are represented by \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ and operate at the \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_. - noodles, physical layer - Venn diagrams, physical layer - noodles, logical layer - Venn diagrams, logical layer
- noodles, logical layer
The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).
Reference: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm
Which of the following are valid objects when creating a dashboard in Tableau? Choose 4. - Extension - Image
- Video - Web Page - Text
- Extension - Image - Web Page - Text
- Download
- Navigation
- Blank
- Horizontal and Vertical Objects
Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_create.htm
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use? - None of the these - Data source Filter
- Context Filter
- Extract Filter
Context Filter
Explanation
IMPORTANT QUESTION, PAY ATTENTION
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. 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.
Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ the view. - break-down the measures - disaggregate the measures - aggregate the measures - split the measures - sort the measures
- disaggregate the measures
Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm
True or False: The Highlighting action can be disabled for the entire workbook. - False - True
True
For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
By definition, Tableau displays measures over time as a \_\_\_\_\_\_\_\_\_\_\_\_ - Stacked Bar - Bar - Line
- Packed Bubble
Line
Explanation
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm
By default, measures placed in a view are aggregated. The type of aggregation applied ______________
- is always sum
- is always AVERAGE - is always COUNT - depends on the context of the view
- depends on the context of the view
Explanation
By default, measures placed in a view are aggregated. Mostly you’ll notice that the aggregation is SUM, but not ALWAYS.
The type of aggregation applied varies depending on the context of the view.
Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm
True or False: All rows from both tables are returned in an INNER JOIN - True - False
False
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables “Orders” and “Customers”.
If there are records in the “Orders” table that do not have matches in “Customers”, these orders will not be shown!
Reference: https://www.w3schools.com/sql/sql_join_inner.asp
Which of the following shapes does a Heat Map use by default? - Line - Circle - Text - Square
Square
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_highlight.htm
Most viewers scan content starting at the \_\_\_\_\_\_\_\_\_\_\_\_\_ of a page. - top left - bottom right - bottom left - center - top right
top left
Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_best_practices.htm
For Bullet Graphs we need at least \_\_\_\_\_\_\_\_\_\_\_\_ measures - 1 - 3
- 4
- 2
2
(Correct)
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.
Therefore, we need at least 2 measures for creating bullet graphs.
Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_bullet_graphs.htm
You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement? - Save it as a .twb file - Save it as a .twm file - Save it as a .tds file - Save it as a .twbx file
Save it as a .tds file
(Correct)
Explanation
After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
.twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.
.twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region? - Dimension Filters - Measure Filters - Extract Filters - Context Filters
Context Filters
(Correct)
Explanation
The beauty of context filters is that according to Tableau’s Order of Operations, they are executed before Sets.
References: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm
Which of the following chart type makes use of 'binned' data? - Bullet chart - Histogram - Gantt Chart - Treemaps
Histogram
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm
Which of the following can you use to create a Histogram? - 2 measures - 2 dimensions - 1 measure - 1 dimension
1 measure
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_histogram.htm
Which of the following are compelling reasons to use a Stacked Bar Chart? (Choose 2)
- To easily visualize trends over time
- To be able to visualize complex information with fewer bars / marks
- To visualize parts of a whole
- To visualize each discrete category using a separate bar.
- To be able to visualize complex information with fewer bars / marks
- To visualize parts of a whole
Explanation
Stacked bar charts will usually have lesser number of bars compared to a normal bar chart:
Which of the following would you use to connect to multiple tables in a single data source at once? - A Blend - A Hierarchy - A Join
- A Set
- A Join
Explanation
The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.
Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm
Which of the following are stored in a .tds file? Choose 3. - Metadata edits - Data Connection information - Calculated Fields - Data Extracts - Visualizations
- Metadata edits
- Data Connection information
- Calculated Fields
Explanation
If you’ve created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you’ve added joined tables, default properties, or custom fields—such as groups, sets, calculated fields, and binned fields—to the Data pane.
Reference: https://help.tableau.com/current/pro/desktop/en-us/export_connection.htm
You just added this field to the Columns shelf.
SUM(Profit)
What will this create?
- A horizontal axis
- A vertical header - A vertical axis - A horizontal header
- A horizontal axis
Explanation
This question can be confusing for many students, so in such cases it’s always best to practically try the question out in Tableau. We know that continuous fields will always create an axis, so options stating ‘header’ are automatically eliminated. For our question, see below:
The default path for all supporting files, data sources, icons, logs etc is in \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ - Downloads -> Tableau Support Files - Documents -> My Tableau Repository - Documents -> Tableau Files - Documents -> Tableau
Documents -> My Tableau Repository
(Correct)
Explanation
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible? - Using 2 dimensions - Using 2 dimensions and 3 measures - Using 1 measure - Using 2 measures
Using 2 measures
(Correct)
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.
We can create a Bullet graph with just 2 measures! This method requires the LEAST number of fields possible to create this type of chart.
The best way to tackle such questions in the exam is to click the “SHOW ME” button on top right, and hover over the chart we want to create.
Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_bullet_graphs.htm
Which of the following is true about ‘Incremental refresh’ when creating Extracts in Tableau?
- There is no difference, both are the same when using extracts. They are different when using live connections.
- They can only be used with large datasets
- It replaces all of the contents in the extract
- It only adds rows that are new since the previous refresh.
It only adds rows that are new since the previous refresh.
Explanation
Imp question!
Extracts are saved subsets of data that you can use to improve performance or to take advantage of Tableau functionality not available or supported in your original data. 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.
Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- 2 , 3 - 1 , 4 - 1 , 2 - 2 , 2
1 , 4
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow.htm
Which of the following are benefits of using Data Extracts in Tableau? Choose 3. Working with freshest data at all times - Ability to use the data offline - Faster to work with - Improved Performance
- Ability to use the data offline - Faster to work with - Improved Performance
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!
Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
