Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
When migrating on-premises data warehousing solutions to BigQuery, which two strategies are recommended to optimize Change Data Capture (CDC) performance and reduce compute overhead, ensuring near-real-time updates in the BigQuery reporting table? (Choose two.)
A
Periodically delete outdated records from the reporting table.
B
Insert each new CDC record and its corresponding operation type in real-time to a staging table.
C
Replicate each individual CDC record in real-time using DML INSERT, UPDATE, or DELETE operations directly on the reporting table.
D
Use DML MERGE periodically to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table.
E
Insert each new CDC record and its corresponding operation type in real-time to the reporting table, and use a materialized view to expose only the latest version of each unique record.