Free Data-Engineer-Associate Exam Questions - Easiest Way for Success

Prepare for the Amazon Data-Engineer-Associate exam questions with our authentic preparation materials, including free Data-Engineer-Associate practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the AWS Certified Data Engineer Associate (DEA-C01) Data-Engineer-Associate exam. This dedication to student success is why we have the most satisfied Data-Engineer-Associate certification exam candidates worldwide.

Page: 1 / 89

Total 441 Questions | Updated On: Sep 13, 2024

Add To Cart

Question 1

A healthcare application hosted on AWS uses Amazon EC2 instances to manage sensitive patient data that must comply with regulatory security standards. The data is stored on EBS volumes attached to the EC2 instances. The company's security policy mandates that all data at rest be encrypted to protect against unauthorized access.

Which action should the IT department take to secure the EBS volumes in accordance with the company's security policy?

A : Use AWS Certificate Manager to apply SSL/TLS certificates to the EBS volumes.

B : Encrypt the EBS volumes with Amazon S3 server-side encryption.

C : Enable EBS encryption with AWS Key Management Service (KMS) keys.

D : Run a third-party encryption tool to encrypt data on the EBS volumes before storage.

Answer: C

Question 2

A financial services company has deployed its application on Amazon EC2 instances within a VPC. For security and compliance reasons, the company needs to ensure that all traffic to their Amazon DynamoDB tables remains within the AWS network and does not traverse the public internet.

Which AWS service or feature should the company use to securely connect its EC2 instances to DynamoDB without using the public internet?

A : Configure a NAT Gateway in the VPC for secure communication with DynamoDB.

B : Establish a VPN connection between the VPC and DynamoDB.

C : Implement AWS PrivateLink to privately connect the VPC to DynamoDB.

D : Use AWS Direct Connect to link the VPC to DynamoDB.

Answer: C

Question 3

A Cloud Data Engineering Team at a data analytics firm is tasked with enhancing their data schema management. The team is dealing with an extensive collection of datasets stored in Amazon S3, with data arriving in varying formats. The requirement is to automate the adaptation of data schemas to reduce the need for manual updates, thereby streamlining analysts' access to the latest data for their complex queries.

Which steps should the team implement to establish a dynamic and automated schema management system that seamlessly accommodates schema evolution? (Select TWO)

A : Schedule AWS Glue crawlers to automatically detect and incorporate schema modifications into the AWS Glue Data Catalog, accommodating the diverse data formats found in S3 buckets.

B : Develop a bespoke schema tracking application that mandates manual recording and validation of schema changes by data anaysts, aiming for rigorous oversight.

C : Implement AWS Glue Schema Registry within their ETL pipelines to manage schema versioning automatically as data is ingested and transformed, maintaining a record of schema changes.

D : Deploy AWS Glue crawlers for schema detection and an AWS Lambda function for external schema change tracking, using a third-party system instead of AWS-native schema management tools.

E : Manually update te AWS Glue Data Catalog in response to schema change alerts from data ingestion pipelines, ensuring controlled, deliberate schema evolution.

Answer: A,C

Question 4

Which AWS service or feature should the company use to securely connect its EC2 instances to DynamoDB without using the public internet?

A : Configure a NAT Gateway in the VPC for secure communication with DynamoDB.

B : Establish a VPN connection between the VPC and DynamoDB.

C : Implement AWS PrivateLink to privately connect the VPC to DynamoDB.

D : Use AWS Direct Connect to link the VPC to DynamoDB.

Answer: C

Question 5

A Data Engineering Consultant has been approached by a fintech company, AlphaFinance, which offers investment portfolio tracking for their customers. They want to create a daily report that shows the average value of all portfolios for the last 30 days, grouped by investment type (e.g., stocks, bonds, real estate). The data for each customer's portfolio is stored in an Amazon Redshift cluster, updated daily.

Which approach should the consultant recommend to efficiently derive this report?

A : Use Redshift's window function, specifically AVG() with ROWS BETWEEN, to calculate the rolling average of the portfolio values over the last 30 days, and then group the results by investment type.

B : Create a batch process that runs every day, iterating over each day in the past 30 days, fetching portfolio values, and then manually averaging them out for each investment type.

C : Extract the data from Amazon Redshift into Amazon S3, use AWS Glue to pivot the data on investment types, and then calculate the 30-day average for each type.

D : Utilize Amazon QuickSight's pivot table features to directly visualize and group the data by investment type, and then compute the 30-day rolling average.

Answer: A

Page: 1 / 89

Total 441 Questions | Updated On: Sep 13, 2024

Add To Cart