Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Your company is moving from on-premises data warehousing to BigQuery, aiming to enhance Change Data Capture (CDC) processes for real-time updates. The goal is to minimize latency in reflecting these changes in BigQuery reporting tables while reducing compute overhead. Which two strategies should you implement? (Select two.)
A
Periodically DELETE outdated records from the reporting table.
B
Insert each new CDC record and corresponding operation type to a staging table in real time.
C
Perform a DML INSERT, UPDATE, or DELETE to replicate each individual CDC record in real time directly on 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.