Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Last updated
An enterprise collects high-volume telemetry and application logs published to a Google Cloud Pub/Sub topic. The engineering team needs to ingest these messages in real time into BigQuery for immediate SQL analytics while minimizing operational overhead and avoiding the deployment or maintenance of intermediate data processing pipelines.
Which ingestion solution should the team implement?
Create a Pub/Sub BigQuery subscription configured to stream incoming messages directly into the destination BigQuery table.
Create a Pub/Sub Cloud Storage subscription to export files to Cloud Storage and schedule hourly BigQuery load jobs.
Deploy a continuous Apache Beam streaming pipeline on Dataflow to consume messages from Pub/Sub and write them to BigQuery.
Configure a standard Pub/Sub pull subscription and schedule a Cloud Composer DAG to poll messages and append them to BigQuery.
Create a Pub/Sub BigQuery subscription configured to stream incoming messages directly into the destination BigQuery table.
A Pub/Sub BigQuery subscription is a specialized, fully managed subscription type in Google Cloud Pub/Sub that automatically writes messages directly to an existing BigQuery table as they are received, completely eliminating the need to write subscriber code or deploy an intermediary pipeline.
When messages already conform to the destination BigQuery table schema (or when simple ingestion of raw payloads and metadata is sufficient), using a BigQuery subscription provides the simplest, lowest-latency, and most cost-effective architecture available in Google Cloud.
Create a Pub/Sub Cloud Storage subscription to export files to Cloud Storage and schedule hourly BigQuery load jobs.
Deploy a continuous Apache Beam streaming pipeline on Dataflow to consume messages from Pub/Sub and write them to BigQuery.
Configure a standard Pub/Sub pull subscription and schedule a Cloud Composer DAG to poll messages and append them to BigQuery.
StudyCerts
StudyCerts