While configuring an extract in Tableau Desktop, you want to reduce the extract size by summarizing the data at the level that appears in your worksheets. Which setting in the Extract Data dialog should you enable to achieve this?
Use Data Interpreter
Enforce referential integrity
Aggregate for visible dimensions
Include hidden fields
The setting named "Aggregate for visible dimensions" tells Tableau to collapse the underlying rows down to the dimensions that are currently used in the view and then store only the aggregated results in the .hyper file. Because far fewer rows are written, the extract is smaller and refreshes more quickly. Options like "Include hidden fields", "Use Data Interpreter", or "Enforce referential integrity" do not perform row aggregation; they either add additional metadata to the extract or prepare the data in other ways, so they would not significantly shrink the file through summarization.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.