Tableau Desktop Associate Data Connections and Preparation

Question 1

Which of the following data sources can Tableau connect to directly?

Accepted Answer

Excel, SQL databases, and cloud services like Google Sheets

Answer

Only Excel file

Answer

Only SQL databases

Answer

Tableau cannot connect to external data sources

Question 2

When would you use data blending instead of joins in Tableau?

Accepted Answer

When the data sources are from different servers

Answer

When both data sources have the same structure

Answer

When you want to speed up Tableau’s performance

Answer

When the data is from a single database

Question 3

What is the primary advantage of using a data extract instead of a live connection?

Accepted Answer

Data extracts allow offline analysis and improve performance

Answer

Data extracts update automatically in real time

Answer

Data extracts use more memory and resources than live connections

Answer

Data extracts have fewer features than live connections

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?

Accepted Answer

Left Join

Answer

Inner Join

Answer

Right Join

Answer

Full Outer Join

Question 5

When connecting to a large dataset in Tableau, which option can help optimize performance?

Accepted Answer

Use a data extract with a filtered subset of the data

Answer

Use a live connection with a refresh every second

Answer

Increase the sampling rate of the data source

Answer

Disable filters to reduce data load time