Free AWS DEA-C01 Practice Questions & Answers 2026 Part1

Question #1

A financial company wants to implement a data mesh. The data mesh must support centralized data governance, data analysis, and data access control. The company has decided to use AWS Glue for data catalogs and extract, transform, and load (ETL) operations.Which combination of AWS services will implement a data mesh? (Choose two.)

A. se Amazon Aurora for data storage

B. se Amazon S3 for data storage

C. se AWS Glue DataBrew for centralized data governance and access control

D. se Amazon RDS for data storage

E. se AWS Lake Formation for centralized data governance and access control

View answer

Correct Answer: BE

Question #2

A financial company wants to implement a data mesh. The data mesh must support centralized data governance, data analysis, and data access control. The company has decided to use AWS Glue for data catalogs and extract, transform, and load (ETL) operations. Which combination of AWS services will implement a data mesh? (Choose two.)

A. Use Amazon Aurora for data storage

B. Use Amazon S3 for data storage

C. Use AWS Glue DataBrewfor centralized data governance and access control

D. Use Amazon RDS for data storage

E. Use AWS Lake Formation for centralized data governance and access control

View answer

Correct Answer: BE

Question #3

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #4

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #5

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?

A. Parallel state

B. Choice state

C. Map state

D. Wait state

View answer

Correct Answer: C

Question #6

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?

A. Parallel state

B. Choice state

C. Map state

D. Wait state

View answer

Correct Answer: C

Question #7

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #8

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #9

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #10

A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data engineer has set up the necessary AWS Glue connection details and an associated IAM role. However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint.The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket.Which solution will meet this requirement?

A. Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint

B. Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket

C. Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name

D. Verify that the VPC's route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint

View answer

Correct Answer: D

Question #11

1. + - ------------------------------------------------------------- + 2. | SYSTEM$CLUSTERING_INFORMATION('SF_DATA', '(COL1, COL3)') | 3. | - ------------------------------------------------------------- | 4. | { | 5. | "cluster_by_keys" : "(COL1, COL3)", | 6. | "total_partition_count" : 1156, | 7. | "total_constant_partition_count" : 0, | 8. | "average_overlaps" : 117.5484, | 9. | "average_depth" : 64.0701, | 10. | "partition_depth_histogram" : { | 11. | "00000" : 0, | 12. | "00001" : 0, | 13. | "00002" : 3, | 14. | "00003" : 3, | 15. | "00004" : 4, | 16. | "00005" : 6, | 17. | "00006" : 3, | 18. | "00007" : 5, | 19. | "00008" : 10, | 20. | "00009" : 5, | 21. | "00010" : 7, | 22. | "00011" : 6, | 23. | "00012" : 8, | 24. | "00013" : 8, | 25. | "00014" : 9, | 26. | "00015" : 8, | 27. | "00016" : 6, | 28. | "00032" : 98, | 29. | "00064" : 269, | 30. | "00128" : 698 | 31. | } | 32. | } | 33. + - ------------------------------------------------------------- + The Above example indicates that the SF_DATA table is not well - clustered for which of following valid reasons?

A. Zero (0) constant micro - partitions out of 1156 total micro - partitions

B. High average of overlapping micro - partitions

C. High average of overlap depth across micro - partitions

D. Most of the micro - partitions are grouped at the lower - end of the histogram, with the majority of micro - partitions having an overlap depth between 64 and 128

E. ALL of the above

View answer

Correct Answer: E

Question #12

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #13

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #14

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #15

A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.Which solution will meet these requirements?

A. reate an S3 bucket for each use case

B. reate an Athena workgroup for each use case

C. reate an IAM role for each use case

D. reate an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case

View answer

Correct Answer: B

Question #16

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #17

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #18

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #19

A data engineer creates separate layers for raw data, cleaned data, and business-ready tables. What is the main benefit?

A. It makes every query run without compute resources

B. It removes the need for all governance controls

C. It prevents source systems from changing

D. It improves data organization, traceability, and reuse

View answer

Correct Answer: d

