MCQs on Tableau Prep | Data Preparation with Tableau Prep
1. Introduction to Tableau Prep
- What is the primary purpose of Tableau Prep?
a) To visualize data in Tableau
b) To create dashboards
c) To prepare and clean data for analysis
d) To manage Tableau Server - Which of the following is a feature of Tableau Prep?
a) Data preparation and visualization
b) Real-time data analytics
c) Generating predictive models
d) Automating Tableau Server updates - How does Tableau Prep differ from Tableau Desktop?
a) Tableau Prep is used only for visualizations, while Tableau Desktop is for data preparation
b) Tableau Prep is used for preparing and cleaning data, while Tableau Desktop is used for analyzing and visualizing data
c) Tableau Prep has more advanced data analytics features than Tableau Desktop
d) Tableau Prep cannot handle data from multiple sources, whereas Tableau Desktop can - Which of the following data sources can Tableau Prep connect to?
a) Google Sheets
b) Microsoft SQL Server
c) CSV Files
d) All of the above - What is the key function of Tableau Prep in the data preparation process?
a) Visualizing the data
b) Cleaning and reshaping the data
c) Performing complex statistical analysis
d) Creating machine learning models
2. Data Flow and Preparation
- What does a flow in Tableau Prep represent?
a) A single data source
b) The steps to clean, combine, and shape data
c) A Tableau worksheet
d) A Tableau Server dashboard - Which of the following is a key element of a Tableau Prep flow?
a) Data extracts
b) Input and output steps
c) Dashboards
d) Visualizations - How does Tableau Prep allow users to visualize the data preparation process?
a) By displaying data in charts and graphs
b) By showing a visual flow of operations performed on the data
c) By creating automatic Tableau dashboards
d) By generating SQL queries - In Tableau Prep, which of the following options is used to perform data transformations?
a) Filters
b) Calculations
c) Steps
d) Dashboards - What does Tableau Prep do when you run a flow?
a) It generates a new Tableau workbook
b) It prepares and reshapes data according to the defined steps
c) It directly publishes the data to Tableau Server
d) It automatically analyzes the data
3. Cleaning and Reshaping Data
- What is the function of the “Clean” step in Tableau Prep?
a) To merge multiple data sources
b) To perform data aggregations
c) To remove unwanted values, nulls, or duplicates
d) To generate new data fields - Which of the following operations can be performed in Tableau Prep to clean the data?
a) Changing data types
b) Removing null values
c) Renaming columns
d) All of the above - How can you handle null values in Tableau Prep?
a) By deleting the entire column
b) By replacing them with a specified value
c) By leaving them unchanged
d) By aggregating the data - In Tableau Prep, how can you change the data type of a column?
a) By editing the underlying data source
b) By using the “Clean” step and selecting the desired data type
c) By renaming the column
d) By applying a filter - What does the “Pivot” operation in Tableau Prep allow you to do?
a) Combine two or more data sources
b) Rotate data columns into rows or vice versa
c) Remove duplicates from the data
d) Create new calculated fields
4. Joining and Aggregating Data
- Which of the following methods can be used to combine data from two different sources in Tableau Prep?
a) Data blending
b) Data join
c) Data aggregation
d) Data conversion - What is the purpose of performing a “Join” in Tableau Prep?
a) To filter out irrelevant data
b) To combine data from multiple sources based on a common field
c) To clean null values
d) To apply transformations to a column - What types of joins can you perform in Tableau Prep?
a) Inner join
b) Left join
c) Right join
d) All of the above - How does Tableau Prep handle aggregate functions?
a) It allows aggregation to be performed only after joining data
b) It provides an aggregation step where you can summarize data
c) It automatically aggregates data before visualizing it
d) Aggregation cannot be performed in Tableau Prep - What is the result of performing an “Aggregation” in Tableau Prep?
a) The data is split into multiple tables
b) The data is reduced to summary statistics based on specified fields
c) The data is completely cleaned
d) The data is joined with external sources
5. Automating Data Prep Workflows
- How can Tableau Prep help automate data preparation tasks?
a) By generating Tableau dashboards automatically
b) By allowing users to schedule and run flows at specific intervals
c) By performing machine learning on the data
d) By automatically cleaning data - What is the role of “Scheduled Flows” in Tableau Prep?
a) To automate the data refresh process
b) To visualize data in real-time
c) To generate reports automatically
d) To schedule backups of data - Which feature in Tableau Prep allows you to schedule the execution of data flows?
a) Tableau Prep Conductor
b) Tableau Desktop
c) Tableau Server
d) Tableau Prep Scheduler - How can users automate repetitive data cleaning steps in Tableau Prep?
a) By creating calculated fields
b) By reusing existing flows with minimal changes
c) By creating manual filters for each data field
d) By using the automatic aggregation feature - Can Tableau Prep automatically handle data refreshes when the data changes in the source?
a) Yes, using scheduled flows
b) No, users must manually refresh the data
c) Yes, with real-time connections
d) No, Tableau Prep does not support data refreshes
6. Using Tableau Prep Conductor
- What is Tableau Prep Conductor used for?
a) Automating Tableau Dashboard creation
b) Scheduling and managing Tableau Prep flows on Tableau Server
c) Performing data visualization
d) Creating Tableau workbooks - Which feature does Tableau Prep Conductor enable?
a) Real-time data updates
b) Flow scheduling and monitoring
c) Data cleansing only
d) Data analysis - What is the minimum requirement to use Tableau Prep Conductor?
a) Tableau Server
b) Tableau Desktop
c) Tableau Online
d) Tableau Prep Builder - How does Tableau Prep Conductor help in managing data prep workflows?
a) By providing a platform for users to create dashboards
b) By allowing automatic execution of data prep flows at set intervals
c) By visualizing the data and generating reports
d) By automatically creating new data sources - What kind of alerts can Tableau Prep Conductor provide?
a) Alerts on new data being added
b) Alerts on flow execution status (success or failure)
c) Alerts on data visualizations being published
d) Alerts on Tableau Server updates
Answer Key (Tabular Form)
| Qno | Answer (Option with Text) |
|---|---|
| 1 | c) To prepare and clean data for analysis |
| 2 | d) Automating Tableau Server updates |
| 3 | b) Tableau Prep is used for preparing and cleaning data, while Tableau Desktop is used for analyzing and visualizing data |
| 4 | d) All of the above |
| 5 | b) Cleaning and reshaping the data |
| 6 | b) The steps to clean, combine, and shape data |
| 7 | b) By showing a visual flow of operations performed on the data |
| 8 | b) By showing a visual flow of operations performed on the data |
| 9 | c) Steps |
| 10 | b) It prepares and reshapes data according to the defined steps |
| 11 | c) To remove unwanted values, nulls, or duplicates |
| 12 | d) All of the above |
| 13 | b) By replacing them with a specified value |
| 14 | b) By using the “Clean” step and selecting the desired data type |
| 15 | b) Rotate data columns into rows or vice versa |
| 16 | b) Data join |
| 17 | b) To combine data from multiple sources based on a common field |
| 18 | d) All of the above |
| 19 | b) It provides an aggregation step where you can summarize data |
| 20 | b) The data is reduced to summary statistics based on specified fields |
| 21 | b) By allowing users to schedule and run flows at specific intervals |
| 22 | a) To automate the data refresh process |
| 23 | a) Tableau Prep Conductor |
| 24 | b) By reusing existing flows with minimal changes |
| 25 | a) Yes, using scheduled flows |
| 26 | b) Scheduling and managing Tableau Prep flows on Tableau Server |
| 27 | b) Flow scheduling and monitoring |
| 28 | a) Tableau Server |
| 29 | b) By allowing automatic execution of data prep flows at set intervals |
| 30 | b) Alerts on flow execution status (success or failure) |