A data engineer wants to run real-time queries on Amazon Redshift data from a web-based trading application with minimal operational effort. Which option meets this requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Use the Amazon Redshift Data API..
Why this is the answer
The Amazon Redshift Data API allows applications to execute SQL commands against Redshift clusters without requiring JDBC/ODBC drivers or managing database connections. This simplifies integration for web applications, offering a secure, scalable, and serverless way to interact with Redshift, thus minimizing operational effort. Establishing WebSocket connections directly to Redshift is not a standard or supported method for querying the database. While WebSockets facilitate real-time communication, they are not designed for direct database interaction. Setting up JDBC connections requires managing drivers, connection pools, and credentials within the application, increasing operational overhead compared to the Data API. Storing data in Amazon S3 and using S3 Select is suitable for querying data directly in S3, but it bypasses the Redshift cluster entirely and doesn't address the requirement of querying Redshift data.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed