Home › GCP Data Engineer › cloudcomputing › gcpdeanalysisops › Which BigQuery feature should a Data Engineer us…
Which BigQuery feature should a Data Engineer use to PRECOMPUTE expensive joins / aggregations that are refreshed automatically when source data changes?
ACloud DNS
BCloud Memorystore
CStatic manual ETL exports each Monday
DBigQuery materialised views
Answer & Solution
Correct answer: D. BigQuery materialised views
Materialised views precompute + refresh (per PDE §4.1). The other options aren't precomputation.
Related questions
Which Cloud Composer feature should a Data Engineer use to define a recurring DAG that runWhich GCP BigQuery feature should a Data Engineer use to RECOVER a table to its state fromWhich Memorystore feature should a Data Engineer enable to keep a Redis cache available duWhich Cloud SQL feature should a Data Engineer enable to recover from a regional outage wiWhich GCP service should a Data Engineer use to QUERY logs from Dataflow / BigQuery / Pub/Which GCP service should a Data Engineer use to MONITOR pipeline + warehouse metrics (DataWhich BigQuery capacity model should a Data Engineer choose for predictable, steady-state Which GCP service should a Data Engineer use to PREPARE unstructured text for RAG (retriev