ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

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

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 7
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by milofficial at Jan. 18, 2024, 9:35 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ninomfr64
2 months, 3 weeks ago
Selected Answer: B
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
upvoted 1 times
...
Scotty_Nguyen
3 months, 1 week ago
Selected Answer: B
B is correct
upvoted 1 times
...
Palee
3 months, 2 weeks ago
Selected Answer: B
Most efficient solution
upvoted 1 times
...
bhawna901
7 months, 1 week ago
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.
upvoted 2 times
...
markill123
9 months, 3 weeks ago
Selected Answer: B
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)
upvoted 1 times
...
04e06cb
11 months, 3 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
k350Secops
1 year, 1 month ago
Selected Answer: B
Inside application with minimal effort then using API would be correct
upvoted 2 times
...
DevoteamAnalytix
1 year, 1 month ago
Selected Answer: B
"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.
upvoted 3 times
...
GiorgioGss
1 year, 3 months ago
Selected Answer: B
Even if you don't know nothing about them, you will still choose B because it seems the "LEAST operational overhead" :)
upvoted 3 times
...
Alcee
1 year, 4 months ago
B. DATA API
upvoted 1 times
...
TonyStark0122
1 year, 4 months ago
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.
upvoted 4 times
...
milofficial
1 year, 5 months ago
Selected Answer: B
Real time queries with S3 are obviously BS. B it is: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel