Free Amazon AWS-DEA-C01 Exam Questions

Question 1

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

Question 2

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 3

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 4

A Data Engineering Team is responsible for managing and monitoring a large-scale data processing application using AWS services. The application periodically processes vast amounts of unstructured data and stores the results in Amazon S3. The team needs to set up a system to closely monitor the data processing jobs and get alerted if any job fails or underperforms.

Which combination of AWS services should the data engineering team use for effective monitoring and alerting?

A : Leverage AWS Step Functions to manage the data processing workflows and use Amazon CloudWatch alarms to monitor each step's execution status.

B : Use Amazon CloudWatch for monitoring, combined with AWS Lambda functions to check the health of the data processing jobs and send notifications using Amazon SNS.

C : Implement Amazon QuickSight for real-time analytics on the job performance data and set up Amazon SES to email the reports to the team.

D : Utilize AWS X-Ray for tracing the processing jobs and integrate it with Amazon SES to alert the team about any anomalies or failures.

Answer: B

Question 5

A company is deploying a stateful application on Amazon EC2 that requires temporary storage for processing large datasets with maximum I/O. The application must also maintain a smaller subset of essential state data that needs to persist beyond the life of the instance. The company needs a storage solution that ensures the essential data is not lost if the EC2 instance is stopped or terminated.

Which combination of storage solutions should the company choose?

A : Attach Amazon EBS volumes for essential state data and use Amazon DynamoDB for temporary data.

B : Attach additional Amazon EBS volumes for temporary data processing and rely on the root device volume for essential state data.

C : Attach Amazon EC2 instance store volumes for temporary data processing and Amazon Elastic Block Store (EBS) for essential state data.

D : Implement a combination of Amazon EC2 instance store volumes for rapid I/O and EBS snapshots for daily backups of essential data.

Answer: C