Free Amazon Data-Engineer-Associate Exam Questions

Question 1

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 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 company stores its processed data in an S3 bucket. The company has a strict data access policy. Thecompany uses IAM roles to grant teams within the company different levels of access to the S3 bucket.The company wants to receive notifications when a user violates the data access policy. Each notificationmust include the username of the user who violated the policy.Which solution will meet these requirements?

A : Use AWS Config rules to detect violations of the data access policy. Set up compliance alarms.

B : Use Amazon CloudWatch metrics to gather object-level metrics. Set up CloudWatch alarms.

C : Use AWS CloudTrail to track object-level events for the S3 bucket. Forward events to Amazon CloudWatch to set up CloudWatch alarms.

D : Use Amazon S3 server access logs to monitor access to the bucket. Forward the access logs to an Amazon CloudWatch log group. Use metric filters on the log group to set up CloudWatch alarms.

Answer: C

Question 4

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 5

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