Free Amazon Data-Engineer-Associate Exam Questions

Question 1

A telecommunications company collects network usage data throughout each day at a rate of several thousanddata points each second. The company runs an application to process the usage data in real time. Thecompany aggregates and stores the data in an Amazon Aurora DB instance.Sudden drops in network usage usually indicate a network outage. The company must be able to identifysudden drops in network usage so the company can take immediate remedial actions.Which solution will meet this requirement with the LEAST latency?

A : Create an AWS Lambda function to query Aurora for drops in network usage. Use Amazon EventBridge to automatically invoke the Lambda function every minute.

B : Modify the processing application to publish the data to an Amazon Kinesis data stream. Create an Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) application to detect drops in network usage.

C : Replace the Aurora database with an Amazon DynamoDB table. Create an AWS Lambda function to query the DynamoDB table for drops in network usage every minute. Use DynamoDB Accelerator (DAX) between the processing application and DynamoDB table.

D : Create an AWS Lambda function within the Database Activity Streams feature of Aurora to detect drops in network usage.

Answer: B

Question 2

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 : Implement a network Access Control List (ACL) with rules to allow the known IP addresses and deny all others, applying these to the subnet associated with the RDS instance.

B : Configure AWS WAF with a set of rules to allowlist the specific IP addresses, and associate these rules with the RDS instance.

C : Utilize AWS Identity and Access Management (IAM) policies to restrict database access to the specific IP addresses.

D : Modify the inbound rules of the RDS instance's security group to allow traffic from the known IP addresses and deny all other traffic.

Answer: D

Question 3

A company stores large image files in an Amazon S3 bucket. They need a solution to dynamically resize images on-the-fly when accessed by different applications, without storing multiple versions of the same image. The solution should modify the image data during retrieval based on the application's requirements.

Which AWS service should the company use to achieve this on-the-fly transformation of image data?

A : Amazon S3 Object Lambda

B : AWS Lambda@Edge

C : AWS Step Functions

D : Amazon Elastic Transcoder

Answer: A

Question 4

A Data Engineering Consultant is working on optimizing the CI/CD pipeline for a data processing application on AWS. The application's CI/CD pipeline utilizes AWS CodeBuild for its build and test processes. One of the requirements is to reduce build times and resource consumption. The application has conditional build scenarios, where certain builds require more compute resources than others based on the complexity and size of the data being processed.

Which feature of AWS CodeBuild should the consultant configure to optimize the build process while considering varying resource needs for different builds?

A : Use CodeBuild’s buildspec file to define different compute types for each build scenario, dynamically adjusting the environment based on the source code's requirements.

B : Configure CodeBuild to utilize On-Demand instances for regular builds and switch to Spot Instances for resource-intensive builds, optimizing costs and compute resource usage.

C : Implement build batching in CodeBuild to group source versions and run them as a single build, ensuring efficient use of resources for varying build scenarios.

D : Leverage the CodeBuild cache feature to store frequently used build artifacts and dependencies, reducing build times for similar build scenarios.

Answer: A

Question 5

A financial services company is in need of an enhanced storage solution for their transactional relational database system. The solution must ensure high durability, strong consistency, and enhanced read performance for real-time analytics. Additionally, the company needs to maintain high availability and disaster recovery capabilities. Cost management is also a priority, but not at the expense of these performance characteristics. The company's current infrastructure does not require multiple geographical regions.

Which combination of AWS storage services and features should the consultant recommend to meet these requirements? (Select TWO)

A : Use Amazon DynamoDB with provisioned capacity to manage cost while offering built-in high availability and durability.

B : Implement Amazon EFS with lifecycle management policies to transition older transaction data to EFS Infrequent Access.

C : Utilize Amazon ElastiCache to improve read performance and reduce the load on the primary transaction database.

D : Deploy Amazon Aurora Global Database for high performance, availability, and cross-region disaster recovery.

E : Enable Amazon RDS Multi-AZ deployments for high availability and durability with synchronous data replication.

Answer: C,E