Exam TDS-C01 topic 1 question 9 discussion

Extracts give better performance than live connections but create .hyper file in client computer

B C and E

B. Calculated fields can perform better in workbooks connected to extracts because extracts allow Tableau to pre-process and optimize the data, including calculated fields, resulting in faster query performance. C. Extracts are stored in memory (RAM), which can result in faster query performance compared to live data connections that query data from a remote data source over a network. D. Extracts reduce the amount of data stored on a client computer because they store a snapshot of the data, whereas live data connections query data from the data source each time the workbook is opened or refreshed, potentially requiring more data to be transferred over the network.

BCE: Live = Needs highspeed itnernet and continuos package movment Extract = Better for large datasets (specially when calculating fields)

B,C and E

Same for Power BI

https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm BCE Extracts are advantageous for several reasons: 1. Supports large data sets: You can create extracts that contain billions of rows of data. 2. Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data. 3. Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct. 4.Provide offline access to your data: If you are using Tableau Desktop, extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling

B C and D

sources to verify the answer https://www.tableau.com/blog/understanding-tableau-data-extracts-part1 https://www.thedataschool.co.uk/ellen-blackburn/connecting-to-data-extract-or-live