MCQs on Data Preparation and Transformation | Data Handling in Tableau

1. Data Import and Data Connection

1. Which of the following is the first step to connect a data source in Tableau?
   a) Select the type of data visualization
   b) Connect to the data source
   c) Create calculated fields
   d) Import a workbook
2. Tableau can connect to which of the following types of data sources?
   a) Relational databases
   b) Cloud-based data sources
   c) Flat files
   d) All of the above
3. Which connection method in Tableau allows for real-time updates?
   a) Live Connection
   b) Extract Connection
   c) Offline Data Connection
   d) Manual Update
4. When using Tableau to connect to a SQL database, which component of the connection setup is required?
   a) Query Language
   b) Data Link Server
   c) Server Name and Credentials
   d) File Path
5. To connect Tableau to Google Analytics, you must use:
   a) Data Blending
   b) Data Extracts
   c) Web Data Connector
   d) Google Cloud API

2. Data Joins and Blending

6. Which type of join is NOT available in Tableau?
   a) Inner Join
   b) Left Join
   c) Outer Join
   d) Full Join
7. What does data blending in Tableau allow you to do?
   a) Combine data from different sources based on a common field
   b) Merge data into one dataset
   c) Filter data based on calculations
   d) Pivot data
8. If two data sources are blended in Tableau, which field is used to perform the blending?
   a) Primary field
   b) Common field
   c) Data source field
   d) Calculated field
9. When joining tables in Tableau, which of the following is required?
   a) Data source must be from the same database
   b) A common key field between the tables
   c) A pre-filtered dataset
   d) Multiple join conditions
10. What happens when you perform a left join in Tableau?
    a) All rows from the left table are kept
    b) Only matching rows from both tables are kept
    c) All rows from the right table are kept
    d) Only unmatched rows are kept

3. Data Cleaning (Handling Nulls, Duplicates, etc.)

11. How can you handle null values in Tableau?
    a) Remove them using a filter
    b) Replace them with a constant value
    c) Leave them as they are
    d) Both a and b
12. Which function can be used in Tableau to replace null values with a default value?
    a) ZN()
    b) IFNULL()
    c) ISNULL()
    d) COALESCE()
13. Tableau provides which method to remove duplicate data from a data set?
    a) Data Extract
    b) Data Blending
    c) Remove Duplicates feature in the Data Source tab
    d) Pivot function
14. When cleaning data, what does the “Data Interpreter” feature in Tableau do?
    a) Automatically remove null values
    b) Clean up and organize data from Excel and CSV files
    c) Merge data from multiple sources
    d) Remove duplicates from data
15. Which option can be used to handle duplicates in Tableau when joining data?
    a) Aggregating the data
    b) Filter out duplicate rows after importing
    c) Use a unique key for the join
    d) Merge duplicates manually

4. Data Filters and Extracts

16. Which of the following is a type of filter available in Tableau?
    a) Data Filter
    b) Context Filter
    c) Table Filter
    d) All of the above
17. A Context Filter in Tableau is used to:
    a) Filter data at the row level
    b) Act as an independent filter to set the context for other filters
    c) Automatically remove null values
    d) Sort data
18. What is the main advantage of using Data Extracts (TDE/Hyper) in Tableau?
    a) They reduce the size of the data set
    b) They allow for faster querying and processing
    c) They require more memory
    d) They allow real-time data connections
19. Which type of extract file format is used in Tableau for optimized storage and faster performance?
    a) TDE
    b) CSV
    c) XML
    d) JSON
20. When using a filter in Tableau, which of the following options can you apply to improve performance?
    a) Use context filters
    b) Apply a filter to a calculated field
    c) Remove all filters from the data source
    d) Convert filters to extracts

5. Creating Data Extracts (TDE, Hyper)

21. Which of the following is a feature of Tableau Hyper files (in comparison to TDE)?
    a) Hyper files provide faster load times and better scalability
    b) Hyper files are only supported in Tableau Server
    c) Hyper files cannot be used for large data sets
    d) TDE files offer better performance than Hyper files
22. What does creating a Tableau Extract (TDE/Hyper) allow you to do?
    a) Increase data size
    b) Store data locally for improved performance
    c) Connect to real-time data
    d) Apply a filter to data
23. What is the main advantage of creating a TDE extract from large datasets?
    a) It can aggregate data for better performance
    b) It reduces the need to perform calculations
    c) It improves access speed by compressing the data
    d) It eliminates the need for joins
24. When creating an extract in Tableau, which of the following options can be selected?
    a) Full Extract
    b) Incremental Extract
    c) Live Data Extract
    d) All of the above
25. What file extension is associated with Tableau’s extract files?
    a) .tde
    b) .hyper
    c) .csv
    d) .xlsx

6. Data Grouping and Hierarchies

26. What is a hierarchy in Tableau used for?
    a) Grouping data into categories
    b) Organizing dimensions in a parent-child relationship
    c) Merging similar data into one field
    d) Filtering data based on specific criteria
27. How can you create a new group in Tableau?
    a) Right-click a field and select “Create Group”
    b) Use the “Data Interpreter”
    c) Create a calculated field for grouping
    d) Import a group from a CSV file
28. What happens when you drag a dimension into the Rows shelf that has a hierarchy in Tableau?
    a) Tableau flattens the hierarchy
    b) Tableau automatically shows all levels of the hierarchy
    c) Tableau filters data based on hierarchy
    d) Tableau removes all null values from the hierarchy
29. Which of the following is the correct way to add multiple fields to a group in Tableau?
    a) Drag fields to the “Group” area in the Data Pane
    b) Select multiple values and group them manually
    c) Use the “Data Source” tab to combine fields
    d) Apply a filter and group the resulting values
30. When you create a hierarchy in Tableau, how can you use it in your visualization?
    a) Drag the hierarchy to the Rows or Columns shelf to drill down into the data
    b) Only use it in calculated fields
    c) Only use it to create groups
    d) Hierarchies cannot be used in visualizations

Answers (Table Format)