Question #20

Which stages support external tables?

A. nternal stages only; within a single Snowflake account

B. nternal stages only from any Snowflake account in the organization

C. xternal stages only from any region, and any cloud provider

D. xternal stages only, only on the same region and cloud provider as the Snowflake account

View answer

Correct Answer: C

Question #21

A retail company has a customer data hub in an Amazon S3 bucket. Employees from many countries use the data hub to support company-wide analytics. A governance team must ensure that the company's data analysts can access data only for customers who are within the same country as the analysts.Which solution will meet these requirements with the LEAST operational effort?

A. Create a separate table for each country's customer data

B. Register the S3 bucket as a data lake location in AWS Lake Formation

C. Move the data to AWS Regions that are close to the countries where the customers are

D. Load the data into Amazon Redshift

View answer

Correct Answer: B

Question #22

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #23

A data engineer has two datasets that contain sales information for multiple cities and states. One dataset is named reference, and the other dataset is named primary.The data engineer needs a solution to determine whether a specific set of values in the city and state columns of the primary dataset exactly match the same specific values in the reference dataset. The data engineer wants to use Data Quality Definition Language (DQDL) rules in an AWS Glue Data Quality job.Which rule will meet these requirements?

A. DatasetMatch 'reference' 'city->ref_city, state->ref_state' = 1

B. ReferentialIntegrity 'city,state' 'reference

C. DatasetMatch 'reference' 'city->ref_city, state->ref_state' = 100

D. ReferentialIntegrity 'city,state' 'reference

View answer

Correct Answer: A

Question #24

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #25

A system calculates a rolling count of active users over the last ten minutes. Which processing technique is being applied?

A. Manual data-entry validation

B. Quarterly offline consolidation

C. Static report archiving

D. Sliding-window computation

View answer

Correct Answer: d

Question #26

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #27

You have been tasked with migrating an on-premises MySQL database to Amazon Aurora PostgreSQL using AWS Database Migration Service (DMS). The stakeholder emphasizes that the source database must remain fully operational during the migration process.Which of the following statements about DMS is accurate with respect to this scenario?

A. WS DMS supports both full-load and continuous replication, allowing the source MySQL database to remain operational during migration

B. WS DMS requires the source MySQL database to be version 5

C. WS DMS only supports full-load migrations, which would require downtime for the source database

D. hen using DMS, the target Amazon Aurora PostgreSQL instance cannot be accessed or queried until the migration is complete

E. WS DMS can convert the MySQL database schema directly to PostgreSQL without any manual intervention

View answer

Correct Answer: A

Question #28

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #29

What is the primary purpose of data lineage in data engineering?

A. To optimize query performance

B. To transform data formats

C. To trace the source and flow of data

D. To create visualizations

View answer

Correct Answer: c

Question #30

A company is planning to upgrade its Amazon Elastic Block Store (Amazon EBS) General Purpose SSD storage from gp2 to gp3. The company wants to prevent any interruptions in its Amazon EC2 instances that will cause data loss during the migration to the upgraded storage.Which solution will meet these requirements with the LEAST operational overhead?

A. reate snapshots of the gp2 volumes

B. reate new gp3 volumes

C. hange the volume type of the existing gp2 volumes to gp3

D. se AWS DataSync to create new gp3 volumes

View answer

Correct Answer: C

Question #31

A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.Which solution will meet these requirements with the LEAST operational overhead?

A. tore frequently accessed data in Amazon S3

B. stablish WebSocket connections to Amazon Redshift

C. se the Amazon Redshift Data API

D. et up Java Database Connectivity (JDBC) connections to Amazon Redshift

View answer

Correct Answer: C

Question #32

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #33

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #34

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #35

A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.Which AWS service or feature will meet these requirements MOST cost-effectively?

A. AWS Step Functions

B. AWS Glue workflows

C. AWS Glue Studio

D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

View answer

Correct Answer: B

Question #36

