CompTIA Data+ DA0-002 (V2) Practice Question

The correct answer is Exploding. The 'exploding' transformation is used to convert a single row that contains a list-like structure (such as a comma-separated string or an array) into multiple rows, one for each element in the list. In this scenario, it would create a new row for each genre associated with a movie, allowing for accurate aggregation by genre.

• Parsing involves analyzing a string of text to break it into smaller, meaningful components. While parsing the 'genres' string is a necessary step to separate the genres, the overall technique that creates new rows from these components is known as exploding.
• Binning is a technique used to group a range of continuous numerical values into discrete intervals or 'bins'. It is not suitable for handling list-like categorical data.
• Imputation is the process of replacing missing values in a dataset with substituted values. This is not relevant to the task, as the problem is about restructuring existing data, not filling in missing data.