You are tasked with constructing a report-only data warehouse that utilizes BigQuery, where data is continuously streamed using the streaming API. Following Google's best practices for handling such data, you have established both staging and production tables. In keeping with these best practices, what approach would you take to design the data loading process to ensure a single master dataset exists while maintaining optimal performance for both data ingestion and report generation? | Google Professional Data Engineer Quiz