A company processes a CSV file that contains millions of transaction records every day. The file is stored in Amazon S3. Each transaction must be validated before updating a database. The company needs a solution that will process the data in parallel. The solution must use error handling that stops the entire process if more than 15% of the records fail validation.Which solution will meet these requirements with the LEAST operational overhead?

A. se AWS Step Functions Distributed Map state with the ToleratedFailurePercentage field set to 15%

B. reate an AWS Batch job that processes chunks of the file in parallel with a custom error tracking mechanism

C. se AWS Lambda with S3 Batch Operations to process the file and track validation failures to be less than 15%

D. eploy an Amazon EMR cluster with Spark to process the file

View answer

Correct Answer: A

Question #37

A retail company has a customer data hub in an Amazon S3 bucket. Employees from many countries use the data hub to support company-wide analytics. A governance team must ensure that the company's data analysts can access data only for customers who are within the same country as the analysts.Which solution will meet these requirements with the LEAST operational effort?

A. Create a separate table for each country's customer data

B. Register the S3 bucket as a data lake location in AWS Lake Formation

C. Move the data to AWS Regions that are close to the countries where the customers are

D. Load the data into Amazon Redshift

View answer

Correct Answer: B

Question #38

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #39

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #40

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?

A. Parallel state

B. Choice state

C. Map state

D. Wait state

View answer

Correct Answer: C

Question #41

A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.Which solution will meet these requirements with the LEAST operational overhead?

A. stablish WebSocket connections to Amazon Redshift

B. se the Amazon Redshift Data API

C. et up Java Database Connectivity (JDBC) connections to Amazon Redshift

D. tore frequently accessed data in Amazon S3

View answer

Correct Answer: B

Question #42

A data engineer needs to securely transfer 5 TB of data from an on-premises data center to an Amazon S3 bucket. Approximately 5% of the data changes every day. Updates to the data need to be regularly proliferated to the S3 bucket. The data includes files that are in multiple formats. The data engineer needs to automate the transfer process and must schedule the process to run periodically.Which AWS service should the data engineer use to transfer the data in the MOST operationally efficient way?

A. AWS DataSync

B. AWS Glue

C. AWS Direct Connect

D. Amazon S3 Transfer Acceleration

View answer

Correct Answer: A

Question #43

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #44

A Data Engineer wants to check the status of a pipe named my_pipe. The pipe is inside a databasenamed test and a schema named Extract (case-sensitive).Which query will provide the status of the pipe?

