AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ217

Data Store Management

A financial services company keeps financial data in Amazon Redshift. A data engineer needs to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run these queries from within the trading application.

Which solution will satisfy 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.
Explanation

Amazon Redshift Data API provides a secure HTTP endpoint and AWS SDK integration for programmatically running SQL statements from web-service-based applications. It eliminates the need to manage persistent database connections, database drivers, connection networking, and related credentials, making it lower operational overhead than JDBC connections.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!