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 Cloud Data Engineering Team is configuring access control for their company's new multi-account AWS environment. They have a centralized security account and require the ability to allow audit teams to access AWS resources across all accounts for monitoring and compliance purposes. The data engineering team needs to establish a mechanism to grant audit team members from the security account least-privilege access to the necessary resources without creating individual IAM users in each account.

Which of the following steps should the data engineering team implement to set up IAM roles effectively for this requirement? (Select TWO)

A : Enable AWS Organizations and use Service Control Policies (SCPs) to grant the audit team access to the necessary resources across all accounts within the organization.

B : Set up AWS Resource Access Manager (RAM) to share resources with the audit team members from the security account, permitting cross-account resource access without IAM roles.

C : Create cross-account IAM roles in each account with permissions policies granting the necessary access, and establish trust relationships to allow the audit team members from the security account to assume these roles.

D : Provision a dedicated IAM user for each audit team member in the security account and assign inline policies to each user that grant permissions to access resources in other accounts.

E : Implement a single IAM role in the security account with permission to assume other IAM roles in the member accounts, allowing the audit team members to switch roles as needed.

Answer: C,E

Question 3

A company wants to migrate an application and an on-premises Apache Kafka server to AWS. Theapplication processes incremental updates that an on-premises Oracle database sends to the Kafka server. Thecompany wants to use the replatform migration strategy instead of the refactor strategy.Which solution will meet these requirements with the LEAST management overhead?

A : Amazon Kinesis Data Streams

B : Amazon Managed Streaming for Apache Kafka (Amazon MSK) provisioned cluster

C : Amazon Data Firehose

D : Amazon Managed Streaming for Apache Kafka (Amazon MSK) Serverless

Answer: D

Question 4

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 5

A data engineering team at an online retail company is optimizing the performance of their Amazon Redshift data warehouse. The warehouse contains a large sales table with millions of rows and a smaller products table. Queries often join these two tables, and the team wants to optimize the query performance, especially for these join operations.

Which Redshift distribution style should the team use for the sales and products tables to enhance query performance?

A : Configure the sales table to ALL distribution and the products table to EVEN distribution.

B : Configure the sales table to AUTO distribution and the products table to ALL distribution.

C : Configure the sales table to EVEN distribution and the products table to KEY distribution.

D : Configure KEY distribution for both the sales and products tables based on the join column.

Answer: B