Semi-Structured Data Quiz

What you'll be asked

1. Which of the following file formats is considered a standard example of semi-structured data?
2. When loading semi-structured data into a data warehouse, what is the primary purpose of 'flattening' the data?
3. If a JSON record contains an array of items, which operation is typically required to analyze each item individually?
4. When transforming semi-structured data, why is schema evolution a significant consideration?
5. You are processing a large stream of JSON logs where some records contain a 'user_id' field as an integer and others contain it as a string. How should you approach the transformation to ensure consistency?

Answers and explanations come after you submit.