Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A sales company uses AWS Glue ETL to collect, process, and ingest data into an Amazon S3 bucket. The AWS Glue pipeline creates a new file in the S3 bucket every hour. File sizes vary from 200 KB to 300 KB. The company wants to build a sales prediction model by using data from the previous 5 years. The historic data includes 44,000 files. The company builds a second AWS Glue ETL pipeline by using the smallest worker type. The second pipeline retrieves the historic files from the S3 bucket and processes the files for downstream analysis. The company notices significant performance issues with the second ETL pipeline. The company needs to improve the performance of the second pipeline. Which solution will meet this requirement MOST cost-effectively?

A : Use a larger worker type.

B : Increase the number of workers in the AWS Glue ETL jobs.

C : Use the AWS Glue DynamicFrame grouping option.

D : Enable AWS Glue auto scaling.

Answer: D

Question 2

A company has a frontend ReactJS website that uses Amazon API Gateway to invoke REST APIs. The APIs

perform the functionality of the website. A data engineer needs to write a Python script that can be

occasionally invoked through API Gateway. The code must return results to API Gateway.

Which solution will meet these requirements with the LEAST operational overhead?

A : Deploy a custom Python script on an Amazon Elastic Container Service (Amazon ECS) cluster.

B : Create an AWS Lambda Python function with provisioned concurrency.

C : Deploy a custom Python script that can integrate with API Gateway on Amazon Elastic Kubernetes Service (Amazon EKS).

D : Create an AWS Lambda function. Ensure that the function is warm byscheduling an Amazon EventBridge rule to invoke the Lambda function every 5 minutes by usingmock events.

Answer: B

Question 3

A company stores its processed data in an S3 bucket. The company has a strict data access policy. Thecompany uses IAM roles to grant teams within the company different levels of access to the S3 bucket.The company wants to receive notifications when a user violates the data access policy. Each notificationmust include the username of the user who violated the policy.Which solution will meet these requirements?

A : Use AWS Config rules to detect violations of the data access policy. Set up compliance alarms.

B : Use Amazon CloudWatch metrics to gather object-level metrics. Set up CloudWatch alarms.

C : Use AWS CloudTrail to track object-level events for the S3 bucket. Forward events to Amazon CloudWatch to set up CloudWatch alarms.

D : Use Amazon S3 server access logs to monitor access to the bucket. Forward the access logs to an Amazon CloudWatch log group. Use metric filters on the log group to set up CloudWatch alarms.

Answer: C

Question 4

A Data Engineering Team is designing a system to manage a series of dependent data processing and transformation jobs. These jobs involve various AWS services, including AWS Lambda for data manipulation, Amazon S3 for data storage, and AWS Glue for ETL operations. The team needs a robust solution to orchestrate these jobs, ensuring that they execute in a specific sequence and with conditional error handling.

Which AWS service should the team use for the most effective orchestration of these data processing workflows?

A : Implement Amazon Managed Workflows for Apache Airflow (MWAA) for managing job sequences and dependencies

B : Use AWS Step Functions to coordinate the various data processing and transformation tasks across different AWS services in a cost-effective manner.

C : Configure Amazon EventBridge to trigger and manage the sequence of data processing jobs efficiently.

D : Utilize AWS Glue Workflows for orchestrating the data processing jobs, focusing on ETL operations.

Answer: B

Question 5

A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

A : Use AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.

B : Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.

C : Use AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.

D : Manually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Answer: B