Q5 — AWS DEA-C01 Ch.1

Question 5 of 100 | ← Chapter 1

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. ✓
• 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. Use the Amazon Redshift Data API.

Explanation

考虑到实时查询的需求以及最小化运营开销的目标，使用AmazonRedshiftDataAPI是最合适的解决方案。这个API允许用户通过HTTP请求直接对Redshift数据库执行SQL查询，而无需维护数据库连接，这样可以减少资源消耗和管理负担。相比之下，WebSocket连接、JDBC连接都需要更多的资源来管理和维护连接，而使用AmazonS3进行数据查询则不适合实时查询场景，因为S3是一个对象存储服务，不是为实时查询优化的。因此，选项B是最符合要求的解决方案。