Live vs extract connections in Tableau - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Live Connection Behavior

Which of the following statements best describes a live connection in Tableau?

A Data is queried directly from the source every time you interact with the visualization.

B Data is imported once and stored in Tableau's fast in-memory engine.

C Data is copied to a local file and refreshed only on demand.

D Data is aggregated and stored in a cloud database automatically.

💡 Hint

Think about how Tableau accesses data when you make changes in your dashboard.

A live connection means Tableau sends queries directly to the original data source each time you interact with the dashboard, ensuring up-to-date data but possibly slower performance.

🧠 Conceptual

intermediate

Extract Connection Characteristics

What is a key advantage of using an extract connection in Tableau?

A It requires a constant internet connection to the data source.

B It allows real-time data updates without manual refreshes.

C It automatically syncs data changes from the source instantly.

D It improves performance by storing a snapshot of data locally in a compressed format.

💡 Hint

Think about how extracts help speed up Tableau dashboards.

Extracts store a snapshot of the data locally in a compressed, optimized format, which improves performance but requires manual or scheduled refreshes to update.

🎯 Scenario

advanced

Choosing Between Live and Extract for a Large Dataset

You have a very large sales database that updates hourly. Your Tableau dashboard users want fast response times and reasonably fresh data. Which connection type should you choose?

A Use a live connection to always get the freshest data despite slower performance.

B Use an extract connection refreshed once a day to maximize performance.

C Use an extract connection refreshed every hour to balance speed and data freshness.

D Use a live connection with no caching to ensure data accuracy.

💡 Hint

Consider both data freshness and dashboard speed.

Refreshing extracts hourly provides a good balance between performance and data freshness for large datasets that update frequently.

🔧 Formula Fix

advanced

Troubleshooting Slow Dashboard Performance

Your Tableau dashboard connected live to a slow database is running very slowly. Which action will most likely improve performance?

A Switch to an extract connection and schedule regular refreshes.

B Use a live connection but disable caching.

C Disable data source filters to reduce query complexity.

D Increase the number of live queries sent simultaneously.

💡 Hint

Think about how extracts affect query speed.

Using extracts stores data locally in an optimized format, reducing query time and improving dashboard responsiveness compared to live connections to slow databases.

❓ visualization

expert

Visualizing Data Freshness Impact

You want to create a dashboard showing the impact of connection type on data freshness and performance. Which visualization best communicates this comparison?

A A pie chart showing percentage of live vs extract connections used.

B A scatter plot with connection type on X-axis, data freshness on Y-axis, and point size representing performance speed.

C A line chart showing data freshness over time for only extract connections.

D A bar chart comparing total data volume for live connections only.

💡 Hint

Think about how to show two variables and one measure together clearly.

A scatter plot can show connection type categories on one axis, data freshness on another, and use point size to represent performance speed, making the trade-offs clear.