Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A photography studio stores its high-resolution image files in an Amazon S3 bucket. Recently, they encountered issues with accidental overwrites of important files. The studio requires a solution to prevent the overwriting and accidental deletion of their images while ensuring that the latest version of a file is readily accessible.

Which single feature should the photography studio enable on their S3 bucket to address this issue effectively?

A : Activate S3 Versioning to maintain multiple versions of each file.

B : Enable S3 Object Lock in compliance mode for strict WORM (Write Once, Read Many) protection.

C : Configure S3 Intelligent-Tiering to manage the storage of the files efficiently.

D : Implement S3 Lifecycle policies to archive older versions of files to S3 Glacier.

Answer: A

Question 2

A sales company uses AWS Glue ETL to collect, process, and ingest data into an Amazon S3 bucket. The AWS Glue pipeline creates a new file in the S3 bucket every hour. File sizes vary from 200 KB to 300 KB. The company wants to build a sales prediction model by using data from the previous 5 years. The historic data includes 44,000 files. The company builds a second AWS Glue ETL pipeline by using the smallest worker type. The second pipeline retrieves the historic files from the S3 bucket and processes the files for downstream analysis. The company notices significant performance issues with the second ETL pipeline. The company needs to improve the performance of the second pipeline. Which solution will meet this requirement MOST cost-effectively?

A : Use a larger worker type.

B : Increase the number of workers in the AWS Glue ETL jobs.

C : Use the AWS Glue DynamicFrame grouping option.

D : Enable AWS Glue auto scaling.

Answer: D

Question 3

A Cloud Data Engineer is designing a serverless data processing pipeline on AWS. The pipeline uses AWS Lambda for data transformation, AWS Step Functions for workflow management, and Amazon DynamoDB for storing intermediate data. The engineer decides to use the AWS Serverless Application Model (AWS SAM) to manage the deployment of these components. The primary requirement is to ensure that the deployment process is repeatable and easily modifiable.

What should the engineer include in the SAM template to meet these requirements efficiently?

A : Include the Lambda functions and DynamoDB tables in the SAM template, but exclude the Step Functions, as they are not supported by AWS SAM.

B : Specify only the Lambda function in the SAM template, manually configuring the Step Functions and DynamoDB tables through the AWS Console.

C : Use separate SAM templates for each component (Lambda, Step Functions, DynamoDB) to manage deployments individually for better control.

D : Define all the components (Lambda functions, Step Functions, DynamoDB tables) in the SAM template, and use AWS CloudFormation to deploy the entire pipeline

Answer: D

Question 4

As a Data Engineer, you are tasked with setting up a batch data ingestion pipeline for a substantial financial dataset. This data is currently housed in an Amazon RDS database, stemming from various financial services and trading platforms. The dataset is complex and heterogeneous, predominantly in JSON format, and is updated nightly, typically ranging between 100-200 GB.

Your primary objective is to efficiently transfer this data from the RDS database to a data lake in AWS, ensuring reliable storage and preparing the dataset for analytical processing with minimal yet capable transformation steps due to its complexity.

Which combination of AWS services would be most appropriate?

A : Amazon AppFlow to facilitate the data transfer from Amazon RDS to Amazon S3. Afterward, utilize AWS Glue ETL for the data transformation processes.

B : Use AWS Database Migration Service (AWS DMS) to continuously replicate data from the Amazon RDS database to Amazon S3. Then, employ AWS Lambda for performing the necessary data transformations.

C : Configure AWS DataSync to transfer the JSON data nightly from the RDS database to Amazon S3. Subsequently, use AWS Glue ETL service to perform the necessary data transformations.

D : Use AWS Database Migration Service (AWS DMS) to continuously replicate data to Amazon S3. Configure an AWS Glue Crawler to update the schema in the Glue Data Catalog, and use Amazon Glue ETL for transformation jobs.

Answer: D

Question 5

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?

A : Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.

B : Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.

C : Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.

D : Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Answer: D