Practice Test
True or False: The Highlighting action can be disabled for the entire workbook.
True
Which of the following chart type makes use of 'binned' data? Gantt Chart Bullet chart Histogram Treemaps
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.
Which of the following is not a Trend Line Model? Linear Trend Line Exponential Trend Line Binomial Trend Line Logarithmic Trend Line
A: Binomial According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau : 1) Linear Trend Line 2) Logarithmic Trend Line 3) Exponential Trend Line 4) Polynomial Trend Line 5) Power Model
Which of the following returns the Absolute Value of a given number? ABS(Number) CEILING(Number) FLOOR(Number) ZN(Number)
ABS(Number)
__________ is a technique in Tableau which will identify marks with similar characteristics Clustering Grouping Sets Union
Clustering
What will the following function return? LEFT("Tableau", 3) An error Tab eau ble
Tab
Question 18: Correct ________________ is hosted by Tableau to share our visualisations publically with the world. Tableau Reader Tableau Desktop Tableau Server Tableau Public
Tableau Public
What does the box in a box plot represent?
The interquartile range 1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range 2) The median is marked by a vertical line inside the box 3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard raIs it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? YES, we can do this with the help of a plugin NO, this is not currently possible in Tableau YES, we can do this with the help of a Web-Page object YES, we can do this with the help of Tableau Publicther than opening the system's web browser?
YES, we can do this with the help of a Web-Page object
True or False: It is possible to add a field to more than one hierarchy True False
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
You can create _______________ for members in a dimension so that their labels appear differently in the view. parameters duplicates copies aliases
aliases Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively? Red, Blue Orange, Blue Blue, Red Blue, Orange
Blue, Orange When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
For a relative date filter, the default anchor is _________________ The current time Today's date The target date The date we specify
Today's date Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
True or False : Bins can be created on dimensions
True Bin are a user-defined grouping of numerical data in the data source. According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.
True or False: All rows from both tables are returned in an INNER JOIN
False 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!
True or False: A reference line cannot be added from the Analytics Pane
False You can add a reference line to any continuous axis in the view. To add a reference line: Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another join blend concatenate union
union You can union your data to combine two or more tables by appending values (rows) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.
What does it imply if a field has a blue background? It is continuous It is discrete It is a dimension It is a measure
It is discrete When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
How do you identify a continuous field in Tableau? It is identified by a blue pill in the visualization It is identified by a green pill in a visualization It is preceded by a '=#' symbol in the data window It is preceded by a 'Abc' symbol in the data window
It is identified by a green pill in a visualization
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop. Tableau Reader Tableau Online Tableau Server Tableau Desktop
Tableau Reader The word 'static tool' gives it away.
Which data type in Tableau does this icon represent? T I F
Boolean
For creating variable sized bins we use __________________ Calculated Fields Table Calculations Sets Groups
Calculated Fields One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
______________ refers to the level of detail for a piece of data, wherever you are looking. Data Cleanliness Data granularity Data connectivity Data LOD
Data granularity
The default path for all supporting files, data sources, icons, logs etc is in ______________________ Documents -> Tableau Files Documents -> Tableau Documents -> My Tableau Repository Downloads -> Tableau Support Files
Documents -> My Tableau Repository
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
False It is possible in Tableau to use a sheet within a story directly. Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case. At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
True or False: Sets can be created on Measures True False
False Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source. They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.
Which of the following are valid ways to trigger actions for a Dashboard? Hover Click Select Menu Double click
Hover Select Menu Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)
Which of the following is the correct way to calculate Profit Ratio in Tableau? Profit / Sales Sales / Profit SUM(Profit) / SUM(Sales) SUM(Sales)/SUM(Profit)
SUM(Profit) / SUM(Sales)
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color Profit, State, Number of Records, Sales Region, Country, Profit, State Longitude, Country, State, Sales Sales, State, Country, Profit
Sales, State, Country, Profit Since Sales is a measure, it can easily be depicted via size. To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc. Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!
True or False: Trend lines can only be used with numeric or date fields True False
True
True or False: Context Filters are executed after Data Source filters
True Extract Filters Data Source Filters Context Filters Dimension Filters Measure Filters Table Calc Filters
Which of the following are interactive elements that can be added to a dashboard for users? URL Action Filter Action Highlight Action Edit Tooltip Action
URL Action Filter Action Highlight Action
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us 1 , 4 2 , 2 2 , 3 1 , 2
1 , 4 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)
For Bullet Graphs we need at least ____________ measures 3 1 2 4
2 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.
We can join a maximum of ______ tables in Tableau 16 32 64 128
32
What is the minimum amount of RAM recommended for any production use of Tableau Server? 8GB 16GB 32GB 64GB
32GB
Which of the following would you use to connect to multiple tables in a single data source at once? A Blend A Hierarchy A Set A Join
A Join 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.
A field that shows average home values for the United States in 2016 is most likely : A discrete date part dimension A continuous date value dimension A geographical dimension An aggregated measure
An aggregated measure This question is directly from the Official Tableau Desktop Specialist exam guide. Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES. Date part and Date values don't really make much sense given the question, and neither does geography. Therefore, the answer naturally is "An aggregated measure".
Which of the following are the options to export the data used to build the view / visualisations? CSV file PDF File JSON format MS Access Database
CSV file MS Access Database 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.
Which of the following is a good reason for using a bullet graph? Comparing the actual sales against the target sales Analysing the trend over a given time period Forecasting future sales Displaying the year-on-year growth in sales
Comparing the actual sales against the target sales 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.
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? Data source Filter Extract Filter Context Filter None of the these
Context Filter 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.
You can use the __________________ in Tableau to clean / organise your data. Data cleaner Data manager Data interpreter Data organiser
Data interpreter
Dates in Tableau are typically treated as ______________ Dimensions Measures
Dimensions
Which of the following are benefits of using Data Extracts in Tableau? Improved Performance Ability to use the data offline Working with freshest data at all times Faster to work with
Improved Performance (Correct) Ability to use the data offline (Correct) Faster to work with (Correct)
By definition, Tableau displays measures over time as a ____________ Packed Bubble Bar Stacked Bar Line
Line 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.
Which of the following 2 fields CANNOT be deleted in Tableau? Measure Names Number of Records Measure Values Calculated Fields
Measure Names Measure Values Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated. Calculated Fields, and Number of records can both be deleted.
Is SUM a table calculation?
No SUM is an aggregate function, not a table calculation! Running Total Percent Difference Difference Percent of Total Rank Percentile These can be calculated using : Table(across), Cell, or Specific dimensions!
The calculation [Ship Date] - [Order Date] will return _______________ 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
Number of days between these dates
The icon associated with the field that has been grouped is a ______________ Paper Clip Globe Intersection =#
Paper Clip
Which of the following charts types always includes bars sorted in descending order? Pareto Chart Pie Chart Gantt Chart Stacked Bar Chart
Pareto Chart A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line. On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order. On the secondary axis, a line graph is used to show the cumulative total in percent format.
The row and column shelves contain ___________________ Pills Grand Totals Filters Parameters
Pills (aka: fields) We can drag fields from the Data pane to create the structure for your visualizations. The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
By default, measures placed in a view are aggregated by ______________ COUNT AVERAGE MEDIAN SUM
SUM By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.
How would you calculate GDP per capita in Tableau? SUM([GDP]/[POPULATION]) SUM([Population]/[GDP]]) SUM([GDP]*[POPULATION]) SUM([GDP]) / SUM([Population])
SUM([GDP]) / SUM([Population])
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 .twm file Save it as a .twb file Save it as a .tds file Save it as a .twbx file
Save it as a .tds file 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.
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Tableau Packaged Workbook (.twbx) Tableau Workbook (.twb) Tableau Data Extract (.tde) Tableau Data Source (.tds)
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.
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source. Tableau Data Extract (.tde) Tableau Packaged Workbook (.twbx) Tableau Bookmark (.tbm) Tableau Workbook (.twb)
Tableau Packaged Workbook (.twbx) TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. Tableau Server Tableau Prep Tableau Public Tableau myServer
Tableau Server Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
This is true, indeed! The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead. True False
True Joins are used to combine data or rows from two or more tables based on a common field between them. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin. Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.
True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity
True Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu. If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source. To disaggregate all measures in the view: Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.
True or False: To concatenate fields, they must be of same data type
True Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use - Type casting
True or False: Tableau can create worksheet-specific filters
True Yes, it is possible to create worksheet-specific filters in Tableau. When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook. Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.
True or False: It is possible to change the Geographic Role of a dimension
True A geographic role associates each value in a field with a latitude and longitude value. Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
A Tableau Support case can be opened in which of the following valid ways? Using the Developer Community Forum Contacting Salesforce using their website Using the support option on the Tableau website Using the Tableau learn website Explanation
Using the support option on the Tableau website
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
Yes, it is very much possible to use measures in the same view multiple times. ex: using BOTH the Sum of the revenue and the AVG of the revenue in the same view!