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