DEA-C01 · Question #79
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…
The correct answer is B. Use the Amazon Redshift Data API. The Amazon Redshift Data API is purpose-built for web applications and serverless architectures. It allows you to run SQL queries without establishing or managing persistent database connections - you simply make an HTTPS call with your SQL statement. This eliminates the need…
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?
Options
- AEstablish WebSocket connections to Amazon Redshift.
- BUse the Amazon Redshift Data API.
- CSet up Java Database Connectivity (JDBC) connections to Amazon Redshift.
- DStore frequently accessed data in Amazon S3. Use Amazon S3 Select to run the queries.
How the community answered
(46 responses)- A2% (1)
- B83% (38)
- C4% (2)
- D11% (5)
Explanation
The Amazon Redshift Data API is purpose-built for web applications and serverless architectures. It allows you to run SQL queries without establishing or managing persistent database connections - you simply make an HTTPS call with your SQL statement. This eliminates the need to install drivers or manage connection pools. Option A (WebSocket) requires custom infrastructure to maintain persistent connections. Option C (JDBC) requires persistent connections and installing JDBC drivers, which is inappropriate for stateless web apps. Option D (S3 Select) doesn't query Redshift at all and defeats the purpose of having financial data in Redshift.
Topics
Community Discussion
No community discussion yet for this question.