Free Amazon Data-Engineer-Associate Exam Questions
Absolute Free Data-Engineer-Associate Exam Practice for Comprehensive Preparation
-
Amazon Data-Engineer-Associate Exam Questions
-
Provided By: Amazon
- Exam: AWS Certified Data Engineer Associate (DEA-C01)
- Certification: AWS Certified Associate
-
Total Questions: 513
-
Updated On: Apr 22, 2025
-
Rated: 4.9 |
-
Online Users: 1026
-
Question 1
-
You are a Data Engineer tasked with architecting a solution for an online retail application on AWS. The application must efficiently manage user shopping cart data (stateful transactions) and handle rapid, high-volume event logging for website interactions, like clicks and views (stateless transactions).
Considering the need for high availability, scalability, and near real-time processing, which of the following AWS service combinations is the most appropriate for handling these specific transaction types?
Answer: A
-
You are a Data Engineer tasked with architecting a solution for an online retail application on AWS. The application must efficiently manage user shopping cart data (stateful transactions) and handle rapid, high-volume event logging for website interactions, like clicks and views (stateless transactions).
-
Question 2
-
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?
Answer: B
-
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?
-
Question 3
-
A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-nodeAmazon Redshift cluster. The company organizes the data files in the data lake based on the data source ofeach data file.The company loads all the data files into one table in the Redshift cluster by using a separate COPY commandfor each data file location. This approach takes a long time to load all the data files into the table. Thecompany must increase the speed of the data ingestion. The company does not want to increase the cost of theprocess.Which solution will meet these requirements?
Answer: D
-
A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-nodeAmazon Redshift cluster. The company organizes the data files in the data lake based on the data source ofeach data file.The company loads all the data files into one table in the Redshift cluster by using a separate COPY commandfor each data file location. This approach takes a long time to load all the data files into the table. Thecompany must increase the speed of the data ingestion. The company does not want to increase the cost of theprocess.Which solution will meet these requirements?
-
Question 4
-
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?
Answer: D
-
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?
-
Question 5
-
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?
Answer: D
-
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?