Free Amazon Data-Engineer-Associate Exam Questions

Question 1

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?

A : Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.

B : Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.

C : Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.

D : Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Answer: D

Question 2

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.0

B : ReferentialIntegrity "city,state" "reference.{ref_city,ref_state}" = 1.0

C : DatasetMatch "reference" "city->ref_city, state->ref_state" = 100

D : ReferentialIntegrity "city,state" "reference.{ref_city,ref_state}" = 100

Answer: A

Question 3

A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into thenew cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encryptedboth at rest and in transit.The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. Thedata engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file.Which solution will meet these requirements?

A : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-restencryption for the S3 bucket. Create a second security configuration. Specify the Amazon S3 path ofthe PEM file for in-transit encryption. Create the EMR cluster, and attach both security configurationsto the cluster.

B : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for local diskencryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Usethe security configuration during EMR cluster creation.

C : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-restencryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Usethe security configuration during EMR cluster creation.

D : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-restencryption 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.

Answer: C

Question 4

A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into thenew cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encryptedboth at rest and in transit.The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. Thedata engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file.Which solution will meet these requirements?

A : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-restencryption for the S3 bucket. Create a second security configuration. Specify the Amazon S3 path ofthe PEM file for in-transit encryption. Create the EMR cluster, and attach both security configurationsto the cluster.

B : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for local diskencryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Usethe security configuration during EMR cluster creation.

C : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-restencryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Usethe security configuration during EMR cluster creation.

D : Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-restencryption 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.

Answer: C

Question 5

A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. TheETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, andload data into Amazon Redshift.The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python toorchestrate the jobs.Which service will meet these requirements?

A : Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

B : AWS Step Functions

C : AWS Glue

D : Amazon EventBridge

Answer: A