Official Bank
0/294
Page
1/4
AWS Certified Data Engineer – Associate Exam (DEA-C01) - AWS Exam Questions
Last updated on June 20, 2026
97%
Exam Compliance
294
Total Questions
1
Question
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?
Which solution will give AWS Database Migration Service (AWS DMS) the ability to replicate data between two data stores?
Options
A
Set up an AWS DMS replication instance in a new AWS account in eu-west-1
B
Set up an AWS DMS replication instance in Account_B in eu-west-1.
C
Set up an AWS DMS replication instance in Account_B in eu-east-1.
D
Set up an AWS DMS replication instance in Account_A in eu-east-1.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
2
Question
A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into the new cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encrypted both at rest and in transit. The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. The data engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file.
Which solution will meet these requirements?
Which solution will meet these requirements?
Options
A
Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Create a second security configuration. Specify the Amazon S3 path of the PEM file for in-transit encryption. Create the EMR cluster, and attach both security configurations to the cluster.
B
Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption.
Use the security configuration during EMR cluster creation.
Use the security configuration during EMR cluster creation.
C
Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for local disk encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption.
Use the security configuration during EMR cluster creation.
Use the security configuration during EMR cluster creation.
D
Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption.
Create the EMR cluster, and attach the security configuration to the cluster.
Create the EMR cluster, and attach the security configuration to the cluster.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
3
Question
A company runs multiple applications on AWS. The company configured each application to output logs. The company wants to query and visualize the application logs in near real time.
Which solution will meet these requirements?
Which solution will meet these requirements?
Options
A
Configure the applications to output logs to Amazon CloudWatch Logs log groups. Use CloudWatch log anomaly detection to query and visualize the log data.
B
Configure the applications to output logs to Amazon CloudWatch Logs log groups. Create an Amazon S3 bucket. Create an AWS Lambda function that runs on a schedule to export the required log groups to the S3 bucket. Use Amazon Athena to query the log data in the S3 bucket.
C
Create an Amazon OpenSearch Service domain. Configure the applications to output logs to Amazon CloudWatch Logs log groups. Create an OpenSearch Service subscription filter for each log group to stream the data to OpenSearch. Create the required queries and dashboards in OpenSearch
Service to analyze and visualize the data.
Service to analyze and visualize the data.
D
Update the application code to send the log data to Amazon QuickSight by using Super-fast,
Parallel, In-memory Calculation Engine (SPICE). Create the required analyses and dashboards in QuickSight.
Parallel, In-memory Calculation Engine (SPICE). Create the required analyses and dashboards in QuickSight.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
4
Question
A company has a data processing pipeline that runs multiple SQL queries in sequence against an Amazon Redshift cluster. After a merger, a query joining two large sales tables becomes slow. Table S1 has 10 billion records, Table S2 has 900 million records. The query performance must improve.
Select 2
Options
A
Use the KEY distribution style for both sales tables. Select a low cardinality column to use for the join.
B
Use the EVEN distribution style for Table S1. Use the ALL distribution style for Table S2.
C
Use the KEY distribution style for both sales tables. Select a high cardinality column to use for the join.
D
Use the Amazon Redshift query optimizer to review and select optimizations to implement.
E
Use Amazon Redshift Advisor to review and select optimizations to implement.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
5
Question
A data engineer develops an AWS Glue Apache Spark ETL job to perform transformations on a dataset. When the data engineer runs the job, the job returns an error that reads, “No space left on device.” The data engineer needs to identify the source of the error and provide a solution.
Which combinations of steps will meet this requirement MOST cost-effectively? (Select TWO.)
Which combinations of steps will meet this requirement MOST cost-effectively? (Select TWO.)
Select 2
Options
A
Scale out the number of workers horizontally to address data skewness.
B
Scale out the workers vertically to address data skewness.
C
Use the Spark UI and AWS Glue metrics to monitor data skew in the Spark executors.
D
Enable the --write-shuffle-files-to-s3 job parameter. Use the salting technique.
E
Use error logs in Amazon CloudWatch to monitor data skew.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.