Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A company needs to partition the Amazon S3 storage that the company uses for a data lake. The partitioning will use a path of the S3 object keys in the following format:

s3://bucket/prefix/year=2023/month=01/day=01

A data engineer must ensure that the AWS Glue Data Catalog synchronizes with the S3 storage when the company adds new partitions to the bucket.

Which solution will meet these requirements with the LEAST latency?

A : Manually run the AWS Glue CreatePartition API twice each day.

B : Run the MSCK REPAIR TABLE command from the AWS Glue console.

C : Schedule an AWS Glue crawler to run every morning.

D : Use code that writes data to Amazon S3 to invoke the Boto3 AWS Glue create_partition API call.

Answer: B

Question 2

As a Data Engineer, you are tasked with setting up a batch data ingestion pipeline for a substantial financial dataset. This data is currently housed in an Amazon RDS database, stemming from various financial services and trading platforms. The dataset is complex and heterogeneous, predominantly in JSON format, and is updated nightly, typically ranging between 100-200 GB.

Your primary objective is to efficiently transfer this data from the RDS database to a data lake in AWS, ensuring reliable storage and preparing the dataset for analytical processing with minimal yet capable transformation steps due to its complexity.

Which combination of AWS services would be most appropriate?

A : Amazon AppFlow to facilitate the data transfer from Amazon RDS to Amazon S3. Afterward, utilize AWS Glue ETL for the data transformation processes.

B : Use AWS Database Migration Service (AWS DMS) to continuously replicate data from the Amazon RDS database to Amazon S3. Then, employ AWS Lambda for performing the necessary data transformations.

C : Configure AWS DataSync to transfer the JSON data nightly from the RDS database to Amazon S3. Subsequently, use AWS Glue ETL service to perform the necessary data transformations.

D : Use AWS Database Migration Service (AWS DMS) to continuously replicate data to Amazon S3. Configure an AWS Glue Crawler to update the schema in the Glue Data Catalog, and use Amazon Glue ETL for transformation jobs.

Answer: D

Question 3

An organization's primary transaction processing system is powered by an Amazon RDS for PostgreSQL database. The workload is write-heavy, which is causing consistently high CPU utilization, leading to performance degradation of the system.

What measures should the data engineer implement to alleviate the CPU load on the RDS instance? (Select TWO.)

A : Enable Amazon RDS Performance Insights to analyze and identify expensive queries contributing to high CPU usage.

B : Implement Amazon ElastiCache to cache frequent queries and decrease the read load on the database.

C : Configure a read replica to offload read operations and reduce the load on the primary instance.

D : Increase the IOPS allocation for the RDS instance to handle the write-heavy workload more efficiently.

E : Scale up the RDS instance to a larger class with more CPU and memory resources.

Answer: A,E

Question 4

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 5

A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. TheETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, andload data into Amazon Redshift.The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python toorchestrate the jobs.Which service will meet these requirements?

A : Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

B : AWS Step Functions

C : AWS Glue

D : Amazon EventBridge

Answer: A