Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A Data Engineering Consultant is working on a data processing project that involves AWS services, and the project's code is stored in a Git repository hosted on AWS CodeCommit. The project has a well-established branching strategy, and the consultant needs to update their local copy with the latest changes from the remote repository's main branch, to include recent updates related to AWS configurations and scripts.

Which Git command should be used to update the local repository with these latest changes from AWS CodeCommit?

A : git push origin main

B : git fetch origin mai

C : git commit -m "Update with latest main"

D : git pull origin main

Answer: D

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

An analytics team frequently runs complex Amazon Athena queries on a dataset stored in an Amazon S3 bucket, with AWS Glue Data Catalog serving as the metadata repository. They've identified a slowdown in Athena query plans and attribute it to the excessive number of S3 partitions. The team needs to enhance query performance and reduce the time Athena takes in query planning.

Which two measures should the team take to meet these performance goals? (Select TWO.)

A : Implement AWS Glue Elastic Views to automate partition management.

B : Employ Athena's partition projection for dynamic partitioning based on common query patterns.

C : Merge small S3 objects into larger ones using AWS Glue's data transformation jobs.

D : Use Athena DML statements to reorganize data into fewer, more meaningful partitions.

E : Transform the data that is in the S3 bucket to Apache Parquet format.

Answer: B,E

Question 4

The Cloud Data Engineering team at an e-commerce company is tasked with analyzing historical sales data stored in CSV files in Amazon S3. They require a solution that allows them to directly query this data for their daily sales report, which will include product names, quantities sold, and total sales amounts. The solution should enable them to perform this task without the overhead of cluster management or data loading processes.

Which two steps are essential to set up this process (Select TWO)

A : Create an Amazon Redshift Spectrum external schema for the CSV files and run the query from an Amazon Redshift cluster.

B : Implement an AWS Lambda function to convert the CSV files into JSON format, as Athena cannot query CSV files directly.

C : Use AWS Data Pipeline to transfer the CSV files into an Amazon RDS instance and then query the data with Athena.

D : Write an Amazon Athena SQL query to select the necessary fields, aggregate the quantity and sales amount, and group the results by product name.

E : Use the AWS Glue Data Catalog to catalog the CSV files and define a schema that maps to the fields in the sales data.

Answer: D,E

Question 5

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