
Ultimate access to all questions.
In a data integration project, you need to join two datasets that have a many-to-many relationship. Describe how you would implement this join, including the type of join you would use and how you would manage the resulting data volume and complexity.
A
Join by combining all rows from both datasets without considering the relationship type.
B
Implement a full outer join to capture all relationships, managing data volume and complexity through data partitioning and indexing.
C
Avoid joining if the relationship is many-to-many to prevent data explosion.
D
Join by randomly selecting rows from each dataset to simplify the process.