Google Cloud Professional Data Engineer — Question 109

You are building an application to share financial market data with consumers, who will receive data feeds. Data is collected from the markets in real time.
Consumers will receive the data in the following ways:
✑ Real-time event stream
✑ ANSI SQL access to real-time stream and historical data
✑ Batch historical exports
Which solution should you use?

Answer options

• A. Cloud Dataflow, Cloud SQL, Cloud Spanner
• B. Cloud Pub/Sub, Cloud Storage, BigQuery
• C. Cloud Dataproc, Cloud Dataflow, BigQuery
• D. Cloud Pub/Sub, Cloud Dataproc, Cloud SQL

Correct answer: B

Explanation

The correct answer is B because Cloud Pub/Sub allows for real-time event streaming, while Cloud Storage and BigQuery can handle ANSI SQL queries on both real-time and historical data, as well as facilitate batch exports. The other options either do not support real-time event streaming or do not integrate all required functionalities effectively.