Amazon Data-Engineer-Associate

Your company's Cloud Data Engineering team is using Amazon Kinesis Data Streams to process real-time streaming data from IoT devices. The stream is configured with 4 shards. Lately, the team observes that during peak operational hours, there are intermittent delays in data processing and some records appear to be dropped. The team is using a custom Kinesis consumer application for data processing.

What initial step should the team take to begin troubleshooting these performance issues?

A company's security team mandates that their Amazon RDS databases should only accept connections from specific, known IP addresses to ensure security. As a data engineer, you are tasked with implementing this requirement for an RDS instance that will be accessed by multiple clients located in different geographical locations, each with a fixed set of IP addresses.

Which of the following would be the most effective and secure way to comply with this security requirement?

A company has multiple data sources stored in different formats on Amazon S3. They want to enable their data analysts to easily discover and access these datasets for analysis. The company needs an efficient way to catalog this data and make it searchable.

Which AWS service should the company use to automate the creation of a data catalog that makes their datasets in Amazon S3 easily discoverable for analysis?

A company uses an Amazon S3 bucket to store data in both JSON and .csv formats. They also operate databases on Amazon RDS for Microsoft SQL Server, have Amazon DynamoDB tables in provisioned capacity mode, and run queries on an Amazon Redshift cluster. They need a straightforward solution that allows their data scientists to perform SQL-like queries across all these data sources.

What is the simplest solution for enabling these queries with the least operational overhead?

A retail company uses Amazon Aurora to manage inventory data. The company's Aurora DB cluster resides in a private subnet. A team member has created an AWS Lambda function to manage inventory levels within the Aurora DB cluster. To maintain data security, the company wants to ensure that this Lambda function can access the Aurora DB cluster only through the private network.

What steps should be taken to enable private connectivity from the Lambda function to the Aurora DB cluster with minimal administrative effort? (Select TWO.)