Amazon AWS Certified Data Engineer - Associate (DEA-C01) Sample Questions:

1. A company uses an Amazon Redshift cluster as a data warehouse that is shared across two departments. To comply with a security policy, each department must have unique access permissions.
Department A must have access to tables and views for Department A. Department B must have access to tables and views for Department B.
The company often runs SQL queries that use objects from both departments in one query.
Which solution will meet these requirements with the LEAST operational overhead?

A) Update the names of the tables and views to follow a naming convention that contains the department names. Manage permissions based on the new naming convention.
B) Create an IAM user group for each department. Use identity-based IAM policies to grant table and view permissions based on the IAM user group.
C) Group tables and views for each department into dedicated databases. Manage permissions at the database level.
D) Group tables and views for each department into dedicated schemas. Manage permissions at the schema level.

2. A company wants to migrate data from an Amazon RDS for PostgreSQL DB instance in the eu-east-1 Region of an AWS account named Account_A. The company will migrate the data to an Amazon Redshift cluster in the eu-west-1 Region of an AWS account named Account_B.
Which solution will give AWS Database Migration Service (AWS DMS) the ability to replicate data between two data stores?

A) Set up an AWS DMS replication instance in Account_B in eu-east-1.
B) Set up an AWS DMS replication instance in a new AWS account in eu-west-1
C) Set up an AWS DMS replication instance in Account_B in eu-west-1.
D) Set up an AWS DMS replication instance in Account_A in eu-east-1.

3. A company stores server logs in an Amazon 53 bucket. The company needs to keep the logs for 1 year. The logs are not required after 1 year.
A data engineer needs a solution to automatically delete logs that are older than 1 year.
Which solution will meet these requirements with the LEAST operational overhead?

A) Schedule a cron job on an Amazon EC2 instance to delete the logs after 1 year.
B) Define an S3 Lifecycle configuration to delete the logs after 1 year.
C) Configure an AWS Step Functions state machine to delete the logs after 1 year.
D) Create an AWS Lambda function to delete the logs after 1 year.

4. A data engineer must orchestrate a data pipeline that consists of one AWS Lambda function and one AWS Glue job. The solution must integrate with AWS services.
Which solution will meet these requirements with the LEAST management overhead?

A) Use an Apache Airflow workflow that is deployed on an Amazon EC2 instance. Define a directed acyclic graph (DAG) in which the first task is to call the Lambda function and the second task is to call the AWS Glue job.
B) Use an AWS Step Functions workflow that includes a state machine. Configure the state machine to run the Lambda function and then the AWS Glue job.
C) Use an Apache Airflow workflow that is deployed on Amazon Elastic Kubernetes Service (Amazon EKS). Define a directed acyclic graph (DAG) in which the first task is to call the Lambda function and the second task is to call the AWS Glue job.
D) Use an AWS Glue workflow to run the Lambda function and then the AWS Glue job.

5. A company processes 500 GB of audience and advertising data daily, storing CSV files in Amazon S3 with schemas registered in AWS Glue Data Catalog. They need to convert these files to Apache Parquet format and store them in an S3 bucket.
The solution requires a long-running workflow with 15 GiB memory capacity to process the data concurrently, followed by a correlation process that begins only after the first two processes complete.

A) Use Amazon EMR to run each process in the workflow. Create an Amazon Simple Queue Service (Amazon SQS) queue to handle messages that indicate the completion of the first two processes.
Configure an AWS Lambda function to process the SQS queue by running the third process.
B) Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the workflow by using AWS Glue. Configure AWS Glue to begin the third process after the first two processes have finished.
C) Use AWS Step Functions to orchestrate a workflow that uses multiple AWS Lambda functions. Ensure that the third process starts after the first two processes have finished.
D) Use AWS Glue workflows to run the first two processes in parallel. Ensure that the third process starts after the first two processes have finished.

Solutions: