Extract optimization in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Tableau Extract Optimization Techniques

Which of the following methods is the most effective way to reduce the size of a Tableau extract without losing important data?

A Filter the data during extract creation to include only relevant rows

B Include all columns and rows to keep the extract comprehensive

C Use live connection instead of extract to avoid extract size issues

D Add calculated fields to the extract to increase data detail

💡 Hint

Think about how limiting data upfront affects extract size.

Filtering data during extract creation reduces the amount of data stored, which directly decreases extract size and improves performance.

❓ dax_lod_result

intermediate

Effect of Aggregation on Extract Size

Consider a Tableau extract created with aggregated data at the monthly level instead of daily. What is the expected impact on extract size?

A Extract size will decrease because fewer rows are stored

B Extract size will increase due to additional calculated fields

C Extract size will remain the same because aggregation does not affect storage

D Extract size will increase because aggregation adds complexity

💡 Hint

Think about how aggregation changes the number of rows stored.

Aggregating data reduces the number of rows by summarizing detailed data, which decreases the extract size.

🔧 Formula Fix

advanced

Diagnosing Slow Extract Refresh Performance

A Tableau extract refresh is taking much longer than expected. Which of the following is the most likely cause?

A The extract is stored on a fast SSD drive

B The extract includes unnecessary columns and rows increasing processing time

C The extract uses incremental refresh instead of full refresh

D The extract uses data source filters to limit data

💡 Hint

Consider what increases the amount of data Tableau must process during refresh.

Including unnecessary columns and rows increases the data volume, which slows down extract refresh performance.

❓ visualization

advanced

Visualizing Extract Size Impact

You want to create a dashboard showing the impact of different extract optimization techniques on extract size. Which visualization type best communicates this comparison?

A A scatter plot showing extract size versus refresh time without grouping

B A pie chart showing the percentage of total data by extract technique

C A line chart showing extract size over time without technique comparison

D A stacked bar chart comparing extract sizes before and after applying filters and aggregations

💡 Hint

Think about how to compare multiple categories clearly.

A stacked bar chart clearly shows size differences before and after applying optimization techniques, making comparisons easy.

🎯 Scenario

expert

Optimizing Extracts for Large Datasets with Multiple Sources

You manage a Tableau dashboard that uses extracts from multiple large data sources. The extracts are slow to refresh and the dashboard performance is poor. Which combined approach will best optimize extract performance?

A Remove all filters and aggregations to keep extracts raw and refresh extracts during peak hours

B Use live connections for all data sources to avoid extract refresh delays

C Apply data source filters to limit rows, aggregate data at the source, and schedule incremental refreshes during off-peak hours

D Increase extract refresh frequency to every 5 minutes without changing extract design

💡 Hint

Consider how to reduce data volume and refresh load while maintaining data freshness.

Applying filters and aggregation reduces data volume, and incremental refresh during off-peak hours balances performance and data freshness.