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