Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
An e-commerce company is designing an event-driven inventory management pipeline on Google Cloud. The system ingests high-volume inventory mutation events from physical stores and online checkouts through Pub/Sub and processes them using Cloud Dataflow before updating product inventory levels in BigQuery and downstream datastores.
The system must meet the following reliability and data integrity requirements:
Which architectural pattern should the data engineering team implement?
This option shifts from a real-time stream processing architecture to an asynchronous micro-batch architecture where Cloud Functions push events to Cloud Storage Archive storage, which is then batch-processed hourly by Apache Spark on Dataproc.
The business requirement was purely historical regulatory archival and bulk compliance reporting where real-time inventory synchronization is unnecessary.
This option attempts to enforce transactional consistency by treating event messages as imperative state overwrite commands (e.g., 3001) and relying strictly on ordered delivery and single-worker execution.
The system required legacy message-queue style imperative command routing with guaranteed low-throughput FIFO execution on a strictly non-distributed backend.
This architecture combines event-driven state-delta payloads, Dataflow deduplication, Pub/Sub dead-letter topics, and subscription snapshots/seek to achieve end-to-end transactional integrity, commutativity, and fault tolerance across a streaming ingestion pipeline.
{"inventory": -1}) rather than absolute state overwrite commands ensures that commutative state modifications remain mathematically consistent regardless of message arrival sequence. Applying Dataflow deduplication filters out duplicate deliveries inherent to Pub/Sub's at-least-once model using distinct message identifiers or record keys.This pattern balances high-throughput asynchronous scaling with strict data fidelity and ACID-like state consistency. It eliminates single-point-of-failure sequential bottlenecks while guaranteeing durable, idempotent data handling.
This architecture bypasses managed stream processing engines (such as Dataflow) by having custom VM workers pull messages from Pub/Sub and attempt manual state deduplication downstream in BigQuery via snapshots.
ackDeadline) to 0 seconds causes Pub/Sub to immediately consider messages unacknowledged or negatively acknowledged (nack), triggering continuous redelivery storms.The goal was to test immediate negative acknowledgment (nack) mechanisms in a staging environment rather than establishing an ACID-compliant production streaming pipeline.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated