You have a large dataset stored in Cloud Storage gcp video

Full Certification Question

You have a large dataset stored in Cloud Storage in JSON format. The data requires preprocessing, including deduplication, filtering records, and converting data into a structured format before being loaded into BigQuery for analytical queries. The dataset arrives in large batches, and you need to implement a cost-effective and scalable solution. What should you do?