Answer-first summary for fast verification
Answer: Use DML MERGE periodically to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table., Insert each new CDC record and its corresponding operation type in real-time to a staging table.
Delta tables capture all change events since the initial load, offering insights into trends, entity states, and change frequencies. The MERGE statement efficiently combines multiple DML operations into one atomic action, enhancing consistency and performance. Staging tables facilitate real-time data insertion before processing. Reference: [Google Cloud Architecture](https://cloud.google.com/architecture/database-replication-to-bigquery-using-change-data-capture#overview_of_cdc_data_replication).
Author: LeetQuiz Editorial Team
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.
No comments yet.