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 steps are recommended to optimize CDC performance and reduce compute overhead, ensuring near-real-time availability of source system changes in the BigQuery reporting table? (Choose two.)
A
Insert each new CDC record and its corresponding operation type in real-time to a staging table
B
Use DML MERGE periodically to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table.
C
Replicate each individual CDC record in real-time using DML INSERT, UPDATE, or DELETE operations directly on the reporting table
D
Periodically delete outdated records from 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