A data analyst needs to combine two tables that have different levels of granularity. To avoid data duplication while preserving the native level of detail for both tables, which data combination method in Tableau is the most appropriate and flexible choice?
Relationships
Data Blending
Joins
Unions
The correct answer is Relationships. Relationships are designed to be a flexible, dynamic way to combine data from multiple tables. They preserve the original tables and their levels of detail, querying data at the appropriate level of aggregation for the visualization without creating a fixed, flattened table. This approach prevents data duplication that can occur with joins when tables have different granularities. Joins merge tables into a single new logical table before analysis, which can cause data duplication if the levels of detail differ. Unions are used to append rows of data from one table to another and require the tables to have the same structure. Data blending combines aggregated data from separate data sources and is generally less flexible than relationships for tables within the same data source.
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.