tableau

If you use a percent difference Quick Table Calculation, what value will be the first data value?

null

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

.hyper

_________________ 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.

.tde files

________________ files are shortcuts for quickly connecting to the original data that you use often. 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.

.tds

A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

.twbx file

When using Animations in a Tableau, which of the following is the default duration for animations?

0.3s

Which of the following can you use to create a Histogram?

1 measure

What type of fields, and how many, do you need to build a heat map?

1 or more dimensions & 1 or 2 measures

(Highlight tables) Build a highlight table that shows profit for department and category by region and subregion

1. From Measures, drag Profit to Text on the Marks card 2. From Measures, drag Profit to Color on the Marks card 3. On the Marks card, change the mark type to Square 4. From Dimensions, drag Department and Category to Rows, placing Category on the right 5. From Dimensions, drag Region and SubRegion to Columns, placing SubRegion on the right

The View Data window displays as much of the data as possible by default, up to _______________ rows.

10000

Creating a scatter plot requires a minimum of how many measures?

2

As a general best practice, how many categories can a pie chart display effectively?

2 to 5

What is the minimum amount of RAM recommended for any production use of Tableau Server?

32GB

Which of the following would you use to connect to multiple tables in a single data source at once?

A Join

Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

A new mark (bar) is created, which consolidates all members of the group

What is a story point in Tableau?

A single worksheet or dashboard

Which of the following returns the Absolute Value of a given number?

ABS(Number)

You can create _____________ for members in a dimension so that their labels appear differently in the view.

Aliases

Which menu tab enables you to unselect Aggregate Measures?

Analysis tab

_____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

Area

Which of the following is not a Trend Line Model?

Binomial Trend Line

When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Blue, Orange

Which data type in Tableau does this icon represent? (T|F)

Boolean

When field names in the Union do not match, then:

Both field names are present in the Union, but contain several null values

How can you change the default Tableau repository location?

By clicking on File -> Repository Location and choosing a new location

If you have a dashboard and are displaying its filter, how can you rearrange it?

By clicking on the 2 lines on top and dragging the filter

Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?

By dragging another dimension to Color on the Marks card

How can you format an axis as Bold in Tableau?

By right clicking on the axis, choosing format, and then setting its font to bold

How can you change the Default Aggregation for a measure in Tableau?

By right clicking the measure -> Default properties and choosing Aggregation

Which of the followings are the options to export the data used to build the view / visualizations?

CSV file, MS Access Database

What information is stored in a .tds file? Choose all that apply.

Calculated Fields, Metadata edits, Data Connection information

Which of the following fields would be best used as Dimensions?

Categories, Names

Which type of change to the source data requires you to replace references?

Changing titles of fields used in the view

What are the three areas on the Marks card that are used to build a highlight table?

Color, Text (Label), and Mark Type area

Which of the following sets would you use to compare the members?

Combined Sets

Which of the following is a good reason for using a bullet graph?

Comparing the actual sales against the target sales

Which of these steps is required before you can create visualizations with your data? Select one answer

Connect to a data source

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?

Context Filter

When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Continuous

Select the geographic information types that Tableau can geocode by default

Country names and Postal codes

When you clicked Sheet 1 from the Data Source page, you opened the Tableau Desktop workspace. What's the main thing you do here?

Create visualizations to help analyze your data

By default, what does Tableau do when you connect to data?

Creates a live connection to the data

By default, what does Tableau do when you connect to a data source?

Creates a live connections to the data

_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

Data Blending

We have one more question for you, and you'll need to open your saved data source. What information is stored in the .tds file? Check the three correct answers

Data connection information, Metadata edits, Calculated fields

If you see the following Filter, then you're working with _______________________

Date Values

________________ can only create header. _______________ will create header and axis both.

Dimensions, Measures

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.

Disaggregate

What do the colours Blue and Green represent in Tableau?

Discrete and Continuous

Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

Discrete value, continuous value

When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Diverging

You've connected to your data source, and you want to use data in the Returns sheet. What do you do next?

Drag or double-click Returns to place it on the canvas

Which of the following are valid objects when creating a dashboard in Tableau?

Extensions, Text, Image, Web Page

According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

Extract Filter

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.

F

True or False: All rows from both tables are returned in an INNER JOIN

