Google Cloud Professional Data Engineer practice questions
10 questions in 1 test. Open one to answer it on its own, or take a whole test.
Test 1
Take Test 1 ›- A logistics company streams telemetry from 200,000 delivery vehicles. The platform must sustain roughly 1.5 million writes per second, retain 18 months of readings, and serve the… · Storage System Selection
- A Dataflow streaming pipeline reads ride events from Pub/Sub and writes per-minute ride counts to BigQuery using one-minute tumbling windows over the event timestamp. Drivers… · Streaming Pipelines
- An events table has grown to 40 TB in a single unpartitioned BigQuery table with an event_ts TIMESTAMP column and a high-cardinality customer_id column. The project uses… · BigQuery Cost Optimization
- A retailer lifted its on-premises third-normal-form warehouse into BigQuery unchanged. Nearly every analytical query joins the 20-billion-row orders table to the 90-billion-row… · Data Warehouse Modeling
- A team is migrating a set of Apache Spark batch jobs off an on-premises Hadoop cluster. The jobs run for about four hours each night and read and write data currently held in… · Dataproc & Resource Optimization
- Analysts need an on-premises Oracle order-management database mirrored into BigQuery with data no more than 15 minutes stale, including row deletes. The database administrators… · Data Migration & CDC
- A nightly workflow must wait for a partner's files to land in Cloud Storage, run a Dataproc job to standardize them, then run two BigQuery queries that depend on that job, and… · Workload Automation
- A data provider must make a curated BigQuery dataset available to 40 partner organizations, each in its own Google Cloud organization. Partners must query the data from their own… · Sharing Data
- A customers table holds email and phone columns. Analysts must no longer see the raw values, but their existing scheduled queries use SELECT * and count distinct users by… · Security & Compliance
- A 24/7 Dataflow streaming pipeline reads from Pub/Sub, aggregates into 30-minute session windows, and writes to BigQuery. A bug fix must be deployed to one of the transforms… · Pipeline Operations