Question
A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.
Which solution will meet these requirements with the LEAST operational overhead?
- A. Establish WebSocket connections to Amazon Redshift.
- B. Use the Amazon Redshift Data API. Correct
- C. Set up Java Database Connectivity (JDBC) connections to Amazon Redshift.
- D. Store frequently accessed data in Amazon S3. Use Amazon S3 Select to run the queries.
Explanation
The correct answer is B because using the Amazon Redshift Data API allows for running SQL queries on an Amazon Redshift cluster with minimal operational overhead, as it abstracts away the need for direct database connections like JDBC or WebSocket. This approach simplifies integration with web-based applications by providing a serverless way to execute queries and manage sessions.
