Tableau Desktop Associate Data Connections and Preparation — Questions and Answers
Question 1: Which of the following data sources can Tableau connect to directly?
- Only Excel file
- Only SQL databases
- Excel, SQL databases, and cloud services like Google Sheets (Correct answer)
- Tableau cannot connect to external data sources
Correct answer: Excel, SQL databases, and cloud services like Google Sheets
Tableau is designed to be a highly versatile data visualization tool, capable of connecting to a wide array of data sources. This includes common file types like Excel, robust database systems such as SQL databases, and modern cloud-based platforms like Google Sheets. This broad connectivity provides users with the flexibility to work with their data regardless of where it resides.
Question 2: When would you use data blending instead of joins in Tableau?
- When the data sources are from different servers (Correct answer)
- When both data sources have the same structure
- When you want to speed up Tableau’s performance
- When the data is from a single database
Correct answer: When the data sources are from different servers
Data blending is primarily used when you need to combine data from different, independent data sources that cannot be joined directly at the database level. This often occurs when data resides on separate servers or comes from different types of databases. Joins, in contrast, are typically performed within a single data source or across sources that can be linked directly.
Question 3: What is the primary advantage of using a data extract instead of a live connection?
- Data extracts update automatically in real time
- Data extracts allow offline analysis and improve performance (Correct answer)
- Data extracts use more memory and resources than live connections
- Data extracts have fewer features than live connections
Correct answer: Data extracts allow offline analysis and improve performance
A data extract creates a static snapshot of the data, which is stored locally and optimized for performance within Tableau. This allows for significantly faster query execution and the ability to work offline without a constant connection to the original data source. Unlike a live connection, extracts improve performance by pre-processing and storing the data efficiently.
Question 4: You have two datasets that need to be joined: a list of customer orders and a list of customer information. Which join type should you use if you want all orders to be included, even those without matching customer information?
- Inner Join
- Left Join (Correct answer)
- Right Join
- Full Outer Join
Correct answer: Left Join
A Left Join includes all rows from the 'left' table (customer orders in this scenario) and only the matching rows from the 'right' table (customer information). If an order doesn't have corresponding customer information, it will still be included in the result, with null values for the customer information fields. This fulfills the requirement to include all orders.
Question 5: When connecting to a large dataset in Tableau, which option can help optimize performance?
- Use a live connection with a refresh every second
- Use a data extract with a filtered subset of the data (Correct answer)
- Increase the sampling rate of the data source
- Disable filters to reduce data load time
Correct answer: Use a data extract with a filtered subset of the data
Connecting to a large dataset can significantly impact Tableau's performance. Using a data extract pre-processes and optimizes the data for Tableau, and filtering it to include only the necessary subset drastically reduces the volume of data being processed. This combination leads to much faster loading times and improved interactivity compared to a live connection to the full dataset.
Tableau Desktop Associate Data Connections and Preparation
Which of the following data sources can Tableau connect to directly?