DEA-C01 sample questions

Question 1

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?

Accepted Answer

Package the custom Python scripts into Lambda layers. Apply the Lambda layers to the Lambda functions.

Answer

Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket.

Answer

Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket.

Answer

Assign the same alias to each Lambda function. Call reach Lambda function by specifying the function's alias.

Question 2

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?

Accepted Answer

AWS Glue workflows

Answer

AWS Step Functions

Answer

AWS Glue Studio

Answer

Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

Question 3

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?

Accepted Answer

Use the Amazon Redshift Data API.

Answer

Establish WebSocket connections to Amazon Redshift.

Answer

Set up Java Database Connectivity (JDBC) connections to Amazon Redshift.

Answer

Store frequently accessed data in Amazon S3. Use Amazon S3 Select to run the queries.

Question 4

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?

Accepted 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.

Answer

Create an S3 bucket for each use case. Create an S3 bucket policy that grants permissions to appropriate individual IAM users. Apply the S3 bucket policy to the S3 bucket.

Answer

Create an IAM role for each use case. Assign appropriate permissions to the role for each use case. Associate the role with Athena.

Answer

Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case. Apply the resource policy to the specific tables that Athena uses.

Question 5

A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time.Which solution will run the Glue jobs in the MOST cost-effective way?

Accepted Answer

Choose the FLEX execution class in the Glue job properties.

Answer

Use the Spot Instance type in Glue job properties.

Answer

Choose the STANDARD execution class in the Glue job properties.

Answer

Choose the latest version in the GlueVersion field in the Glue job properties.

Question 6

A data engineer needs to create an AWS Lambda function that converts the format of data from .csv to Apache Parquet. The Lambda function must run only if a user uploads a .csv file to an Amazon S3 bucket.Which solution will meet these requirements with the LEAST operational overhead?

Accepted Answer

Create an S3 event notification that has an event type of s3:ObjectCreated:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.

Answer

Create an S3 event notification that has an event type of s3:ObjectTagging:* for objects that have a tag set to .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.

Answer

Create an S3 event notification that has an event type of s3:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.

Answer

Create an S3 event notification that has an event type of s3:ObjectCreated:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set an Amazon Simple Notification Service (Amazon SNS) topic as the destination for the event notification. Subscribe the Lambda function to the SNS topic.

Question 7

A media streaming company ingests clickstream data using Amazon Kinesis Data Streams. The data is consumed by a fleet of Amazon EC2 instances running a custom application. During peak hours, the application experiences read throttling, indicated by `ReadProvisionedThroughputExceeded` exceptions. The data engineering team needs to increase the read throughput for this specific consumer application without impacting other consumers or increasing the number of shards. Which feature should they implement?

Accepted Answer

Enable Enhanced Fan-Out (EFO) for the consumer application.

Answer

Increase the number of shards in the Kinesis stream.

Answer

Use the Kinesis Producer Library (KPL) to aggregate records.

Answer

Configure the Kinesis Client Library (KCL) to increase the polling frequency.

Question 8

A data engineer is designing a data lake on Amazon S3. The data ingestion layer receives JSON files from various sources. The engineer wants to optimize the storage for analytics by converting these files to Apache Parquet format. The solution must be serverless, scale automatically, and allow for data transformation logic (like renaming columns) to be applied during the conversion. Which AWS service is BEST suited for this task?

Accepted Answer

AWS Glue ETL Job

Answer

Amazon Kinesis Data Firehose

Answer

Amazon EMR

Answer

Amazon Redshift

DEA-C01 Sample Questions & Answers

Ready for the real thing?

DEA-C01 Sample Questions & Answers

Related practice tests

Ready for the real thing?