Free Amazon Data-Engineer-Associate Exam Questions

Question 1

A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

A : Use AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.

B : Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.

C : Use AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.

D : Manually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Answer: B

Question 2

A company generates reports from 30 tables in an Amazon Redshift data warehouse. The data source is anoperational Amazon Aurora MySQL database that contains 100 tables. Currently, the company refreshes alldata from Aurora to Redshift every hour, which causes delays in report generation.Which combination of steps will meet these requirements with the LEAST operational overhead? (SelectTWO.)

A : Use AWS Database Migration Service (AWS DMS) to create a replication task. Select only the required tables.

B : Create a database in Amazon Redshift that uses the integration.

C : Create a zero-ETL integration in Amazon Aurora. Select only the required tables.

D : Use query editor v2 in Amazon Redshift to access the data in Aurora.

E : Create an AWS Glue job to transfer each required table. Run an AWS Glue workflow to initiate the jobs every 5 minutes.

Answer: A,C

Question 3

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 4

A healthcare company stores patient records in an on-premises MySQL database. The company creates anapplication to access the MySQL database. The company must enforce security protocols to protect thepatient records. The company currently rotates database credentials every 30 days to minimize the risk ofunauthorized access.The company wants a solution that does not require the company to modify the application code for eachcredential rotation.Which solution will meet this requirement with the least operational overhead?

A : Assign an IAM role access permissions to the database. Configure the application to obtain temporarycredentials through the IAM role.

B : Use AWS Key Management Service (AWS KMS) to generate encryption keys. Configure automatickey rotation. Store the encrypted credentials in an Amazon DynamoDB table.

C : Use AWS Secrets Manager to automatically rotate credentials. Allow the application to retrieve thecredentials by using API calls.

D : Store credentials in an encrypted Amazon S3 bucket. Rotate the credentials every month by using an S3Lifecycle policy. Use bucket policies to control access.

Answer: C

Question 5

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