A. ELECT FROM SYSTEM$PIPE_STATUS (''test

B. ELECT FROM SYSTEM$PIPE_STATUS (,test

C. ELE2T * FROM SYSTEM$PIPE_STATUS < ' test

D. ELECT * FROM SYSTEM$PIPE_STATUS ("test

View answer

Correct Answer: C

Question #45

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. et up an AWS DMS replication instance in Account_B in eu-east-1

B. et up an AWS DMS replication instance in Account_B in eu-west-1

C. et up an AWS DMS replication instance in a new AWS account in eu-west-1

D. et up an AWS DMS replication instance in Account_A in eu-east-1

View answer

Correct Answer: B

Question #46

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform.The company wants to minimize the effort and time required to incorporate third-party datasets.Which solution will meet these requirements with the LEAST operational overhead?

A. Use API calls to access and integrate third-party datasets from AWS Data Exchange

B. Use API calls to access and integrate third-party datasets from AWS DataSync

C. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories

D. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR)

View answer

Correct Answer: A

Question #47

A company uses AWS Step Functions to orchestrate a data pipeline. The pipeline consists of Amazon EMR jobs that ingest data from data sources and store the data in an Amazon S3 bucket. The pipeline also includes EMR jobs that load the data to Amazon Redshift.The company's cloud infrastructure team manually built a Step Functions state machine. The cloud infrastructure team launched an EMR cluster into a VPC to support the EMR jobs. However, the deployed Step Functions state machine is not able to run the EMR jobs.Which combination of steps should the company take to identify the reason the Step Functions state machine is not able to run the EMR jobs? (Choose two.)

A. se AWS CloudFormation to automate the Step Functions state machine deployment

B. erify that the Step Functions state machine code has all IAM permissions that are necessary to create and run the EMR jobs

C. heck for entries in Amazon CloudWatch for the newly created EMR cluster

D. uery the flow logs for the VPC

E. heck the retry scenarios that the company configured for the EMR jobs

View answer

Correct Answer: BD

Question #48

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #49

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #50

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #51

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?

A. Parallel state

B. Choice state

C. Map state

D. Wait state

View answer

Correct Answer: C

Question #52

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform.The company wants to minimize the effort and time required to incorporate third-party datasets.Which solution will meet these requirements with the LEAST operational overhead?

A. Use API calls to access and integrate third-party datasets from AWS Data Exchange

B. Use API calls to access and integrate third-party datasets from AWS DataSync

C. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories

D. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR)

View answer

Correct Answer: A

Question #53

A company builds a new data pipeline to process data for business intelligence reports. Users have noticed that data is missing from the reports.A data engineer needs to add a data quality check for columns that contain null values and for referential integrity at a stage before the data is added to storage.Which solution will meet these requirements with the LEAST operational overhead?

A. se Amazon SageMaker Data Wrangler and a custom Python transform to create custom rules to check for null values and referential integrity

B. se AWS Glue ETL jobs to perform a SQL transform on the data to determine whether requested column contain null values

C. se Amazon SageMaker Data Wrangler to create a Data Quality and Insights report

D. se AWS Glue ETL jobs to perform a data quality evaluation transform on the data

View answer

Correct Answer: D

Question #54

A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions.The data engineer requires a less manual way to update the Lambda functions.Which solution will meet this requirement?

A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket

B. Package the custom Python scripts into Lambda layers

C. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket

D. Assign the same alias to each Lambda function

View answer

Correct Answer: B

Question #55

A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling.Which solution will meet this requirement?

A. Turn on concurrency scaling in workload management (WLM) for Redshift Serverless workgroups

B. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster

C. Turn on concurrency scaling in the settings during the creation of any new Redshift cluster

D. Turn on concurrency scaling for the daily usage quota for the Redshift cluster

View answer

Correct Answer: B

Question #56

Which tool is commonly associated with data development, scheduling, and workflow orchestration in Alibaba Cloud data engineering?

A. CDN

B. DataWorks

C. RAM

D. SLB

View answer

Correct Answer: b

Question #57

A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.Which extract, transform, and load (ETL) service will meet these requirements?

A. AWS Glue

B. Amazon EMR

C. AWS Lambda

D. Amazon Redshift

View answer

Correct Answer: B

Question #58

A data engineer must manage the ingestion of real-time streaming data into AWS. The data engineer wants to perform real-time analytics on the incoming streaming data by using time-based aggregations over a window of up to 30 minutes. The data engineer needs a solution that is highly fault tolerant.Which solution will meet these requirements with the LEAST operational overhead?

A. se an AWS Lambda function that includes both the business and the analytics logic to perform time-based aggregations over a window of up to 30 minutes for the data in Amazon Kinesis Data Streams

B. se Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data that might occasionally contain duplicates by using multiple types of aggregations

C. se an AWS Lambda function that includes both the business and the analytics logic to perform aggregations for a tumbling window of up to 30 minutes, based on the event timestamp

D. se Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data by using multiple types of aggregations to perform time-based analytics over a window of up to 30 minutes

View answer

Correct Answer: D

Question #59

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #60

A company stores customer data that contains personally identifiable information (PII) in an Amazon Redshift cluster. The company's marketing, claims, and analytics teams need to be able to access the customer data.The marketing team should have access to obfuscated claim information but should have full access to customer contact information. The claims team should have access to customer information for each claim that the team processes. The analytics team should have access only to obfuscated PII data.Which solution will enforce these data access requirements with the LEAST administrative overhead?

A. reate a separate Redshift cluster for each team

B. ove the customer data to an Amazon S3 bucket

C. reate a separate Amazon Redshift database role for each team

D. reate views that include required fields for each of the data requirements

View answer

Correct Answer: C

Question #61

A company uploads .csv files to an Amazon S3 bucket. The company's data platform team has set up an AWS Glue crawler to perform data discovery and to create the tables and schemas.An AWS Glue job writes processed data from the tables to an Amazon Redshift database. The AWS Glue job handles column mapping and creates the Amazon Redshift tables in the Redshift database appropriately.If the company reruns the AWS Glue job for any reason, duplicate records are introduced into the Amazon Redshift tables. The company needs a solution that will update the Redshift tables without duplicates.Which solution will meet these requirements?

A. Modify the AWS Glue job to copy the rows into a staging Redshift table

B. Modify the AWS Glue job to load the previously inserted data into a MySQL database

C. Use Apache Spark's DataFrame dropDuplicates() API to eliminate duplicates

D. Use the AWS Glue ResolveChoice built-in transform to select the value of the column from the most recent record

View answer

Correct Answer: A

Question #62

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #63

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #64

A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data engineer has set up the necessary AWS Glue connection details and an associated IAM role. However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint.The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket.Which solution will meet this requirement?

A. Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint

B. Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket

C. Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name

D. Verify that the VPC's route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint

View answer

Correct Answer: D

Question #65

In a data engineering pipeline, a company is using multiple applications and teams to access a shared Amazon S3 bucket. To streamline access and simplify permissions management for these different entities, which S3 feature should the company utilize?

A. Enable multiple IAM roles, each corresponding to an application or team, granting access to the S3 bucket

B. Use S3 Access Points to create unique endpoints with tailored permissions for each application or team

C. Activate S3 Transfer Acceleration for the bucket to ensure fast and differentiated access for each application or team

D. Implement S3 Lifecycle policies for each application or team to manage their specific data access and retention

View answer

Correct Answer: b

Question #66

A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time.Which solution will run the Glue jobs in the MOST cost-effective way?

A. Choose the FLEX execution class in the Glue job properties

B. Use the Spot Instance type in Glue job properties

C. Choose the STANDARD execution class in the Glue job properties

D. Choose the latest version in the GlueVersion field in the Glue job properties

View answer

Correct Answer: A

Question #67

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #68

A data engineer configured an AWS Glue Data Catalog for data that is stored in Amazon S3 buckets. The data engineer needs to configure the Data Catalog to receive incremental updates.The data engineer sets up event notifications for the S3 bucket and creates an Amazon Simple Queue Service (Amazon SQS) queue to receive the S3 events.Which combination of steps should the data engineer take to meet these requirements with LEAST operational overhead? (Select TWO.)

A. Create an S3 event-based AWS Glue crawler to consume events from the SQS queue

B. Define a time-based schedule to run the AWS Glue crawler, and perform incremental updates to the Data Catalog

C. Use an AWS Lambda function to directly update the Data Catalog based on S3 events that the SQS queue receives

D. Manually initiate the AWS Glue crawler to perform updates to the Data Catalog when there is a change in the S3 bucket

E. Use AWS Step Functions to orchestrate the process of updating the Data Catalog based on 53 events that the SQS queue receives

View answer

Correct Answer: AC

Question #69

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #70

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #71

Which practices help improve reliability in real-time processing jobs? (Select TWO)

A. Configure checkpointing or state recovery where supported

B. Monitor throughput, latency, and processing errors

C. Disable all retries to avoid duplicate handling

D. Ignore failures if the job restarts automatically

E. Remove alerting from production pipelines

View answer

Correct Answer: ab

Question #72

A company maintains multiple extract, transform, and load (ETL) workflows that ingest data from the company's operational databases into an Amazon S3 based data lake. The ETL workflows use AWS Glue and Amazon EMR to process data.The company wants to improve the existing architecture to provide automated orchestration and to require minimal manual effort.Which solution will meet these requirements with the LEAST operational overhead?

A. AWS Glue workflows

B. AWS Step Functions tasks

C. AWS Lambda functions

D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA) workflows

