← Back to exam page

Free AWS-CERTIFIED-DATA-ENGINEER-ASSOCIATE-DEA-C01 – Amazon AWS-CERTIFIED-DATA-ENGINEER-ASSOCIATE-DEA-C01 Practice Test Question

Loading demo links...

Showing 4–6 of 32 questions

Question 4 (Topic 1)

A company stores petabytes of data in thousands of Amazon S3 buckets in the S3 Standard storage class. The data supports analytics workloads that have unpredictable and variable data access patterns. The company does not access some data for months. However, the company must be able to retrieve all data within milliseconds. The company needs to optimize S3 storage costs. Which solution will meet these requirements with the LEAST operational overhead?

Select an option, then click Submit answer.

  • ○ Use S3 Storage Lens standard metrics to determine when to move objects to more cost-optimized storage classes. Create S3 Lifecycle policies for the S3 buckets to move objects to cost-optimized storage classes. Continue to refine the S3 Lifecycle policies in the future to optimize storage costs.
  • ○ Use S3 Storage Lens activity metrics to identify S3 buckets that the company accesses infrequently. Configure S3 Lifecycle rules to move objects from S3 Standard to the S3 Standard-Infrequent Access (S3 Standard-IA) and S3 Glacier storage classes based on the age of the data.
  • ○ Use S3 Intelligent-Tiering. Activate the Deep Archive Access tier.
  • ○ Use S3 Intelligent-Tiering. Use the default access tier.
Question 5 (Topic 1)

A company extracts approximately 1 TB of data every day from data sources such as SAP HANA, Microsoft SQL Server, MongoDB, Apache Kafka, and Amazon DynamoDB. Some of the data sources have undefined data schemas or data schemas that change. A data engineer must implement a solution that can detect the schema for these data sources. The solution must extract, transform, and load the data to an Amazon S3 bucket. The company has a service level agreement (SLA) to load the data into the S3 bucket within 15 minutes of data creation. Which solution will meet these requirements with the LEAST operational overhead?

Select an option, then click Submit answer.

  • ○ Use Amazon EMR to detect the schema and to extract, transform, and load the data into the S3 bucket. Create a pipeline in Apache Spark.
  • ○ Use AWS Glue to detect the schema and to extract, transform, and load the data into the S3 bucket. Create a pipeline in Apache Spark.
  • ○ Create a PySpark program in AWS Lambda to extract, transform, and load the data into the S3 bucket.
  • ○ Create a stored procedure in Amazon Redshift to detect the schema and to extract, transform, and load the data into a Redshift Spectrum table. Access the table from Amazon S3.
Question 6 (Topic 1)

A data engineer finished testing an Amazon Redshift stored procedure that processes and inserts data into a table that is not mission critical. The engineer wants to automatically run the stored procedure on a daily basis. Which solution will meet this requirement in the MOST cost-effective way?

Select an option, then click Submit answer.

  • ○ Create an AWS Lambda function to schedule a cron job to run the stored procedure.
  • ○ Schedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon EC2 Spot Instance.
  • ○ Use query editor v2 to run the stored procedure on a schedule.
  • ○ Schedule an AWS Glue Python shell job to run the stored procedure.