You’re working with a new dataset stored in Cloud Storage (GCS) that contains customer transaction records. To prepare for analysis in BigQuery, you need to ensure the data is structured and efficiently partitioned. Which approach will optimize the performance of your queries in BigQuery and support scalability as the dataset grows over time?