View answer

Correct Answer: B

Question #73

A manufacturing company collects sensor data from its factory floor to monitor and enhance operational efficiency. The company uses Amazon Kinesis Data Streams to publish the data that the sensors collect to a data stream. Then Amazon Kinesis Data Firehose writes the data to an Amazon S3 bucket.The company needs to display a real-time view of operational efficiency on a large screen in the manufacturing facility.Which solution will meet these requirements with the LOWEST latency?

A. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor data

B. Configure the S3 bucket to send a notification to an AWS Lambda function when any new object is created

C. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor data

D. Use AWS Glue bookmarks to read sensor data from the S3 bucket in real time

View answer

Correct Answer: A

Question #74

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. urn on the public access setting for the DB instance

B. pdate the security group of the DB instance to allow only Lambda function invocations on the database port

C. onfigure the Lambda function to run in the same subnet that the DB instance uses

D. ttach the same security group to the Lambda function and the DB instance

E. pdate the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #75

A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column.Which solution will MOST speed up the Athena query performance?

A. Change the data format from

B. Compress the

C. Change the data format from

D. Compress the

View answer

Correct Answer: C

Question #76

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #77

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #78

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #79

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #80

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #81

A company uses Amazon S3 to store data and Amazon QuickSight to create visualizations.The company has an S3 bucket in an AWS account named Hub-Account. The S3 bucket is encrypted with an AWS Key Management Service (AWS KMS) key. The company's Amazon QuickSight instance is in a separate AWS account named BI-Account.The company updates the S3 bucket policy to grant access to the QuickSight service role. The company wants to enable cross-account access to allow QuickSight to interact with the S3 bucket.Which combination of steps will meet this requirement? (Select TWO)

