AWS CERTIFIED DATA ENGINEER – ASSOCIATE EXAM 2024/2025 WITH 100%
ACCURATE SOLUTIONS
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? - Precise Answer ✔✔Verify
that the VPC's route table includes inbound and outbound routes for the
Amazon S3 VPC gateway endpoint.
Be sure that the subnet configured for your AWS Glue connection has
an Amazon S3 VPC gateway endpoint or a route to a NAT gateway in
the subnet's route table.
AWS Glue is a serverless service, so it does not have any security
groups
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? - Precise Answer ✔✔Register the S3 bucket as a data
lake location in AWS Lake Formation. Use the Lake Formation row-
level security features to enforce the company's access policies.
A media company wants to improve a system that recommends media
content to customers 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? - Precise Answer ✔✔Use API calls to access and
integrate third-party datasets from AWS Data Exchange.
AWS Data Exchange is designed specifically for discovering and
subscribing to third-party data in the cloud, providing direct API access
to these datasets.
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.) - Precise Answer ✔✔1) Use Amazon S3 for data storage.
Use Amazon Athena for data analysis.
,2) Use AWS Lake Formation for centralized data governance and access
control.
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? - Precise Answer
✔✔Package the custom Python scripts into Lambda layers. Apply the
Lambda layers to the Lambda functions.
Lambda layers allow you to centrally manage shared code and
dependencies across multiple Lambda functions. By packaging the
custom Python scripts into a Lambda layer, you can simply update the
layer whenever changes are made to the scripts, and all the Lambda
functions that use the layer will automatically inherit the updates. This
approach reduces manual effort and ensures consistency across the
functions.
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? - Precise Answer ✔✔AWS Glue workflows
, AWS Glue is designed specifically for ETL on AWS and integrates
directly with data sources such as Microsoft SQL Server through
connectors.
A financial services company stores financial data in Amazon Redshift.
A data engineer wants to run real-time queries on the financial data to
support a web-based trading application. The data engineer wants to run
the queries from within the trading application.
Which solution will meet these requirements with the LEAST
operational overhead? - Precise Answer ✔✔Use the Amazon Redshift
Data API.
The Amazon Redshift Data API is a lightweight, HTTPS-based API that
provides an alternative to using JDBC or ODBC drivers for running
queries against Amazon Redshift. It allows you to execute SQL queries
directly from within your application without the need for managing
connections or drivers. This reduces operational overhead as there's no
need to manage and maintain WebSocket or JDBC connections.
A company uses Amazon Athena for one-time queries against data that
is in Amazon S3. The company has several use cases. The company
must implement permission controls to separate query processes and
access to query history among users, teams, and applications that are in
the same AWS account.
Which solution will meet these requirements? - Precise Answer
✔✔Create an Athena workgroup for each use case. Apply tags to the
workgroup. Create an IAM policy that uses the tags to apply appropriate
permissions to the workgroup.
ACCURATE SOLUTIONS
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? - Precise Answer ✔✔Verify
that the VPC's route table includes inbound and outbound routes for the
Amazon S3 VPC gateway endpoint.
Be sure that the subnet configured for your AWS Glue connection has
an Amazon S3 VPC gateway endpoint or a route to a NAT gateway in
the subnet's route table.
AWS Glue is a serverless service, so it does not have any security
groups
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? - Precise Answer ✔✔Register the S3 bucket as a data
lake location in AWS Lake Formation. Use the Lake Formation row-
level security features to enforce the company's access policies.
A media company wants to improve a system that recommends media
content to customers 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? - Precise Answer ✔✔Use API calls to access and
integrate third-party datasets from AWS Data Exchange.
AWS Data Exchange is designed specifically for discovering and
subscribing to third-party data in the cloud, providing direct API access
to these datasets.
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.) - Precise Answer ✔✔1) Use Amazon S3 for data storage.
Use Amazon Athena for data analysis.
,2) Use AWS Lake Formation for centralized data governance and access
control.
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? - Precise Answer
✔✔Package the custom Python scripts into Lambda layers. Apply the
Lambda layers to the Lambda functions.
Lambda layers allow you to centrally manage shared code and
dependencies across multiple Lambda functions. By packaging the
custom Python scripts into a Lambda layer, you can simply update the
layer whenever changes are made to the scripts, and all the Lambda
functions that use the layer will automatically inherit the updates. This
approach reduces manual effort and ensures consistency across the
functions.
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? - Precise Answer ✔✔AWS Glue workflows
, AWS Glue is designed specifically for ETL on AWS and integrates
directly with data sources such as Microsoft SQL Server through
connectors.
A financial services company stores financial data in Amazon Redshift.
A data engineer wants to run real-time queries on the financial data to
support a web-based trading application. The data engineer wants to run
the queries from within the trading application.
Which solution will meet these requirements with the LEAST
operational overhead? - Precise Answer ✔✔Use the Amazon Redshift
Data API.
The Amazon Redshift Data API is a lightweight, HTTPS-based API that
provides an alternative to using JDBC or ODBC drivers for running
queries against Amazon Redshift. It allows you to execute SQL queries
directly from within your application without the need for managing
connections or drivers. This reduces operational overhead as there's no
need to manage and maintain WebSocket or JDBC connections.
A company uses Amazon Athena for one-time queries against data that
is in Amazon S3. The company has several use cases. The company
must implement permission controls to separate query processes and
access to query history among users, teams, and applications that are in
the same AWS account.
Which solution will meet these requirements? - Precise Answer
✔✔Create an Athena workgroup for each use case. Apply tags to the
workgroup. Create an IAM policy that uses the tags to apply appropriate
permissions to the workgroup.
