Tableau Certification
Which of the following is a local copy of a subset or entire dataset that you can share with others? (select all that apply) a. .hyper b. .twbx c. .tds d. .tdsx e. .tde
.hyper or .tde Extract (.hyper or .tde) - Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files 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. Packaged Data Source (.tdsx) - Tableau packaged data source files have the .tdsx file extension. A packaged data source is a zip file that contains the data source file (.tds) described above as well as any local file data such as extract files (.hyper or .tde), text files, Excel files, Access files, and local cube files.
When exporting visualizations to PowerPoint, which extension should you select? i. .pptx ii. .ppt (.ppt is an older PowerPoint version and works with Office 2003) iii. .pot (Older template that you can open in PowerPoint 97) iv. .ppa (.ppa is an add-in that you can open in PowerPoint 97)
.pptx
What is the extension for packaged data in Tableau? a. .tdsx b. .hyper c. .tds
.tdsx
How many ways can you create a filter action on a dashboard? i. 1 ii. 2 iii. 3
2
How many ways can you add reference lines in Tableau? i. 1 ii. 2 iii. 3
2 Analytics tab and adding through measure when right clicking on the axis
How many ways can you create a calculated field in Tableau?
3
What does a filter action do on a dashboard? (select all that apply) a. Displays a hyperlink the user can click to access info online b. Highlights data in the view when the user hovers their mouse over data points c. Allows the user to filter the target sheet based on a selection on the source sheet d. Displays a card the user can use to adjust their filter selection on the dashboard
A, B, and C
What do you need to create for members in a dimension so that their labels appear differently in the view? a. Groups b. Sets c. Alias
Alias
Reference lines can be added from this pane. a. Format b. Data c. Predict d. Analytics
Analytics
_________ bring data from another data source into view without creating a formal relationship between the two data sources.
Blends
You can create a context filter to a. Create a dependent numerical or Top N Filter b. Both c. Improve performance
Both
How can you embed the web page into the dashboard? i. By adding a Web Page object ii. By adding a static URL iii. By adding a new browser tab
By adding a Web Page object
Density or heat maps work best when the specific locations ________. i. Are constrained to discrete locations like city or zip code. ii. Are spread out over a large area. iii. Are color coded. iv. Change continuously and smoothly across a limited space.
Change continuously and smoothly across a limited space
By default, what does Tableau do when you connect to a data source? a. Creates a live connection to the data b. Create an extract of the data c. Loads your actual file into Tableau d. Sorts the data in descending order
Creates a live connection to the data
When dragging charts into the Dashboard View, what does Tableau do automatically? i. Creates containers ii. Floats the charts iii. Tiles the charts
Creates containers
Text tables are also known as (select all that apply) a. Cross tabs b. Pivot tabs c. Pivot tables d. Cross tables
Cross tabs Pivot tables
If you want to control your Filter Action, you can add an action by selecting "action" under what main top tab? i. Analysis ii. Dashboard iii. Story
Dashboard
To add a new device layout to your dashboard, which feature do you select? i. Device Preview ii. Layout Hierarchy iii. Dashboard Size
Device Preview
A bar chart is converted to stacked bar chart by adding a. 2 Measures b. Dimension c. Measure
Dimension
Dates in Tableau are typically treated as ______________. a. Dimensions b. Measures
Dimensions
Date pill in blue means that it is what? a. Unsure b. Continuous c. Discrete
Discrete
Stories are often used in what? i. Explanatory visualizations ii. Exploratory visualizations
Explanatory visualizations
Select the order in which the following filters are executed : a. Dimension, extract, and context filters b. Extract, context, and dimension filters c. Extract, dimension, and context filters
Extract, context, and dimension filters ORDER: Extract filters, data source filters, context filters, dimension filters, measure filters, Table calc filters
A reference line cannot be added from the Analytics Pane True or False
False
All rows from both tables are returned in an INNER JOIN. True or False
False
When you have a top filter that limits the number of items shown, and this limit is set by a parameter, what happens when you decrease this parameter? i. More top items will show ii. The same top items will show iii. Fewer top items will show
Fewer top items will show
Which of the following results in a table that contains all values from both tables. a. Full Outer b. Right c. Left d. Inner
Full Outer
What action is needed to use hyperlinks to external resources, such as a web page, file, or another Tableau worksheet. a. Highlight b. Go to URL c. Go to Sheet d. Filter
Go to URL
Which option is not a dashboard sizing option available in Tableau to visualize? a. Grid b. Fixed c. Automatic d. Range
Grid
Which of the following URL prefixes are allowed in Dashboard Actions (select all that apply) a. HTTPS b. Local Host c. FTP d. HTTP
HTTPS, HTTP, and FTP
Which of the following allows a conditional formatting which lets you compare a column or row with rest of the table? a. Text table b. Bar Chart c. Cross tab d. Highlight table
Highlight table
A .twbx can be shared as what? (select all that apply) a. Image b. PDF c. Doc d. PPT
Image, PDF, PPT
What is used to create a symbol map? i. A map in a geographic area ii. Individual symbols iii. A filled-in outline
Individual symbols
Blend resembles this join a. Union b. Right c. Left
Left
What does it imply if a field has a blue background? a. It is discrete b. It is a measure c. It is continuous d. It is a dimension
It is discrete
What tab do you click on to see the container hierarchy on a dashboard? i. Dashboard tab ii. Layout tab
Layout tab
Business data almost always uses what model type? i. Exponential ii. Polynomial iii. Linear
Linear
Which of the following Tableau view will update based on changes to the underlying data? a. Live b. Extract c. Live + Extract
Live
Which of the following types of data would most likely be represented as measures in Tableau Desktop? (select all that apply) a. Numerical totals b. Names of people c. Quantities d. Years
Numerical totals and Quantities
The "#" represents the following datatype in Tableau. a. Boolean b. Date c. Text d. Numerical values
Numerical values
What is used to connect times together in order to form a narrative? i. Marks ii. Filters iii. Pages
Pages
___________ are the default way of combining data in Tableau. They provide a flexible relationship (not as rigid) as Joins (which can drop unmatched values from the newly combined table).
Relationships
Which of the following is the correct way to calculate Profit Ratio in Tableau? a. SUM ( [ Profit ] ) / SUM ( [ Sales ] ) b. SUM ( [ Sales ] ) / SUM ( [ Profit ] ) c. [ Profit ] / [ Sales ] d. [ Sales] / [ Profit ]
SUM ( [ Profit ] ) / SUM ( [ Sales ] )
To access the floating order of an element on your dashboard, you must i. Drag and drop onto the view ii. Select "Floating Order" in the drop-down menu of the element iii. Reposition on the dashboard
Select "Floating Order" in the drop-down menu of the element
Which of the following can be used when classifying based on a Condition or Top criteria? a. Set b. Group c. Hierarchy
Set
Which sorting option is not directly available to choose in the Sort dialog box? i. Sort by the field value. ii. Sort by the dimension alphabetically. iii. Sort by the dimension text length. iv. Sort manually.
Sort by the dimension text length
Which of the following are pre-defined aggregations? (select all that apply) a. Sum b. Countd c. Total d. Avg
Sum, Countd, and Avg
What is the default aggregation in Tableau? Can it be changed? a. Avg, Yes b. Avg, No c. Sum, No d. Sum, Yes
Sum, Yes
________________ is hosted by Tableau to share our visualizations publicly with the world. a. Tableau Public b. Tableau Desktop c. Tableau Server d. Tableau Reader
Tableau Public
What are the two methods Tableau uses to determine seasonality in forecasting? a. Linear and non-linear b. Temporal and non-temporal c. Seasonal and non-seasonal d. Granular and non-granular
Temporal and non-temporal
When creating a calculation in Tableau, what will you first select? i. The calculation ii. The input iii. The function
The function
To apply bold text formatting to rows or columns independent of each other use: a. The rows tab or the columns tab on the format font pane b. The sheets tab on the format font pane c. Text on the marks card d. The edit axis dialog box
The rows tab or the columns tab on the format font pane
To improve the readability of a font in a visualization you can a. Increase the font color intensity relative to the background b. Use bolding on the font c. Increase the size of the font d. Use a strikethrough font
Use bolding on the font Increase the size of the font
When can the linear trend lines be considered significant? a. When p-value <=0.05 b. When t-value >=0.5 c. When R-squared >=0.05 d. When the standard error <=5.0
When p-value <=0.05
When would be the best time to use data blending rather than join? a. When data blending is the only option available b. When you are unable to combine data sources through JOIN c. When JOIN doesn't give the flexibility required d. When you need to avoid data duplication without losing unrelated data
When you need to avoid data duplication without losing unrelated data
Geographic coordinates (latitude and longitude) no longer make sense when using a background image, instead, you should use what? i. Coordinates ii. X, Y values iii. Other images
X, Y values
Can custom shapes be imported into Tableau? Can they be used as filters? a. No, Yes b. No, No c. Yes, Yes d. Yes, No
Yes, Yes
You can create _______________ for members in a dimension so that their labels appear differently in the view. a. parameters b. aliases c. copies d. duplicates
aliases
What can you do to better see the containers that you are making? i. Change the hierarchy ii. Change the background color iii. Rename the container iv. Change the position
change the background color
What type of axis do you need to use the analytics pane in Tableau? i. Discrete ii. Continuous
continuous
Adding which one of the following will make a bar chart into a stacked bar chart? a. both dimension and measure b. none c. dimension only d. measure only
dimension only
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. a. disaggregate the measures b. break-down the measures c. sort the measures d. aggregate the measures
disaggregate the measures
Dimensions are mostly a. continuous b. discrete
discrete Dimensions can be both discrete and continuous. However, as the question says "mostly", Discrete is the right answer. Discrete dimensions and Continuous measures are most common.
Assuming that both the table structures are same, Union of two tables will result in a. increase in number of columns b. increase in number of rows c. decrease in number of rows d. decrease in number of columns
increase in number of rows
To create calculations in dialog boxes, which tab do you select in the Filter dialog box? i. The Top tab (The Top tab is used to define a formula that computes the data that is included in the view.) ii. The Wildcard tab (The Wildcard tab is used to define a pattern to filter on (i.e., values in a field - names that include 'th' for example.) iii. The General tab (The General tab is used to select the values you want to include or exclude.) iv. The Condition tab (There are four tabs in the dialog box and the Conditions tab is used to define rules to filter by.)
the Condition tab (There are four tabs in the dialog box and the Conditions tab is used to define rules to filter by.)
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another. a. union b. chain c. blend d. join
union
We can join a maximum of ______ tables in Tableau. a. 64 b. 16 c. 32 d. 128
32
If "stepped color" is selected as 5, how many variations of color is seen? a. 5 b. 4 c. 1 d. 6
5
What is the difference between a packaged workbook and a regular Tableau workbook? i. A standard Tableau workbook maintains a connection to external data while a packaged workbook includes all the data. ii. A standard Tableau workbook connects the user directly to the data by using the free Tableau Viewer. iii. A packaged workbook allows a user to see the data but not access the data.
A standard Tableau workbook maintains a connection to external data while a packaged workbook includes all the data.
Which of the following are generated fields in Tableau? (select all that apply) a. Measure Values b. Longitude c. Measure Names d. Latitude
All the above
When adding a highlight action, what do you always have? i. A name, a source, and a target ii. An action, a source, and a target iii. An action and a source iv. An action and a target
An action, a source, and a target
A field that shows average home values for the European Union in 2016 is most likely : a. A geographical dimension b. A continuous date value dimension c. An aggregated measure d. A discrete date part dimension
An aggregated measure
What are reference lines a property of? i. A row ii. A column iii. A sheet iv. An axis
An axis
In which of the following scenarios would having a live connection be more beneficial than using an extract? (select all that apply) a. Analyzing historical housing prices b. Analyzing and tracking real time flight c. Analyzing real time data from production systems d. Analyzing real time stock prices
Analyzing and tracking real time flight Analyzing real time data from production systems Analyzing real time stock prices
When finding an X, Y value, which feature in Tableau helps you find the coordinates? i. Annotate ii. Tool bar iii. Drop lines
Annotate
The size of the Marks is not significant in which chart type? a. Area chart b. Pie chart c. Line chart d. Bar chart
Area chart
Which of the following are common default properties for every measure or dimension? (select all that apply) a. Color b. Number format c. Shape d. Comment
Color and Comment maybe number format?
When implementing a Level of Detail (LOD) expression, what do you use to indicate the calculation that is occurring at the different level of detail? i. Curly brackets (LODs are a special type of calculation in Tableau that must include curly brackets.) ii. Square brackets (Square brackets might be used with LODs, but not to indicate the calculation that is occurring and the different level of detail.) iii. Parentheses (Parentheses might be used with LODs, but not to indicate the calculation that is occurring and the different level of detail.) iv. Quotation marks (Quotation marks might be used with LODs, but not to indicate the calculation that is occurring and the different level of detail.)
Curly brackets (LODs are a special type of calculation in Tableau that must include curly brackets.)
Which of the following are valid datatypes (select all that apply) a. Date Time b. Date Year c. Date Month d. Date
Date Time Date
What types of metadata are stored in a Tableau data source .tds file? (select all that apply) a. Copies of local file based data b. Default field properties c. Calculated fields d. Data source type
Default field properties Calculated fields Data source type
Granularity depends on which one of the following. a. Measures only b. Measures and dimensions c. Dimensions only
Dimensions only Granularity is synonymous to level of detail. The easiest way to check is to have a dimension and measure pulled on a chart. Now, bring on another dimension to see that the level of detail will increase. Hence, dimension is the right answer.
When using a bar chart with a dimension on the columns shelf and a measure on the rows shelf, how can you make a stacked bar chart? a. Drag another dimension to label on the marks card b. Drag another dimension to size on the marks card c. Drag another measure to the left of measure values on the rows shelf d. Drag another dimension to color on the marks card
Drag another dimension to color on the marks card
Which of the following are interactive elements that can be added to a dashboard for users? (select all that apply) a. Edit tooltip action b. Filter action c. URL action d. Highlight action
Filter action, URL action, and Highlight action
Which of the following views in dashboard might overlap? a. Tiled b. Floating c. Floating + Tiled
Floating
This datatype can be both discrete and continuous (select all that apply) a. Geographic b. Dates c. Strings d. Boolean
Geographic and Dates
If you are using a tiled container in your dashboard, where does everything go? i. Inside a grid ii. Inside a URL iii. Inside a table
Inside a grid
Which two scenarios would benefit most from mapping on a custom background image? i. Hiking in the woods ii. Made and missed shots on a basketball court iii. Areas clicked on a webpage iv. Traffic accidents at intersections
Made and missed shots on a basketball court Areas clicked on a webpage
How can you MANUALLY assign geographic roles to a dimension from the data pane? a. Edit the config file in My Documents > MyTableauRepository for a quick fix b. Right click the dimension > Edit default properties > Assign geographic roles c. Edit the data source manually for a quick resolution d. Right click the dimension > Geographic role > and then assign the appropriate geographic role
Right click the dimension > Geographic role > and then assign the appropriate geographic role
How do you apply an annotation to a mark? i. Right-click the mark and select Annotate ii. Drag to add text iii. Layout caption boxes
Right-click the mark and select Annotate
Given a map, which of the following fields can be placed on Size, Shape, Detail, Color? a. Longitude, Country, State, Sales b. Sales, State, Country, Profit c. Region, Country, Profit, State d. Profit, State, Number of Records, Sales
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!
A visual group can be created by (select all that apply) a. Select the marks from left pane and use groups b. Select the marks, right click, create group c. Select the marks and click on the group icon on the top d. Select the marks, click on worksheet, then group
Select the marks, right click, create group Select the marks and click on the group icon on the top
Which of the following are valid ways to trigger actions for a Dashboard? (select all that apply) a. Select b. Menu c. Click d. Double click e. Hover
Select, Menu, and Hover
Text is not treated as Null when Mapped datatype is a. Numbers b. Boolean c. Dates d. Text
Text
To create a nested sort, which feature should you change in the Sort dialog box? i. The Sort by feature ii. The Field Label feature iii. The Legends feature iv. The Sort Order feature
The Sort by feature
By default, what must you use to create your map in Tableau? i. The destination latitude and longitude ii. Latitude and longitude for both the origins and destinations iii. The origin latitude and longitude
The destination latitude and longitude
Which icon symbolizes the data type is geographic data that can be mapped? i. The globe icon ii. The hashtag icon iii. The legend icon
The globe icon
If you are working with a huge dataset, which of the following are strong reasons to use a context filter? (select all that apply) a. To make the context filter a dependent filter b. To include only the data of interest c. Improve query performance d. To help clean the story
To include only the data of interest Improve query performance
When is saving your workbook as a PDF file beneficial? i. When you want to send your documents but not have any interaction ii. When you want to use your data to create web pages (HTML is usually the data format used to create web pages.) iii. When you want to describe the contents of documents (XML, the eXtensible Marksup Language, is a data format that can be used to describe the content of documents.) iv. When you want to describe a single page or a document containing multiple pages (XPS (XML Paper Specification) is a page description language that can describe a single page or a document containing multiple pages.)
When you want to send your documents but not have any interaction
The icon associated with the field that has been grouped is a ______________. a. equal b. Intersection c. paper clip d. globe
paper clip
To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs. a. sets b. values c. inputs d. parameters
parameters
If you union two tables with different field names, what will be the result? a. Both fields will be aggregated together into a single column b. Both fields will appear and the union with null values c. Only the first field will be included in the union d. Values for both fields will be duplicated
Both fields will appear and the union with null values
Which of the following is a good reason for using a bullet graph? a. Forecasting future sales b. Displaying the year-over-year growth in sales c. Comparing the actual sales against the target sales d. Analyzing the trend over time
Comparing the actual sales against the target sales
Our scenario 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? a. Extract filters b. Measure filters c. Context filters d. Dimension filters
Context filters
For which of the following charts, does the Size option on the Marks card not work? a. Gantt Chart b. Pie Chart c. Bar Chart d. Tree Map
Tree Map
Which of the following chart types uses automatically generated sizes that cannot be resized by using the marks card? a. Tree maps b. Gantt views c. Heat maps d. Pie charts
Tree maps
A story can have multiple dashboards included. a. True b. False
True
Actions allow you to combine sheets together to work as an overall dashboard. (T/F)
True
Color palettes are different for dimensions and measures. a. True b. False
True
For any aggregate calculation, is it true or false that you cannot combine an aggregated value and a disaggregated value? a. True b. False
True
If the measure is not aggregated, all the individual values from the underlying view are seen. a. True b. False
True
In Tableau, bins can be used for continuous measure. True or False
True
Options for dimensions and measures will differ during filtering. a. True b. False
True
When you create bins from a measure, you create a new dimension. a. True b. False
True
While building dashboards, strings, and dates slow the performance down more than numbers and Booleans? True or False
True
You can bold the axis in a chart. a. True b. False
True
You can have both a filer and a URL action by making use of either "select" or "menu" in your action. (T/F)
True
You can manually sort data using a legend. True or False
True
Can you add all subtotals to data with sets? i. Yes, but only if all sets include single items (subtotals will work for sets with any number of items) ii. Yes, the subtotals will show the total of every set iii. No, subtotals cannot be used with sets iv. No, a single subtotal will show for the entire data
Yes, the subtotals will show the total of every set