A. Use the existing AWS KMS key to encrypt connections from QuickSight to the S3 bucket

B. Add the S3 bucket as a resource that the QuickSight service role can access

C. Use AWS Resource Access Manager (AWS RAM) to share the S3 bucket with the BI-Account

D. Add an IAM policy to the QuickSight service role to give QuickSight access to the KMS key that encrypts the S3 bucket

E. Add the KMS key as a resource that the QuickSight service role can access

View answer

Correct Answer: BD

Question #82

A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column.Which solution will MOST speed up the Athena query performance?

A. Change the data format from

B. Compress the

C. Change the data format from

D. Compress the

View answer

Correct Answer: C

Question #83

A data engineer must orchestrate a series of Amazon Athena queries that will run every day. Each query can run for more than 15 minutes.Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)

A. Use an AWS Lambda function and the Athena Boto3 client start_query_execution API call to invoke the Athena queries programmatically

B. Create an AWS Step Functions workflow and add two states

C. Use an AWS Glue Python shell job and the Athena Boto3 client start_query_execution API call to invoke the Athena queries programmatically

D. Use an AWS Glue Python shell script to run a sleep timer that checks every 5 minutes to determine whether the current Athena query has finished running successfully

E. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the Athena queries in AWS Batch

View answer

Correct Answer: AB

Question #84

A company has an Amazon S3-based data lake. The data lake contains datasets that belong to multiple departments. The data lake ingests millions of customer records each day.A data engineer needs to design an access and storage solution that allows departments to access only the subset of the company's dataset that each department requires. The solution must follow the principle of least privilege.Which solution will meet these requirements with the LEAST operational effort?

A. eploy an Amazon RDS for PostgreSQL database that has the aws_s3 extension installed

B. efine IAM policies and IAM roles for each department

C. et up AWS Lake Formation

D. et up Amazon Redshift and Amazon Redshift Spectrum as the primary entry points for the data lake

View answer

Correct Answer: C

Question #85

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #86

A company loads transaction data for each day into Amazon Redshift tables at the end of each day. The company wants to have the ability to track which tables have been loaded and which tables still need to be loaded.A data engineer wants to store the load statuses of Redshift tables in an Amazon DynamoDB table. The data engineer creates an AWS Lambda function to publish the details of the load statuses to DynamoDB.How should the data engineer invoke the Lambda function to write load statuses to the DynamoDB table?

