Your company is transitioning its on-premises data gcp video
data-engineer-pro video for your company is transitioning its on-premises data warehousing solutions to BigQuery. The current data warehouse employs
Full Certification Question
Your company is transitioning its on-premises data warehousing solutions to BigQuery. The current data warehouse employs trigger-based change data capture (CDC) to apply updates from various transactional database sources daily. In moving to BigQuery, the aim is to enhance CDC efficiency, making changes from source systems promptly accessible for querying in BigQuery nearly in real-time via log-based CDC streams. Simultaneously, optimization for data warehouse performance is sought. Which two measures should be implemented to ensure minimal latency in making changes available in the BigQuery reporting table while reducing compute overhead?