Tableau Desktop Certified Professional — Question 21

What are three benefits of using an extract as compared to a live connection to a data source? (Choose three.)

Answer options

• A. A live connection to a data source provides the best performance for data connections.
• B. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
• C. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
• D. An extract reduces the amount of data stored on a client computer as compared to a live data connection.
• E. A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.

Correct answer: B, C, E

Explanation

Option B is correct because calculated fields indeed perform better in extracts due to optimized data handling. Option C is also correct, as extracts in RAM allow for faster query responses than live connections. Option E is valid since live connections can suffer from latency issues, while extracts are designed to mitigate such performance hindrances. Options A and D are incorrect; A states that live connections provide the best performance, which is false in this context, and D incorrectly claims that extracts reduce data on the client side in a way that is not a primary benefit.