What are three benefits of using an extract as compared to a live connection to a data source? (Choose three.)
What are three benefits of using an extract as compared to a live connection to a data source? (Choose three.)
Using an extract offers several benefits over a live connection to a data source. Calculated fields tend to perform better with extracts because Tableau can pre-process and optimize the data for quicker query performance. Extracts are stored in memory (RAM), leading to faster query performance as compared to live connections which rely on querying data over a network. Additionally, live connections can face performance issues due to network and user traffic, whereas extracts can mitigate these issues by operating locally.
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