kubicle

What is represented by each icon in a Tableau Prep flow

A new dataset that is added to the flow***** An output file produced from the flow A step in the process of cleaning and transforming the dataset A link or relationship between steps in the cleaning process

What is represented by the lines between icons in a Tableau Prep flow

A step in the process of cleaning and transforming the dataset***** A link or relationship between steps in the cleaning process A new dataset that is added to the flow An output file produced from the flow

What happens when we select one of the changes in the Changes pane

All changes before the selected change are deleted***** All changes after the selected change are deleted***** We see the dataset as it appeared after the selected change The selected change is repeated for all the fields in the dataset

Which of these is not an error that can be fixed by Tableau Prep

An address field contains leading spaces***** A company lost all its data for the previous year The company's data contains several typos A dataset contains several blank fields

What visualization is used to represent numeric data in the card view

Bar chart***** Histogram Line chart Pie chart

What visualization is used to represent date-time data in the card view

Bar chart***** Pie chart***** Histogram Line chart

Which of these data types is displayed in the card view using a histogram

Categorical***** Numeric only Date-time only Numeric and date-time

Which of these Group and Replace methods takes the most time to complete

Common characters***** String similarity Manual selection Pronunciation

What is the main advantage of a ".hyper" data extract compared to a ".tde" extract

Hyper extracts are compatible with many applications other than Tableau***** Hyper extracts contain more data than TDE extracts Hyper extracts are faster than TDE extracts Hyper extracts are larger than TDE extracts

What is the main disadvantage of a ".hyper" data extract compared to a ".tde" extract

Hyper extracts are slower than TDE extracts***** Hyper extracts contain less data than TDE extracts***** Hyper extracts are larger than TDE extracts Only TDE extracts are compatible with applications other than Tableau

Which of these statements about a Tableau Flow File (TFL file) is false

It includes all the cleaning steps in the flow***** It includes all the data used as part of the flow It can be sent to other people or stored on your computer It can be used to repeat the steps in the flow for new data

Which of these statements about a Packaged Tableau Flow File (tflx file) is false

It includes all the data used as part of the flow***** It includes all the cleaning steps in the flow***** It can be sent to other people or stored on your computer It can be imported into a workbook in Tableau Desktop

Which of these is not an advantage of Tableau Prep compared to Alteryx

It is easier to learn***** It offers a wider variety of data science tools It is included with a Tableau Desktop license It can connect to a similarly wide range of data sources

Which of these describes the Changes pane

It lists all of the changes made recently***** It lists all of the changes made to the data in the current cleaning step It lists all of the changes made in the current flow It lists all of the changes made to the current input file

What is the main reason for splitting an address field into its components

It makes the dataset more efficient***** It allows us to import our flow into Tableau Desktop***** It makes each address a unique data point***** It allows us to summarize the dataset by the individual components

Which of these is an advantage of Tableau Prep compared to Alteryx

It offers a wider range of data science tools***** It is easier to learn It offers more customizable functionality than Alteryx It is a purpose-built data visualization tool

Which of these is not a cleaning action that can be performed on text data

Make lowercase***** Trim spaces***** Remove numbers***** Add punctuation

Which of these statements about grouping and replacing values in a field using manual selection is false

Manual selection is the slowest method of grouping and replacing values***** Manual selection is only an option when the field does not contain abbreviations Manual selection is an accurate method of grouping and replacing values Manual selection is not practical for larger datasets

Which of these data types is displayed in the card view using a bar chart

Numeric***** Date***** Text Time

Which of these is the most accurate Group and Replace method

Pronunciation***** Common punctuation Manual selection Common characters

Which of these is not a cleaning action that can be performed on text data

Remove letters***** Make uppercase***** Make lowercase Make title case

Which of these is not a cleaning action that can be performed on text data

Remove punctuation Remove typos Remove numbers***** Remove letters

An address field contains a street name, town, county, and postal code. Which of these fields could not be created directly from this address field using the custom split option

Street name and town***** County and postal code***** Town and county Street name

Which of these is not a file type that can be used for the output of a Tableau Prep flow

TDE file***** PDF file Hyper file CSV file

Which file type contains a Tableau Prep flow as well as all the data used in that flow

TFL file***** TFLX file TWB file TWBX file

Which file type contains a Tableau Prep flow but does not contain the data used in the flow

TWB file***** TWBX file***** TFL file TFLX file

Which of these is not an advantage of Tableau Prep compared to Excel

Tableau Prep can handle larger data sets***** Tableau Prep has a drag and drop interface***** Tableau Prep offers a wider variety of data science tools Tableau Prep is purpose built as a data manipulation tool

Which of these statements comparing Tableau Prep and Alteryx is false

Tableau Prep is more cost effective for existing Tableau Desktop users***** Alteryx contains more data science tools than Tableau Prep***** Tableau Prep is easier to learn than Alteryx Tableau Prep offers more customizable functionality than Alteryx

Which of these Tableau files can we connect to using Tableau Prep

Tableau workbook***** Tableau data source Tableau extract Tableau packaged workbook

How is the delimiter determined when we split an address field using the automatic split option

The function makes an initial guess, then asks us to confirm if this is correct***** We specify the delimiter to be used***** We choose the delimiter from a list of possible options The function determines the appropriate delimiter automatically

What is the main advantage of creating a sample using the quick select method

The sample contains a large number of rows***** The sample is created quickly The sample contains most of the columns in the dataset The sample contains data from all parts of the dataset

What is the main disadvantage of creating a sample using the quick select method

The sample only contains a small number of the columns in the dataset***** The sample may not contain data from all parts of the dataset It can take a long time to create the sample The sample will contain a small number of rows

Which of these is a disadvantage of using automated Group and Replace methods such as Common Characters and Pronunciation

They take longer than manual selection methods***** They cannot group text fields that contain punctuation***** They cannot group text fields that contain abbreviations The results need to be checked manually for errors

Which of these is ignored by the pronunciation method of grouping and replacing values

Typos***** Word order Abbreviations Numeric characters

When can deleting a step from the Changes pane break your Tableau Prep flow

When the step involves splitting fields***** When the step involves grouping and replacing fields***** When earlier steps depend on the deleted step When later steps depend on the deleted step

Which of these is not an option that we must select when splitting an address field using the custom split option

Whether the new fields are located at the start or end of the address***** The separator that indicates where the field should be split The number of new fields that should be created The number of characters in each of the new fields