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