Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 7 discussion

You can query a Redshift cluster with either JDBC/ODBC or Data API. The latter just requires you to maintain AWS SDK and IAM role, while the former needs network plumbing to access VPC, JDBC/ODBC driver, database credentials possibly stored in Secret Manager

B is correct

Most efficient solution

Amazon Redshift Data API: Provides a serverless and simple HTTP-based API to interact with Redshift. Ideal for web-based applications since it eliminates the need to manage persistent database connections (like JDBC or ODBC). Allows the trading application to send queries directly to Redshift using HTTPS requests, making it easy to integrate with modern applications. Removes the complexity of managing database connection pooling in real-time, which reduces operational overhead. Securely integrates with IAM roles and policies for authentication and access control.

A) Redshift doesn't support WebSockets; C) It is way harder to manage DB connections than using Redshift Data API which will offer you the possibility to run SQL queries directly. D)

B is correct

Inside application with minimal effort then using API would be correct

"The Amazon Redshift Data API enables you to painlessly access data from Amazon Redshift with all types of traditional, cloud-native, and containerized, serverless web service-based applications and event-driven applications." https://aws.amazon.com/de/blogs/big-data/using-the-amazon-redshift-data-api-to-interact-with-amazon-redshift-clusters/#:~:text=The%20Amazon%20Redshift%20Data%20API%20is%20not%20a%20replacement%20for,supported%20by%20the%20AWS%20SDK.

Even if you don't know nothing about them, you will still choose B because it seems the "LEAST operational overhead" :)

B. DATA API

B. Use the Amazon Redshift Data API. Explanation: The Amazon Redshift Data API is a lightweight, HTTPS-based API that provides an alternative to using JDBC or ODBC drivers for running queries against Amazon Redshift. It allows you to execute SQL queries directly from within your application without the need for managing connections or drivers. This reduces operational overhead as there's no need to manage and maintain WebSocket or JDBC connections.

Real time queries with S3 are obviously BS. B it is: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html