Free Amazon Data-Engineer-Associate Exam Questions

Question 1

A telecommunications company collects network usage data throughout each day at a rate of several thousanddata points each second. The company runs an application to process the usage data in real time. Thecompany aggregates and stores the data in an Amazon Aurora DB instance.Sudden drops in network usage usually indicate a network outage. The company must be able to identifysudden drops in network usage so the company can take immediate remedial actions.Which solution will meet this requirement with the LEAST latency?

A : Create an AWS Lambda function to query Aurora for drops in network usage. Use Amazon EventBridge to automatically invoke the Lambda function every minute.

B : Modify the processing application to publish the data to an Amazon Kinesis data stream. Create an Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) application to detect drops in network usage.

C : Replace the Aurora database with an Amazon DynamoDB table. Create an AWS Lambda function to query the DynamoDB table for drops in network usage every minute. Use DynamoDB Accelerator (DAX) between the processing application and DynamoDB table.

D : Create an AWS Lambda function within the Database Activity Streams feature of Aurora to detect drops in network usage.

Answer: B

Question 2

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 3

A financial services company is using Amazon RDS for PostgreSQL to manage sensitive customer data. The database is accessed by various applications deployed in an AWS environment. The company's security policy mandates that the data must be encrypted at rest. The database administrator needs to enable encryption for the existing unencrypted database with minimal downtime.

Which of the following approaches should the administrator take?

A : Enable encryption on the existing RDS instance directly via the AWS Management Console.

B : Take a snapshot of the existing RDS instance, copy the snapshot with encryption enabled, and then restore the database from the encrypted snapshot.

C : Create a new RDS instance with encryption enabled and migrate the data from the existing unencrypted database using AWS Database Migration Service (DMS).

D : Use AWS Key Management Service (KMS) to encrypt the existing database file at the storage level.

Answer: B

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 Cloud Data Engineering Consultant is tasked with setting up a secure data lake for a financial institution using AWS Lake Formation. The institution requires strict management of permissions to ensure that analysts have access only to the specific data necessary for their analysis tasks and are restricted from accessing sensitive customer financial records. The consultant must configure Lake Formation in such a way that permissions are granularly managed while facilitating the ease of access for authorized users.

Which of the following actions should the consultant take to correctly manage permissions through Lake Formation for the given requirements? (Select TWO)

A : Grant column-level permissions to the analysts' IAM roles for non-sensitive data tables within Lake Formation, ensuring precise access to data necessary for their tasks.

B : Apply tag-based access control in Lake Formation, tagging sensitive data and assigning corresponding permission tags to analysts' IAM roles for fine-grained access.

C : Set up database-level permissions for all analysts, granting SELECT privileges to ensure that analysts have broad access for exploratory analysis within the Lake Formation.

D : Implement row-level security by creating Lake Formation access control lists that map to analysts' roles, permitting them to query only the rows pertinent to their analysis.

E : Configure Lake Formation to use named resource links for sensitive tables, providing analysts with indirect access to data through a resource link that obscures the underlying data source.

Answer: A,B