Google Professional Data Engineer

Google Professional Data Engineer

Get started today

Ultimate access to all questions.


In a report-only data warehouse setup, data is streamed into BigQuery via the streaming API, with separate staging and production tables to follow Google's best practices. What is the optimal data loading strategy to maintain a single master dataset without compromising ingestion or reporting performance?