Free Amazon AWS-DEA-C01 Exam Questions

Become Amazon Certified with updated AWS-DEA-C01 exam questions and correct answers

Page: 1 / 117

Total 582 Questions | Updated On: May 23, 2026

Add To Cart

Question 1

A data engineering team wants to run SQL queries on their Amazon Redshift cluster from various applications without managing database connections. Which AWS service allows them to submit and manage these queries efficiently?

A : Implement AWS Lambda with Redshift as a trigger for query execution.

B : Use the Amazon Redshift Query Editor for direct SQL execution.

C : Use the Amazon Redshift Data API to run and manage SQL queries.

D : Deploy Amazon EC2 instances to host applications that connect to Redshift.

Answer: C

Question 2

A company has as JSON file that contains personally identifiable information (PIT) data and non-PII data. The company needs to make the data available for querying and analysis. The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees. Which solution will meet these requirements with the LEAST operational overhead?

A : Store the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.

B : Store the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.

C : Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user.

D : Create two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.

Answer: C

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 company needs to load customer data that comes from a third party into an Amazon Redshift datawarehouse. The company stores order data and product data in the same data warehouse. The company wantsto use the combined dataset to identify potential new customers.A data engineer notices that one of the fields in the source data includes values that are in JSON format.How should the data engineer load the JSON data into the data warehouse with the LEAST effort?

A : Use the SUPER data type to store the data in the Amazon Redshift table.

B : Use AWS Glue to flatten the JSON data and ingest it into the Amazon Redshift table.

C : Use Amazon S3 to store the JSON data. Use Amazon Athena to query the data.

D : Use an AWS Lambda function to flatten the JSON data. Store the data in Amazon S3.

Answer: A

Question 5

A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets andAmazon RDS databases. The data catalog must include storage format metadata for the data in the catalog.Which solution will meet these requirements with the LEAST effort?

A : Use an AWS Glue crawler to scan the S3 buckets and RDS databases and build a data catalog. Use data stewards to inspect the data and update the data catalog with the data format.

B : Use an AWS Glue crawler to build a data catalog. Use AWS Glue crawler classifiers to recognize the format of data and store the format in the catalog.

C : Use Amazon Macie to build a data catalog and to identify sensitive data elements. Collect the data format information from Macie.

D : Use scripts to scan data elements and to assign data classifications based on the format of the data.

Answer: B

Page: 1 / 117

Total 582 Questions | Updated On: May 23, 2026

Add To Cart