Free Amazon AWS-DEA-C01 Exam Questions

Question 1

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 2

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 3

A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-nodeAmazon Redshift cluster. The company organizes the data files in the data lake based on the data source ofeach data file.The company loads all the data files into one table in the Redshift cluster by using a separate COPY commandfor each data file location. This approach takes a long time to load all the data files into the table. Thecompany must increase the speed of the data ingestion. The company does not want to increase the cost of theprocess.Which solution will meet these requirements?

A : Use a provisioned Amazon EMR cluster to copy all the data files into one folder. Use a COPY command to load the data into Amazon Redshift.

B : Load all the data files in parallel into Amazon Aurora. Run an AWS Glue job to load the data into Amazon Redshift.

C : Use an AWS Glue job to copy all the data files into one folder. Use a COPY command to load the data into Amazon Redshift.

D : Create a manifest file that contains the data file locations. Use a COPY command to load the data into Amazon Redshift.

Answer: D

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 healthcare organization stores patient records from multiple regions in an Amazon S3 bucket, which is used for regional health analysis. A data compliance team needs to ensure that health analysts can only access patient records from their specific region to comply with local privacy regulations.

Which solution will enable this requirement with the minimum amount of operational effort?

A : Import the data into an Amazon Aurora database, set up regional schemas, and create IAM policies that grant access to these schemas based on the analyst's region.

B : Implement AWS Lake Formation, register the S3 bucket as a data lake, and utilize Lake Formation's fine-grained access control to manage region-specific data access.

C : Distribute the data across multiple AWS Regions correlating to the patient locations, and implement IAM policies to grant data access to analysts within the same geographical region.

D : Segment the patient records into different S3 prefixes per region, and use IAM bucket policies to restrict access to analysts based on their regional assignment.

Answer: B