SOPHOS CERTIFIED ENGINEER EXAM QUESTIONS WITH VERIFIED
ANSWERS ALREADY GRADED A+
Terms in this set (140)
A data engineer is configuring Verify that the VPC's route table includes inbound and
an AWS Glue job to read data outbound routes for the Amazon S3 VPC gateway endpoint.
from an Amazon S3
bucket. The data engineer has Be sure that the subnet configured for your AWS Glue
set up the necessary AWS connection has an Amazon S3 VPC gateway endpoint or a
Glue connection details and route to a NAT gateway in the subnet's route table.
an associated IAM role.
However, AWS Glue is a serverless service, so it does not have any security groups
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 retail company has a Register the S3 bucket as a data lake location in AWS Lake
customer data hub in an Formation. Use the Lake Formation row-level security
Amazon S3 bucket. Employees features to enforce the company's access policies.
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 media company wants to Use API calls to access and integrate third-party datasets from AWS
improve a system that Data Exchange.
recommends media content to
AWS Data Exchange is designed specifically for discovering
customers based on user
and subscribing to third- party data in the cloud, providing
behavior and
preferences. To improve the direct API access to these datasets.
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 financial company wants to 1) Use Amazon S3 for data storage. Use Amazon Athena for data analysis.
implement a data mesh. The 2) Use AWS Lake Formation for centralized data governance and access
control.
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 data engineer maintains custom Package the custom Python scripts into Lambda layers. Apply
Python scripts that perform a the Lambda layers to the Lambda functions.
data formatting
process that many AWS Lambda layers allow you to centrally manage shared code and
Lambda functions use. When dependencies across multiple Lambda functions. By packaging
the data engineer needs to the custom Python scripts into a Lambda layer, you can
modify the Python scripts, the simply update the layer whenever changes are made to the
data scripts,
engineer must manually update and all the Lambda functions that use the layer will automatically
all the Lambda functions. inherit the updates. This approach reduces manual effort and
ensures consistency across the functions.
The data engineer requires a less
manual way to update the
Lambda functions.
Which solution will meet this
requirement?
, A company created an extract, AWS Glue workflows
transform,
and load (ETL) data pipeline in AWS Glue is designed specifically for ETL on AWS and
AWS Glue. A data engineer integrates directly with data sources such as Microsoft SQL
must crawl a table that is in Server through connectors.
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 financial services company stores Use the Amazon Redshift Data API.
financial data in Amazon Redshift.
A data The Amazon Redshift Data API is a lightweight, HTTPS-
engineer wants to run real-time based API that provides an alternative to using JDBC or
queries on the financial data to ODBC drivers for running queries against Amazon
support a web-based trading Redshift. It allows you to execute SQL queries directly from
application. The data engineer within your application without the need for managing
wants to run the queries from connections or drivers. This reduces operational overhead as
within the there's no need to manage and maintain WebSocket or JDBC
trading application.
connections.
Which solution will meet these
requirements with the LEAST
operational overhead?
A company uses Amazon Create an Athena workgroup for each use case. Apply tags to the
Athena for one- time queries workgroup. Create an IAM policy that uses the tags to apply
against data that is in Amazon appropriate permissions to the workgroup.
S3. The company has several use
cases. The company must Athena workgroups allow you to isolate and manage different
implement permission workloads, users, and permissions. By creating a separate
controls to separate query workgroup for each use case, you can control access to query
processes and access to query history, manage permissions, and enforce resource usage
history among users, teams, limits
and applications that are in the independently for each workload. Applying tags to workgroups
ANSWERS ALREADY GRADED A+
Terms in this set (140)
A data engineer is configuring Verify that the VPC's route table includes inbound and
an AWS Glue job to read data outbound routes for the Amazon S3 VPC gateway endpoint.
from an Amazon S3
bucket. The data engineer has Be sure that the subnet configured for your AWS Glue
set up the necessary AWS connection has an Amazon S3 VPC gateway endpoint or a
Glue connection details and route to a NAT gateway in the subnet's route table.
an associated IAM role.
However, AWS Glue is a serverless service, so it does not have any security groups
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 retail company has a Register the S3 bucket as a data lake location in AWS Lake
customer data hub in an Formation. Use the Lake Formation row-level security
Amazon S3 bucket. Employees features to enforce the company's access policies.
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 media company wants to Use API calls to access and integrate third-party datasets from AWS
improve a system that Data Exchange.
recommends media content to
AWS Data Exchange is designed specifically for discovering
customers based on user
and subscribing to third- party data in the cloud, providing
behavior and
preferences. To improve the direct API access to these datasets.
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 financial company wants to 1) Use Amazon S3 for data storage. Use Amazon Athena for data analysis.
implement a data mesh. The 2) Use AWS Lake Formation for centralized data governance and access
control.
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 data engineer maintains custom Package the custom Python scripts into Lambda layers. Apply
Python scripts that perform a the Lambda layers to the Lambda functions.
data formatting
process that many AWS Lambda layers allow you to centrally manage shared code and
Lambda functions use. When dependencies across multiple Lambda functions. By packaging
the data engineer needs to the custom Python scripts into a Lambda layer, you can
modify the Python scripts, the simply update the layer whenever changes are made to the
data scripts,
engineer must manually update and all the Lambda functions that use the layer will automatically
all the Lambda functions. inherit the updates. This approach reduces manual effort and
ensures consistency across the functions.
The data engineer requires a less
manual way to update the
Lambda functions.
Which solution will meet this
requirement?
, A company created an extract, AWS Glue workflows
transform,
and load (ETL) data pipeline in AWS Glue is designed specifically for ETL on AWS and
AWS Glue. A data engineer integrates directly with data sources such as Microsoft SQL
must crawl a table that is in Server through connectors.
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 financial services company stores Use the Amazon Redshift Data API.
financial data in Amazon Redshift.
A data The Amazon Redshift Data API is a lightweight, HTTPS-
engineer wants to run real-time based API that provides an alternative to using JDBC or
queries on the financial data to ODBC drivers for running queries against Amazon
support a web-based trading Redshift. It allows you to execute SQL queries directly from
application. The data engineer within your application without the need for managing
wants to run the queries from connections or drivers. This reduces operational overhead as
within the there's no need to manage and maintain WebSocket or JDBC
trading application.
connections.
Which solution will meet these
requirements with the LEAST
operational overhead?
A company uses Amazon Create an Athena workgroup for each use case. Apply tags to the
Athena for one- time queries workgroup. Create an IAM policy that uses the tags to apply
against data that is in Amazon appropriate permissions to the workgroup.
S3. The company has several use
cases. The company must Athena workgroups allow you to isolate and manage different
implement permission workloads, users, and permissions. By creating a separate
controls to separate query workgroup for each use case, you can control access to query
processes and access to query history, manage permissions, and enforce resource usage
history among users, teams, limits
and applications that are in the independently for each workload. Applying tags to workgroups
