Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are developing an application intended to disseminate financial market data to consumers who will access data feeds. The data is gathered from financial markets in real time. Consumers are expected to receive the data through three main channels: real-time event streams, ANSI SQL access to both real-time streams and historical data, and batch historical exports. What is the most suitable solution you should implement?
Explanation:
The best solution for sharing financial market data with consumers is using Cloud Pub/Sub, Cloud Storage, and BigQuery. Here is how this solution aligns with the requirements: 1) For the real-time event stream, Cloud Pub/Sub is a managed messaging service that handles real-time data efficiently. 2) For ANSI SQL access to the real-time stream and historical data, BigQuery supports ANSI SQL queries and can stream data directly from Pub/Sub into BigQuery tables. 3) For batch historical exports, Cloud Storage can be used to export data from BigQuery, making the data available for download. This combination provides a scalable, efficient, and user-friendly solution.