Home › GCP Data Engineer › cloudcomputing › gcpdeprocess › Which BigQuery feature lets a Data Engineer run …
Which BigQuery feature lets a Data Engineer run ANALYTICAL QUERIES across data still living in Cloud Storage parquet / ORC / Avro files — WITHOUT loading them into BigQuery storage?
ACloud Memorystore
BCloud DNS
CBigQuery external tables (and BigLake for governed multi-format access)
DBigQuery materialised views over native storage only
Answer & Solution
Correct answer: C. BigQuery external tables (and BigLake for governed multi-format access)
External tables + BigLake query data in-place on Cloud Storage (per PDE §3.3 + §2.2). The other options don't query external storage.
Related questions
Which Dataflow feature lets a Data Engineer reuse a published pipeline as a parameterised,Which Dataproc feature should a Data Engineer use to run a Spark job ONLY when work existsWhich Dataflow feature should a Data Engineer enable to BACKFILL or REPROCESS late-arrivinWhich GCP service lets a Data Engineer write streaming SQL queries directly against a Pub/Which Pub/Sub delivery model should a Data Engineer use when subscribers should pull messaWhich GCP service should a Data Engineer use for lightweight, serverless workflow orchestrWhich GCP service should a Data Engineer use to orchestrate Cloud Dataflow / BigQuery / DaWhich Apache Beam concept handles events arriving AFTER their window closes — letting the