AWS Certified Data Engineer – Associate (DEA-C01) — Question 3

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?

Answer options

• A. Establish WebSocket connections to Amazon Redshift.
• B. Use the Amazon Redshift Data API.
• 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.

Correct answer: B

Explanation

The Amazon Redshift Data API allows for simple and efficient querying of Redshift without the need to manage database connections, thus minimizing operational overhead. The other options involve more complex setups: WebSocket connections and JDBC require additional management for maintaining connections, while using S3 Select involves data duplication and might not provide real-time access to the data in Redshift.