A. Use a second Lambda function to invoke the first Lambda function based on Amazon CloudWatch events

B. Use the Amazon Redshift Data API to publish an event to Amazon EventBridge

C. Use the Amazon Redshift Data API to publish a message to an Amazon Simple Queue Service (Amazon SQS) queue

D. Use a second Lambda function to invoke the first Lambda function based on AWS CloudTrail events

View answer

Correct Answer: B

Question #87

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #88

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #89

A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtown for the applications that access the database.Which AWS service should the company use to meet these requirements?

A. AWS Lambda

B. AWS Database Migration Service (AWS DMS)

C. AWS Direct Connect

D. AWS DataSync

View answer

Correct Answer: B

Question #90

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #91

Pivoting in SQL is mainly used to transform data from:

A. One row to one column

B. Only one column to one row

C. Multiple columns into multiple rows

D. Multiple rows into multiple columns

View answer

Correct Answer: d

Question #92

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #93

A company needs to build an extract, transform, and load (ETL) pipeline that has separate stages for batch data ingestion, transformation, and storage. The pipeline must store the transformed data in an Amazon S3 bucket. Each stage must automatically retry failures. The pipeline must provide visibility into the success or failure of individual stages.Which solution will meet these requirements with the LEAST operational overhead?

A. chedule Apache Airflow directed acyclic graphs (DAGs) on Amazon Manages Workflows tor Apache Airflow (Amazon MWAA) to orchestrate pipeline steps

B. uild an Amazon EventBridge based pipeline that invokes AWS Lambda functions to perform each stage

C. eploy AWS Step Functions workflows to orchestrate AWS Lambda functions that ingest data

D. hain AWS Glue jobs that perform each stage together by using job triggers

View answer

Correct Answer: C

Question #94

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #95

A retail company has a customer data hub in an Amazon S3 bucket. Employees from many countries use the data hub to support company - wide analytics. A governance team must ensure that the company's data analysts can access data only for customers who are within the same country as the analysts. Which solution will meet these requirements with the LEAST operational effort?

A. Create a separate table for each country's customer data

B. Register the S3 bucket as a data lake location in AWS Lake Formation

C. Move the data to AWS Regions that are close to the countries where the customers are

D. Load the data into Amazon Redshift

View answer

Correct Answer: B

Question #96

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. et up an AWS DMS replication instance in Account_B in eu-east-1

B. et up an AWS DMS replication instance in Account_B in eu-west-1

C. et up an AWS DMS replication instance in a new AWS account in eu-west-1

D. et up an AWS DMS replication instance in Account_A in eu-east-1

View answer

Correct Answer: A

Question #97

A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data.Which solution will meet these requirements with the LEAST operational overhead?

A. un an AWS Glue crawler on the S3 objects

B. repare an AWS Glue DataBrew project to consume the S3 objects and to query the required column

C. se S3 Select to write a SQL SELECT statement to retrieve the required column from the S3 objects

D. onfigure an AWS Lambda function to load data from the S3 bucket into a pandas dataframe

View answer

Correct Answer: C

Question #98

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third - party datasets into the company's existing analytics platform. The company wants to minimize the effort and time required to incorporate third - party datasets. Which solution will meet these requirements with the LEAST operational overhead?

A. Use API calls to access and integrate third - party datasets from AWS Data Exchange

B. Use API calls to access and integrate third - party datasets from AWS

C. Use Amazon Kinesis Data Streams to access and integrate third - party datasets from AWS CodeCommit repositories

D. Use Amazon Kinesis Data Streams to access and integrate third - party datasets from Amazon Elastic Container Registry (Amazon ECR)

View answer

Correct Answer: A

Question #99

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #100

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now

Free AWS DEA-C01 Practice Questions & Answers 2026 Part1

View The Updated AWS Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE Get Now

Free AWS DEA-C01 Practice Questions & Answers 2026 Part1

View The Updated AWS Exam Questions

View Answers after Submission

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now