Google Professional Data Engineer Exam - Topic 2 Question 129 Discussion

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?

Francisca · Accepted Answer

C) Set up a MySQL database for each application server to write bid events into. Periodically query each of those distributed MySQL databases and update a master MySQL database with bid event information.

Francisca · Answer

A) Create 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 first.

Francisca · Answer

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 bid event information into Cloud SQL.

Francisca · Answer

D) Have each application server write the bid events to Google Cloud Pub/Sub as they occur. Use a pullsubscription to pull the bid events using Google Cloud Dataflow. Give the bid for each item to the user inthe bid event that is processed first.