Exam simulator Last updated: Jun 6, 2026

Professional Data Engineer Practice Test - Professional Data Engineer

Question 1 / 173 1% Progress tracking

Full question bank 173 practice questions available

Last updated Jun 6, 2026 Professional Data Engineer Exam simulator

Access level Guest preview Premium: Full

Question 1 / 173 1%

Select all that apply 5 options

Your company is in the process of migrating its on-premises data warehousing solutions to BigQuery. The existing data warehouse uses trigger-based change data capture (CDC) to apply updates from multiple transactional database sources on a daily basis.

With BigQuery, your company hopes to improve its handling of CDC so that changes to the source systems are available to query in BigQuery in near-real time using log-based CDC streams, while also optimizing for the performance of applying changes to the data warehouse. Which two steps should they take to ensure that changes are available in the BigQuery reporting table with minimal latency while reducing compute overhead? (Choose two.)

A Perform a DML INSERT, UPDATE, or DELETE to replicate each individual CDC record in real time directly on the reporting table. B Insert each new CDC record and corresponding operation type to a staging table in real time. C Periodically DELETE outdated records from the reporting table. D Periodically use a DML MERGE to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table. E Insert each new CDC record and corresponding operation type in real time to the reporting table, and use a materialized view to expose only the newest version of each unique record.

Multiple answers may be correct.

Professional Data Engineer What you practise

Professional Data Engineer Practice Test for Professional Data Engineer

Use this Professional Data Engineer practice test to check your readiness with original study questions, exam-style answer choices and a structured simulator experience.

What you practise

Core objectives, scenario questions, answer review and practical certification preparation.

How the simulator helps

The simulator starts with a free sample, records your answers, and shows a clean review path so you can understand weak areas instead of memorising isolated facts.

Professional Data Engineer exam information

Provider: Google Practice Tests

Professional Data Engineer supporting study resources

These pages cover separate study intents and link back to the main Professional Data Engineer Practice Test.

Professional Data Engineer Study Guide A practical study route for Professional Data Engineer, built around official-scope review and QZ9 simulator practice. Professional Data Engineer Exam Objectives Use the Professional Data Engineer objective map to turn missed questions into focused review. Professional Data Engineer Exam Format How to use format and scoring notes while preparing for Professional Data Engineer.

Professional Data Engineer Practice Test for Professional Data Engineer

Professional Data Engineer exam information

Professional Data Engineer supporting study resources

Related Google practice tests