Practice AWS-DEA-C01 Exam Online

Question 1

A Data Engineering Team is tasked with enhancing the CI/CD workflow of their complex ETL pipeline on AWS. The pipeline involves frequent but varying updates—from minor feature additions to major architectural overhauls. The team uses GitHub for version control and manages a diverse array of AWS resources in their projects.

They require a CI/CD solution that not only automates build and test processes upon each commit but also allows for customizable, condition-based deployment strategies (e.g., deploying only specific branches or tags, or based on commit messages).

Given these requirements, which AWS service or combination of services would be the most effective?

A : AWS Lambda and AWS CodePipeline, where a Lambda function is triggered by GitHub webhooks to determine if the deployment should proceed, followed by CodePipeline managing the build, test, and deployment phases.

B : AWS CodeCommit and AWS CodePipeline, with CodeCommit to replace GitHub for enhanced integration within the AWS ecosystem, and CodePipeline to orchestrate the entire process including condition-based deployments.

C : AWS CodePipeline, integrating both GitHub and AWS CodeBuild. CodePipeline to manage the overall workflow and CodeBuild for the build and testing phases, leveraging pipeline actions for deployment conditions.

D : AWS CodeBuild and AWS CodeDeploy, with CodeBuild handling the build and test processes and CodeDeploy managing advanced deployment strategies based on GitHub webhook events.

Answer: C

Question 2

A Data Engineering Team is setting up a new job in AWS Glue ETL. They have configured their data sources and targets, defined the necessary transformations, but when they attempt to run the job, it fails with an authorization error. The team needs to ensure that the AWS Glue job has the necessary permissions to access the required AWS resources for execution.

What should the team do to resolve this issue and successfully run the Glue ETL job?

A : Enable AWS Glue Data Catalog encryption, which automatically grants necessary permissions to the ETL job.

B : Attach an IAM policy directly to the AWS Glue ETL job with the necessary permissions.

C : Create an IAM group with the appropriate permissions and add the AWS Glue service account to this group.

D : Assign an AWS Glue Service Role to the ETL job, ensuring it has the required permissions to access necessary resources.

Answer: D

Question 3

As a Data Engineer, you've been given the task of enhancing the performance of a business analytics application. This application predominantly performs complex, read-intensive queries against large, historical datasets.

The data is currently housed in a MySQL database on Amazon RDS. However, due to the increasing dataset size and query complexity, query performance has significantly degraded. To address this issue, you are considering implementing Amazon ElastiCache.

Which caching strategy would be most effective in this scenario to improve query performance?

A : Use ElastiCache for Memcached implementing an Invalidation strategy, where cache entries are invalidated or updated whenever the database write operations occur.

B : Implement ElastiCache for Redis using a Lazy-Loading strategy, loading data into the cache only when it is requested.

C : Utilize ElastiCache for Memcached with a Write-Through caching strategy, ensuring data is written to both the cache and the database simultaneously.

D : Deploy ElastiCache for Redis with a Write-Around caching strategy, where data is written directly to the database and only the data read from the database is cached.

Answer: B

Question 4

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 5

A data engineer uses Amazon Redshift to run resource-intensive analytics processes once every month. Every

month, the data engineer creates a new Redshift provisioned cluster. The data engineer deletes the Redshift

provisioned cluster after the analytics processes are complete every month. Before the data engineer deletes

the cluster each month, the data engineer unloads backup data from the cluster to an Amazon S3 bucket.

The data engineer needs a solution to run the monthly analytics processes that does not require the data

engineer to manage the infrastructure manually.

Which solution will meet these requirements with the LEAST operational overhead?

A :

Use Amazon Step Functions to pause the Redshift cluster when the analytics processes are complete and to resume the cluster to run new processes every month.

B : Use Amazon Redshift Serverless to automatically process the analytics workload.

C : Use the AWS CLI to automatically process the analytics workload.

D : Use AWS CloudFormation templates to automatically process the analytics workload.

Answer: B

Name:	AWS Certified Data Engineer - Associate
Exam Code:	AWS-DEA-C01
Certification:	AWS Certified Data Engineer
Vendor:	Amazon
Total Questions:	441
Last Updated:	Apr 22, 2024

Amazon AWS-DEA-C01