Tableau Objective

Question: What are the different ways of opening Tableau Prep Builder?

Via the Windows Start menu search

Via the desktop shortcut

Via the Notifications pane

Via the taskbar shortcut

Ans- Via the Windows Start menu search

Via the desktop shortcut

Via the taskbar shortcut

Question: What are the two panes that appear on the Tableau Prep start page?

Profile

Connect

Discover

Share

Ans- Connect

Discover

Question: What will happen to your flow when you connect an Excel workbook that contains a single table?

The table will be added to the Flow pane automatically

An alert will display in the Alert pane

Ans- The table will be added to the Flow pane automatically

Question: List the steps to set up a new flow using a server-based data source connection.

Select the desired server type
Browse to the To a Server section
Click the Plus icon next to Connection to expand the Connections pane
Sign in to the server-based source using existing user credentials

Ans- Browse to the To a Server section

Sign in to the server-based source using existing user credentials

Question: How is the Data Interpreter tool activated in Tableau Prep Builder?

Via the Use Data Interpreter checkbox, in the Connection pane

By right-clicking the Input step in the Flow pane and selecting Use Data Interpreter

Via the Use Data Interpreter command in the File menu

Question: How is the Data Interpreter tool activated in Tableau Prep Builder?

Via the Use Data Interpreter checkbox, in the Connection pane

By right-clicking the Input step in the Flow pane and selecting Use Data Interpreter

Ans- Via the Use Data Interpreter command in the File menu

Question: What are some of the text settings that can be configured at the Input step?

Font & Formatting

Field Separator

Character Set

Text Qualifier

Ans- Field Separator

Character Set

Text Qualifier

Question: What are some of the field settings that can be configured at the Input step?

Exclude one or more fields from the flow

Rename a field

Color code fields

Add a description to a field change

Ans- Exclude one or more fields from the flow

Rename a field

Add a description to a field change

Question: List the steps to activate data role validation in a flow.

Add a Clean step
Open the Data Type menu for the desired field
Select an option under the Data Role heading

Ans- Add a Clean step
Open the Data Type menu for the desired field
Select an option under the Data Role heading

Question: Match each item with its matching statement.

A:The open flow file has unsaved changes
B:The flow is saved as a packaged flow file
C:The flow file does not contain a copy of the original source data

An asterisk is visible next to the flow filename in the title bar

A

B

C
Ans- A

The flow file has a .tflx extension

A

B

C
Ans- B

The flow file has a .tfl extension

A

B

C
Ans- C

Question: What file types can you add to an open flow via the Add Flow browser window?

Tableau Extracts

Locally stored flow files

Copied flow steps saved to the clipboard

Flow files saved to a Tableau Server

Ans- Locally stored flow files

Flow files saved to a Tableau Server

Question: What does the lightbulb icon in the Profile pane in a Clean step represent?

Ideas and notes can be added to this field

Tableau Prep has recommendations for cleaning your data

Ans- Tableau Prep has recommendations for cleaning your data

Question: What happens when you mouse-over a change icon in the List View?

A help window appears with links to the Tableau Website

Information about the change is shown in the tooltip

Ans- Information about the change is shown in the tooltip

Question: Which of the following statements are true?

You can change the color of individual steps in the Flow pane

You can copy individual changes from one step to another

You can change the size of individual steps in the Flow pane

Ans- You can change the color of individual steps in the Flow pane

You can copy individual changes from one step to another

Question: What does the square icon inside the Flow Navigator do?

Fits the flow to the window size

Minimizes the Flow Navigator

Ans- Fits the flow to the window size

Question: What does clicking the Changes icon inside a step do?

Re-directs you to the Changes pane where you can see details of the change

Highlights all steps containing similar changes

Ans- Re-directs you to the Changes pane where you can see details of the change

Question: Match each tab from the Date Range Filter with its correct description.

Answer Options:
A:Minimum Tab
B:Range Tab
C:Maximum Tab

Includes only values <= a maximum value

A

B

C

Ans- C

Includes only values >= a minimum value

A

B

C

Ans – A

Includes values between two dates

A

B

C
Ans – B

Question: Which of these are join types that can be used in Tableau Prep?

Double Join

Dovetail Join

Right unmatched only

Full Outer Join

Central Join

Inner Join

Ans- Right unmatched only

Full Outer Join

Inner Join

Question: Where can you see mismatched fields that have been created following a union operation?

In the Union Results pane of the step

In the step description

Ans – In the Union Results pane of the step

Question: How can you change pivoted field names in Tableau Prep?

By editing the source file containing the original data

By double-clicking the name of the pivoted field in the Pivoted Fields pane

Ans –
By double-clicking the name of the pivoted field in the Pivoted Fields pane

Question: How can you refresh your data to update your wildcard pivot in Tableau Prep Builder?

Re-connect your data source from the Connections pane

Save your changes to the source file and click the Refresh button in the Tableau Prep toolbar

Wait 1 minute after making changes to your source file

Ans –
Re-connect your data source from the Connections pane

Save your changes to the source file and click the Refresh button in the Tableau Prep toolbar

Question: What is performing a row-to-column pivot sometimes called?

Unpivoting

Over-under pivot

Ans – Unpivoting

Question: Which clean option does not exist in Tableau Prep Builder?

Make Uppercase

Make Lowercase

Make Sentence Case

Ans:- Make Sentence Case

Question: How many calculated fields are created after making one Automatic Split?

3

2

No calculated fields are made after an Automatic Split

1

It depends on the separators that are identified by Tableau Prep Builder

