You are developing a globally scaled frontend for a legacy streaming backend data API. This API expects events in strict chronological order with no repeat data for proper processing. Which products…

The correct answer is B. Cloud Pub/Sub to Cloud DataFlow. CloudSQL is only for storage, to get the messages in order you need timestamp processed in dataflow to arrange them before putting it in any storage volume. The system described is not querying a db it is expecting a stream of messages only dataflow can correct the order. ACID…

Submitted by anna_se· Mar 30, 2026Designing and planning a cloud solution architecture

Question

You are developing a globally scaled frontend for a legacy streaming backend data API. This API expects events in strict chronological order with no repeat data for proper processing. Which products should you deploy to ensure guaranteed-once FIFO (first-in, first-out) delivery of data?

Options

ACloud Pub/Sub alone
BCloud Pub/Sub to Cloud DataFlow
CCloud Pub/Sub to Stackdriver
DCloud Pub/Sub to Cloud SQL

How the community answered

(50 responses)

A
26% (13)
B
58% (29)
C
10% (5)
D
6% (3)

Explanation

CloudSQL is only for storage, to get the messages in order you need timestamp processed in dataflow to arrange them before putting it in any storage volume. The system described is not querying a db it is expecting a stream of messages only dataflow can correct the order. ACID has no value here because the db is not being queried. You'll not find any documentation on pub/sub order being corrected with a db. See notes below on pub/sub and dataflow using timestamps and windows to ensure order. https://cloud.google.com/pubsub/docs/pubsub-dataflow

Topics

#Cloud Pub/Sub#Cloud Dataflow#FIFO ordering#exactly-once delivery

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice