Showcase your ability to design data models, manage data life cycles, and ensure data quality
Category Associate
Exam duration 130 minutes
Exam format 65 questions; either multiple choice or multiple response
Languages offered English, Japanese, Korean, and Simplified Chinese
AWS Certified Data Engineer – Associate validates skills and knowledge in core data-related AWS services, ability to ingest and transform data, orchestrate data pipelines while applying programming concepts, design data models, manage data life cycles, and ensure data quality.
Prepare for the exam
Gain confidence by following AWS Skill Builder’s 4-step exam prep plan. Enroll in the complete plan or choose specific courses tailored to your needs, ensuring you’re ready for exam day.
Get to know the exam with exam-style questions
Follow the 4-step plan.
Review the exam guide
Take the AWS Certification Official Practice Question Set to understand exam-style questions.
Examkingdom Amazon-DEA-C01 Exam pdf,
Best Amazon-DEA-C01 Downloads, Amazon-DEA-C01 Dumps at Certkingdom.com
1. Take the AWS Certification Official Pretest to identify any areas where you need to refresh your AWS knowledge and skills.
2. Refresh your AWS Knowledge and skills
3. Enroll in digital courses where you need to fill gaps in knowledge and skills, practice with AWS Builder Labs, AWS Cloud Quest, and AWS Jam.
Review and practice for your exam
Enroll in an Exam Prep course. The Exam Prep Standard Course is available to anyone with an AWS Skill Builder account. The Exam Prep Enhanced courses include additional labs, exam-style questions, and flashcards.
4 . Assess your exam readiness
Take the AWS Certification Official Practice Exam.
The Amazon DEA-C01 exam, officially known as the AWS Certified Data Analytics – Specialty exam, is designed for individuals who perform complex data analytics roles with experience and expertise working with AWS data analytics services.
Here are the key details:
1. Exam Overview
– Certification Name: AWS Certified Data Analytics – Specialty (DAS-C01)
– Exam Code: DEA-C01 (recently renamed DAS-C01)
– Exam Duration: 180 minutes
– Number of Questions: 65 (multiple choice, multiple response)
– Languages Available: English, Japanese, Korean, and Simplified Chinese
2. Exam Format
– Question Type: Multiple-choice and multiple-response
– Passing Score: The passing score for AWS Specialty exams typically ranges from 70% to 75%, but AWS does not disclose an official passing score.
3. Exam Content Areas
The exam covers five main domains:
– Domain 1: Collection (18%)
– Domain 2: Storage and Data Management (22%)
– Domain 3: Processing (24%)
– Domain 4: Analysis and Visualization (18%)
– Domain 5: Security (18%)
4. Prerequisites
AWS recommends candidates have at least 5 years of experience in a data analytics field and at least 2 years of hands-on experience using AWS analytics services.
5. Key Services to Focus On
– Data Collection: Kinesis, IoT Core, Data Migration Service
– Storage: S3, DynamoDB, Redshift
– Processing: EMR, Glue, Lambda, Kinesis Data Analytics
– Analysis and Visualization: QuickSight, Athena, Redshift
– Security: IAM, Lake Formation, and data encryption on S3 and Redshift
6. Cost and Registration
– Cost: $ (subject to change)
7. Exam Preparation Resources
– AWS Whitepapers and Documentation
– AWS Certified Data Analytics Study Guide
– Practice Exams and Sample Questions
Would you like more detailed resources or study materials for each domain?
Sample Question and Answers
QUESTION 1
A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data
engineer has set up the necessary AWS Glue connection details and an associated IAM role.
However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an
error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint.
The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket.
Which solution will meet this requirement?
A. Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint.
B. Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket.
C. Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name.
D. Verify that the VPC’s route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint.
Answer: D
Explanation:
The error message indicates that the AWS Glue job cannot access the Amazon S3 bucket through the
VPC endpoint. This could be because the VPCs route table does not have the necessary routes to
direct the traffic to the endpoint. To fix this, the data engineer must verify that the route table has an
entry for the Amazon S3 service prefix (com.amazonaws.region.s3) with the target as the VPC
endpoint ID. This will allow the AWS Glue job to use the VPC endpoint to access the S3 bucket
without going through the internet or a NAT gateway. For more information, see Gateway
endpoints. Reference:
Troubleshoot the AWS Glue error oeVPC S3 endpoint validation failed
Amazon VPC endpoints for Amazon S3
[AWS Certified Data Engineer – Associate DEA-C01 Complete Study Guide]
QUESTION 2
A retail company has a customer data hub in an Amazon S3 bucket. Employees from many countries
use the data hub to support company-wide analytics. A governance team must ensure that the
company’s data analysts can access data only for customers who are within the same country as the analysts.
Which solution will meet these requirements with the LEAST operational effort?
A. Create a separate table for each country’s customer data. Provide access to each analyst based on
the country that the analyst serves.
B. Register the S3 bucket as a data lake location in AWS Lake Formation. Use the Lake Formation rowlevel
security features to enforce the company’s access policies.
C. Move the data to AWS Regions that are close to the countries where the customers are. Provide
access to each analyst based on the country that the analyst serves.
D. Load the data into Amazon Redshift. Create a view for each country. Create separate 1AM roles for
each country to provide access to data from each country. Assign the appropriate roles to the analysts.
Answer: B
Explanation:
AWS Lake Formation is a service that allows you to easily set up, secure, and manage data lakes. One
of the features of Lake Formation is row-level security, which enables you to control access to specific
rows or columns of data based on the identity or role of the user. This feature is useful for scenarios
where you need to restrict access to sensitive or regulated data, such as customer data from different
countries. By registering the S3 bucket as a data lake location in Lake Formation, you can use the Lake
Formation console or APIs to define and apply row-level security policies to the data in the bucket.
You can also use Lake Formation blueprints to automate the ingestion and transformation of data
from various sources into the data lake. This solution requires the least operational effort compared
to the other options, as it does not involve creating or moving data, or managing multiple tables,
views, or roles. Reference:
AWS Lake Formation
Row-Level Security
AWS Certified Data Engineer – Associate DEA-C01 Complete Study Guide, Chapter 4: Data Lakes and
Data Warehouses, Section 4.2: AWS Lake Formation
QUESTION 3
A media company wants to improve a system that recommends media content to customer based on
user behavior and preferences. To improve the recommendation system, the company needs to
incorporate insights from third-party datasets into the company’s existing analytics platform.
The company wants to minimize the effort and time required to incorporate third-party datasets.
Which solution will meet these requirements with the LEAST operational overhead?
A. Use API calls to access and integrate third-party datasets from AWS Data Exchange.
B. Use API calls to access and integrate third-party datasets from AWS
C. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories.
D. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR).
Answer: A
Explanation:
AWS Data Exchange is a service that makes it easy to find, subscribe to, and use third-party data in
the cloud. It provides a secure and reliable way to access and integrate data from various sources,
such as data providers, public datasets, or AWS services. Using AWS Data Exchange, you can browse
and subscribe to data products that suit your needs, and then use API calls or the AWS Management
Console to export the data to Amazon S3, where you can use it with your existing analytics platform.
This solution minimizes the effort and time required to incorporate third-party datasets, as you do
not need to set up and manage data pipelines, storage, or access controls. You also benefit from the
data quality and freshness provided by the data providers, who can update their data products as
frequently as needed12.
The other options are not optimal for the following reasons:
B . Use API calls to access and integrate third-party datasets from AWS. This option is vague and does
not specify which AWS service or feature is used to access and integrate third-party datasets. AWS
offers a variety of services and features that can help with data ingestion, processing, and analysis,
but not all of them are suitable for the given scenario. For example, AWS Glue is a serverless data
integration service that can help you discover, prepare, and combine data from various sources, but
it requires you to create and run data extraction, transformation, and loading (ETL) jobs, which can
add operational overhead3.
C . Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS
CodeCommit repositories. This option is not feasible, as AWS CodeCommit is a source control service
that hosts secure Git-based repositories, not a data source that can be accessed by Amazon Kinesis
Data Streams. Amazon Kinesis Data Streams is a service that enables you to capture, process, and
analyze data streams in real time, such as clickstream data, application logs, or IoT telemetry. It does
not support accessing and integrating data from AWS CodeCommit repositories, which are meant for
storing and managing code, not data .
D . Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon
Elastic Container Registry (Amazon ECR). This option is also not feasible, as Amazon ECR is a fully
managed container registry service that stores, manages, and deploys container images, not a data
source that can be accessed by Amazon Kinesis Data Streams. Amazon Kinesis Data Streams does not
support accessing and integrating data from Amazon ECR, which is meant for storing and managing
container images, not data .
Reference:
1: AWS Data Exchange User Guide
2: AWS Data Exchange FAQs
3: AWS Glue Developer Guide
: AWS CodeCommit User Guide
: Amazon Kinesis Data Streams Developer Guide
: Amazon Elastic Container Registry User Guide
: Build a Continuous Delivery Pipeline for Your Container Images with Amazon ECR as Source
QUESTION 4
A financial company wants to implement a data mesh. The data mesh must support centralized data
governance, data analysis, and data access control. The company has decided to use AWS Glue for
data catalogs and extract, transform, and load (ETL) operations.
Which combination of AWS services will implement a data mesh? (Choose two.)
A. Use Amazon Aurora for data storage. Use an Amazon Redshift provisioned cluster for data analysis.
B. Use Amazon S3 for data storage. Use Amazon Athena for data analysis.
C. Use AWS Glue DataBrewfor centralized data governance and access control.
D. Use Amazon RDS for data storage. Use Amazon EMR for data analysis.
E. Use AWS Lake Formation for centralized data governance and access control.
Answer: B E
Explanation:
A data mesh is an architectural framework that organizes data into domains and treats data as
products that are owned and offered for consumption by different teams1. A data mesh requires a
centralized layer for data governance and access control, as well as a distributed layer for data
storage and analysis. AWS Glue can provide data catalogs and ETL operations for the data mesh, but
it cannot provide data governance and access control by itself2. Therefore, the company needs to
use another AWS service for this purpose. AWS Lake Formation is a service that allows you to create,
secure, and manage data lakes on AWS3. It integrates with AWS Glue and other AWS services to
provide centralized data governance and access control for the data mesh. Therefore, option E is correct.
For data storage and analysis, the company can choose from different AWS services depending on
their needs and preferences. However, one of the benefits of a data mesh is that it enables data to be
stored and processed in a decoupled and scalable way1. Therefore, using serverless or managed
services that can handle large volumes and varieties of data is preferable. Amazon S3 is a highly
scalable, durable, and secure object storage service that can store any type of data. Amazon Athena
is a serverless interactive query service that can analyze data in Amazon S3 using standard SQL.
Therefore, option B is a good choice for data storage and analysis in a data mesh. Option A, C, and D
are not optimal because they either use relational databases that are not suitable for storing diverse
and unstructured data, or they require more management and provisioning than serverless services.
Reference:
1: What is a Data Mesh? – Data Mesh Architecture Explained – AWS
2: AWS Glue – Developer Guide
3: AWS Lake Formation – Features
[4]: Design a data mesh architecture using AWS Lake Formation and AWS Glue
[5]: Amazon S3 – Features
[6]: Amazon Athena – Features
QUESTION 5
A data engineer maintains custom Python scripts that perform a data formatting process that many
AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data
engineer must manually update all the Lambda functions.
The data engineer requires a less manual way to update the Lambda functions.
Which solution will meet this requirement?
A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket.
B. Package the custom Python scripts into Lambda layers. Apply the Lambda layers to the Lambda functions.
C. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket.
D. Assign the same alias to each Lambda function. Call reach Lambda function by specifying the function’s alias.
Answer: B
Explanation:
Lambda layers are a way to share code and dependencies across multiple Lambda functions. By
packaging the custom Python scripts into Lambda layers, the data engineer can update the scripts in
one place and have them automatically applied to all the Lambda functions that use the layer. This
reduces the manual effort and ensures consistency across the Lambda functions. The other options
are either not feasible or not efficient. Storing a pointer to the custom Python scripts in the execution
context object or in environment variables would require the Lambda functions to download the
scripts from Amazon S3 every time they are invoked, which would increase latency and cost.
Assigning the same alias to each Lambda function would not help with updating the Python scripts,
as the alias only points to a specific version of the Lambda function code. Reference:
AWS Lambda layers
AWS Certified Data Engineer – Associate DEA-C01 Complete Study Guide, Chapter 3: Data Ingestion
and Transformation, Section 3.4: AWS Lambda
QUESTION 6
A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer
must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and
load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.
Which AWS service or feature will meet these requirements MOST cost-effectively?
A. AWS Step Functions
B. AWS Glue workflows
C. AWS Glue Studio
D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
Answer: B
Explanation:
AWS Glue workflows are a cost-effective way to orchestrate complex ETL jobs that involve multiple
crawlers, jobs, and triggers. AWS Glue workflows allow you to visually monitor the progress and
dependencies of your ETL tasks, and automatically handle errors and retries. AWS Glue workflows
also integrate with other AWS services, such as Amazon S3, Amazon Redshift, and AWS Lambda,
among others, enabling you to leverage these services for your data processing workflows. AWS Glue
workflows are serverless, meaning you only pay for the resources you use, and you dont have to
manage any infrastructure.
AWS Step Functions, AWS Glue Studio, and Amazon MWAA are also possible options for
orchestrating ETL pipelines, but they have some drawbacks compared to AWS Glue workflows. AWS
Step Functions is a serverless function orchestrator that can handle different types of data
processing, such as real-time, batch, and stream processing. However, AWS Step Functions requires
you to write code to define your state machines, which can be complex and error-prone. AWS Step
Functions also charges you for every state transition, which can add up quickly for large-scale ETL pipelines.
AWS Glue Studio is a graphical interface that allows you to create and run AWS Glue ETL jobs without
writing code. AWS Glue Studio simplifies the process of building, debugging, and monitoring your