F

True or False: Sets can be created on Measures

F

Which answer best defines dimension fields?

Fields that contain qualitative data or categorical data, such as product name or city

What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

Fields used in Blends must first be aggregated

How can you add color to marks in the view in Tableau?

From the Data pane, drag a field to Color on the Marks card

A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Go to URL

Which of the following is NOT a valid official data source in Tableau Desktop?

Google Firebase

For a combined axis, what type of icon appears when COGS is dropped on the left axis?

Green double rulers

Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

HTTP, HTTPS, FTP

If you see a Blue field, generally it will add _____________ to the view

Headers

Which of the following chart type makes use of 'binned' data?

Histogram

Which of the following are valid Layout Container types when using Dashboards in Tableau?

Horizontal Container, Vertical Container

Which of the following are valid ways to trigger actions for a Dashboard?

Hover, Select, Menu

Suppose I have the following view (One discrete at column side, and one continuous value at row). What will we the total number of marks if I drag a new measure to the row shelf vs the column shelf?

If dragged to row shelf: 14 marks; If dragged to column shelf: 7 marks

Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

If we want a static view of the visualization

Which of the following are benefits of using Data Extracts in Tableau?

Improved Performance, Ability to use the data offline, Faster to work with

You want to add Custom shapes to your visualisation. Where can you add these new shapes?

In My Documents -> My Tableau Repository -> Shapes

Which of the following is a valid way to create Sets in Tableau?

In the Data pane, right-click a dimension and select Create > Set

A union of two tables usually results in an _____________________

Increase in the number of rows

What does it imply if a field has a blue background?

It is a discrete

How do you identify a continuous field in Tableau?

It is identified by a green pill in a visualization

Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

It only adds rows that are new since the previous refresh

The row and column shelves contain

Pills

Data blending simulates a traditional _________________ Join

Left

For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Manual

Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Marks Card

Which one of the following is a dimension?

Measure Names

Which of the following 2 fields CANNOT be deleted in Tableau?

Measure Names, Measure Values

Which of the following can you add a reference line to?

Measures, Calculated Fields

Are animations enabled by default in Tableau?

No

Is SUM a table calculation?

No

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

No

Do calculated fields edit the existing fields in the underlying data source?

No, calculated fields add data within Tableau, without changing the underlying data

To use a quick table calculation, which of the following programming languages do you need to know?

None of these

Which of the following is an example of a Date Part?

November

You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

Parameters

Which of the following charts types always includes bars sorted in descending order?

Pareto Chart

When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Portable Network Graphic (.PNG), Windows Bitmap (.BMP), JPEG Image (.JPG, .JPEG)

Which of the following are valid Dashboard size options?

Range, Fixed Size, Automatic

Which of these is NOT a type of Quick Filter available in Tableau?

Regex Match

When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Remote Field Name, Field Name

How can you MANUALLY assign geographic roles to a dimension from the data pane?

Right click it -> Geographic role -> and then assign the appropriate geographic role

How can you format numbers in Tableau as currency?

Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu

Which of the following is the correct way to calculate Profit Ratio in Tableau?

SUM(Profit) / SUM(Sales)

How would you calculate GDP per capita in Tableau?

SUM([GDP]) / SUM([Population])

Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Sales, State, Country, Profit

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 .tds file

Which of the following is NOT a new feature introduced in Tableau 2020.1?

Set Control

Which of the following shapes does a Heat Map use by default?

Square

Dimensions containing ____________ and ____________ values cannot be continuous.

String, Boolean

What is the one most important thing you should do after creating a Dual-axis chart?

Synchronize the axis

True or False : Bins can be created on dimensions

T

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.

T

True or False: A reference line cannot be added from the Analytics Pane

T

What will the following function return? .. LEFT("Tableau",3)

Tab

What is the best description of how Tableau makes a live connection to your data?

Tableau maintains a connection to the data source, so data refreshes in the workbook

To connect Tableau to a CSV data source what type of connection should you use?

Text

What best describes the role of the Measure Names field in the structure of this crosstab?

The field creates the columns of data

What does the box in a box plot represent?

The interquartile range

Which of the following options best describe measures?

They are numerical, quantitative

Why did we use one view in the dashboard as a filter for the other view?

To filter measure values by the sub-category users are interested in

Which of the following is a benefit of using a Tableau Data Source (.tds)?

To 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 etc

What does the following marker/icon do in Tableau?

Toggle the highlighting on/off

Most viewers scan content starting at the _____________ of a page.

Top left

In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

Top left, Bottom right

For which of the following charts, does the Size option on the Marks card not work?

Tree Map

True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.

True

True or False: You get different filtering options for categorical and quantitative data

True

Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.

Type, role

______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Unioning

Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Using 2 measures

Which of the following are valid ways to add Totals to a view?

Using the Analytics Pane, From the Analysis Tab in the Menu bar on top

A Tableau Support case can be opened in which of the following valid ways?

Using the support option on the Tableau website

How does Tableau know at which level to aggregate values?

Values are always aggregated at the level of granularity of the worksheet

Which of the following calculations DO NOT need a quick table calculation?

Variance, Standard Deviation

When is an axis created for the visualisation in Tableau?

When we drag a continuous field to the row/column shelf

When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Wildcard Search

Is 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 Web-Page object

Is it possible to make a Measure discrete?

Yes

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Yes

Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Yes

This view was built to find out what day of the week had the most Sales last year. Which of these answer choices was most likely used to create the view?

è A date part of weekday

Which of the following are valid ways to copy a worksheet visualisation as an image?

è By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy -> Image è By right clicking on the worksheet visualization and selecting Copy -> Image

Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?

è Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option è Right click on Rows or Columns, and choose format. In the Font option click on Bold

Which of the following are valid ways to show Mark Labels in the visualisation?

è Click on Analysis in the Menu bar and choose Show Mark Labels è Drag the measure to the Text label in the Marks Card è Click on the Show mark labels icon in the Toolbar

Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

è Click on Dashboard in the Menu bar followed by Copy Image

Which of the following are valid ways to italicize Tooltip content in Tableau?

è Click on Tooltip in the Marks card, select the text, and then use the Italics option è Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option è Click on Format in the Men bar, choose Font, and then edit the Tooltip options to italicize the font

Which of the following are valid ways to Bold the Tooltip content in Tableau?

è Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option è Click on Tooltip in the Marks card, and select bold è Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold

You may create a context filter to:

è Create a dependent numerical or top N filter è Improve performance

Which of the following are true about dimensions?

è Dates are mostly placed in dimensions by default for relational data sources è They affect the level of detail in the view è They contain qualitative values (such as names, dates, or geographical data)

Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into ______________

è Dimensions and Measures

To build the view shown, with Quarter on an axis and Weekday as panes, how would these two date fields be arranged on the Columns shelf?

è Discrete weekdays before continuous quarters

Which of the following are valid ways of Grouping Data?

è From the Dimensions Shelf è Using Labels in the View è Using Marks in the view

Which of the following are valid ways to make the font more readable in Tableau?

è Increase the font size è Make the Font color sharper / darker than the background è Use a clear and readable font

Which of the following are benefits of combining sheets using dashboards?

è Provides the ability to use one sheet as a filter for other è Easier to compare visualizations side by side è Helps in faster analysis

True or False: Context Filters are executed after Data Source filters

T

True or False: It is possible to add a field to more than one hierarchy

T

True or False: It is possible to blend axes for multiple measures into a single axis

T

Which of the following are true about Dashboards in Tableau?

è Tiled items don't overlap è Floating items can be layered over other objects è A bar chart can be used a floating item

If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

è To include only the data of interest è Improve query performance

Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

è To support additional functionality such as count distinct è Fast to create è Help improve performance

When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

Default, Phone, Tablet, Desktop

A Tableau Data Source File (.tds) contains which of the following?

Default Field Properties, Data Source Type, Calculated Fields

True or False: It is possible to change the Geographic Role of a dimension

T

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

T

True or False: Tableau can create worksheet-specific filters

T

True or False: The Highlighting action can be disabled for the entire workbook.

T

True or False: To concatenate fields, they must be of same data type

T

True or False: Trend lines can only be used with numeric or date fields

T

True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

T

Which of the following are interactive elements that can be added to a dashboard for users?

URL Action, Filter Action, Highlight Action

How can you add more marks to your view?

Use a dimension to add a level of detail