LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Google Professional Data Engineer

Google Professional Data Engineer

Get started today

Ultimate access to all questions.


Your company is currently undertaking a project to migrate its on-premises data warehousing solutions to Google BigQuery. The existing data warehouse implements trigger-based change data capture (CDC) methods to update data from various transactional database sources on a daily schedule. The goal of migrating to BigQuery is to enhance the CDC process so that changes to the source systems can be reflected in BigQuery almost in real-time by using log-based CDC streams. Additionally, there is a need to optimize how changes are applied to the data warehouse to improve performance and reduce compute overhead. Which two steps should be taken to ensure that changes are propagated to the BigQuery reporting table with minimal latency while simultaneously reducing the amount of compute resources required? (Choose two.)

Exam-Like




Powered ByGPT-5