Google
PROFESSIONAL-DATA-ENGINEER · Question #137
Your globally distributed auction application allows users to bid on items. Occasionally, users place identical bids at nearly identical times, and different application servers process those bids…
The correct answer is B. Have each application server write the bid events to Cloud Pub/Sub as they occur. Push the events from Cloud Pub/Sub to a custom endpoint that writes the. Explanation/Reference: From Cloud SQL we can fetch the record on timestamp basis using where clause and it satisfies near real time.
Submitted by rania.sa· Mar 30, 2026Designing data processing systems
Question
Your globally distributed auction application allows users to bid on items. Occasionally, users place identical bids at nearly identical times, and different application servers process those bids. Each bid event contains the item, amount, user, and timestamp. You want to collate those bid events into a single location in real time to determine which user bid first. What should you do?
Options
- ACreate a file on a shared file and have the application servers write all bid events to that file. Process the file with Apache Hadoop to identify which user bid
- BHave each application server write the bid events to Cloud Pub/Sub as they occur. Push the events from Cloud Pub/Sub to a custom endpoint that writes the
- CSet up a MySQL database for each application server to write bid events into. Periodically query each of those distributed MySQL databases and update a
- DHave each application server write the bid events to Google Cloud Pub/Sub as they occur. Use a pull subscription to pull the bid events using Google Cloud
How the community answered
(52 responses)- A13% (7)
- B56% (29)
- C23% (12)
- D8% (4)
Explanation
Explanation/Reference: From Cloud SQL we can fetch the record on timestamp basis using where clause and it satisfies near real time.
Topics
#Cloud Pub/Sub#real-time processing#event streaming#distributed systems
Community Discussion
No community discussion yet for this question.