Ans:- It depends on the separators that are identified by Tableau Prep Builder

Question: What icon indicates that a Group and Replace operation has taken place?

A lightning bolt icon

A paperclip icon

Ans- A paperclip icon

Question: The following values are found in a field: gray, Gray, grey, grayy. What would the best single fuzzy match operation be to group them?

Pronunciation

Spelling
Ans – Pronunciation

Question: Which of these details does not appear when hovering your mouse over your custom data role in the Data Type menu?

Publication date

Description

Times used in other flows

Ans- Times used in other flows

Question: What is the search field in the Aggregate pane especially useful for?

Searching for help with Aggregate steps online

Quickly searching for and finding popular Aggregate operations

Finding specific fields if you have a large dataset

Ans – Finding specific fields if you have a large dataset

Question: Other than mousing over a value in a field, what is another way of seeing how many rows a value exists in?

The value bar is longer or shorter based on how many rows it appears in

Searching ‘find:multiplevalues’ in the profile pane search bar

Ans – The value bar is longer or shorter based on how many rows it appears in

Question: What happens when you start typing in the Calculated Field editor?

The fields in your data begin to update in real-time

Tableau Prep Builder suggests fields and functions to insert as you type

Ans- Tableau Prep Builder suggests fields and functions to insert as you type

Question: Which of these is not a regex function available in Tableau Prep Builder?

REGEXP_SEEK

REGEXP_MATCH

Ans- REGEXP_SEEK

Question: Which of the following programming language scripts can be added to a flow via the Script step in Tableau Prep Builder?

A+

F-Script

Python

R

Ans- Python

R

Question: How would you go about updating an existing Output file from Tableau Prep Builder?

By updating Tableau Prep Builder

By running the flow again

Ans – By running the flow again

Question: Which Output type is used by default in the latest versions of Tableau?

.csv

.hyper

Ans- .hyper

Question: What is not a required data value when publishing an Output to Tableau Server or Tableau Online?

Output name

Description

Ans – Description

Question: At which step can you view your data source details?

The Publish step

The Input step

Ans- The Input step

Question: How can Join step issues often be solved?

By restarting Tableau Prep Builder

By adjusting your Join settings

Ans- By adjusting your Join settings

Question: When can knowing what your Tableau Prep Builder version number be useful?

When troubleshooting issues online or with tech support

When you need to compare versions with Microsoft Excel

Ans – When troubleshooting issues online or with tech support

Question: When data from an Excel file is loaded into Tableau, how are blank cells from the source represented?

As a boolean false

As null values

Ans- As null values

Question: What is the default aggregation performed by Tableau for a numeric value conveyed on a chart?

SUM

MAX

Ans – SUM

Question: When working with a bar graph, Tableau includes an option to “Explain Data” for a particular bar. What type of information would be available in such a view for a categorical field?

Outliers in the category

The number of rows in all the other categories

Ans – Outliers in the category

Question: An axis for a numeric value can use a linear scale. Which of these is another scaling option for an axis in a Tableau chart?

Timely

Logarithmic

Ans – Logarithmic

Question: Which of these column types is a split option available for?

Boolean

String

Ans- String

Question: Which of these statements about filters for Tableau data is FALSE?

Filters may be applied to String fields

Filters can only be based on exact matches

Ans- Filters can only be based on exact matches

Question: Out of the options provided, select the operation which Tableau’s data interpreter can NOT do.

Detect cells which are column headers

Convert costs/sales to your local currency

Ans –
Convert costs/sales to your local currency

Question: Which of these file types can NOT be loaded into Tableau?

Access Database (accdb)

exe

Ans- exe

Question: Given you load an Excel file containing five sheets into Tableau, which of these statements is TRUE?

The data from each sheet will be visible as a separate table

Tableau will raise an error given the file contains more than one sheet

Ans – The data from each sheet will be visible as a separate table

Question: Which TWO of these are fields which are generated by Tableau based on geographical fields such as Country?

Official language

Country capital

Longitude

Latitude

Ans- Longitude

Latitude

Question: In the context of a Map visualization in Tableau, which of the following statements is FALSE.

Maps can be enhanced with additional layers

Aggregate calculations cannot be performed on the underlying data

Ans- Aggregate calculations cannot be performed on the underlying data

Question: Which of these is a feature which is available in Tableau Bar graphs but NOT in Maps?

The ability to view detailed information through tool tips

The ability to sort elements based on an underlying value

Ans- The ability to sort elements based on an underlying value

Question: When placing objects in a Dashboard, we can use a tiled approach where the object sizes are somewhat fixed. Which of these is the alternative layout option where objects can be resized and positioned.

Flex

Floating

Ans- Floating

Question: In the context of a URL action for a web page object, which TWO of the following statements are TRUE?

The URL loaded in the page may reference a field which only applies to some sheets in the dashboard

The URL for a web page object must be static

The URL may only reference a field which is sourced from all sheets in the dashboard

The URL may have multiple actions linked to it

Ans – The URL loaded in the page may reference a field which only applies to some sheets in the dashboard

The URL may have multiple actions linked to it

Question: Out of the following, pick the feature which is NOT available for Tableau dashboards.

Downloading as an MP4

Downloading as a PDF

Ans- Downloading as an MP4

Question: From the following, pick the two objects which can be directly added to a Story?

Download Buttons

Sheets

Web pages

Dashboards

Ans – Sheets

Dashboards

Question: When publishing a story to Tableau Public, which of these is NOT an option which is available to the general public?

The ability to view a visualization

The ability to delete a visualization

Ans – The ability to delete a visualization