AWS Certified Data Engineer - Associate DEA-C01 practice test

1. Question 1 · 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?

   Choose one answer.

   • Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint.
   • Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket.
   • Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name.
   • Verify that the VPC's route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint.

2. Question 2 · 1

   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?

   Choose one 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.
   • 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.
   • 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.
   • 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.

3. Question 3 · 1

   An insurance company stores transaction data that the company compressed with gzip. The company needs to query the transaction data for occasional audits. Which solution will meet this requirement in the MOST cost-effective way?

   Choose one answer.

   • Store the data in Amazon Glacier Flexible Retrieval. Use Amazon S3 Glacier Select to query the data.
   • Store the data in Amazon S3. Use Amazon S3 Select to query the data.
   • Store the data in Amazon S3. Use Amazon Athena to query the data.
   • Store the data in Amazon Glacier Instant Retrieval. Use Amazon Athena to query the data.

4. Question 4 · 1

   A data engineer finished testing an Amazon Redshift stored procedure that processes and inserts data into a table that is not mission critical. The engineer wants to automatically run the stored procedure on a daily basis. Which solution will meet this requirement in the MOST cost-effective way?

   Choose one answer.

   • Create an AWS Lambda function to schedule a cron job to run the stored procedure.
   • Schedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon EC2 Spot Instance.
   • Use query editor v2 to run the stored procedure on a schedule.
   • Schedule an AWS Glue Python shell job to run the stored procedure.

5. Question 5 · 1

   A marketing company collects clickstream data. The company sends the clickstream data to Amazon Kinesis Data Firehose and stores the clickstream data in Amazon S3. The company wants to build a series of dashboards that hundreds of users from multiple departments will use. The company will use Amazon QuickSight to develop the dashboards. The company wants a solution that can scale and provide daily updates about clickstream activity. Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)

   Choose all answers that apply.

   • Use Amazon Redshift to store and query the clickstream data.
   • Use Amazon Athena to query the clickstream data
   • Use Amazon S3 analytics to query the clickstream data.
   • Access the query data through a QuickSight direct SQL query.
   • Access the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation Engine). Configure a daily refresh for the dataset.

6. Question 6 · 1

   A data engineer is building a data orchestration workflow. The data engineer plans to use a hybrid model that includes some on-premises resources and some resources that are in the cloud. The data engineer wants to prioritize portability and open source resources. Which service should the data engineer use in both the on-premises environment and the cloud-based environment?

   Choose one answer.

   • AWS Data Exchange
   • Amazon Simple Workflow Service (Amazon SWF)
   • Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
   • AWS Glue

7. Question 7 · 1

   A gaming company uses a NoSQL database to store customer information. The company is planning to migrate to AWS. The company needs a fully managed AWS solution that will handle high online transaction processing (OLTP) workload, provide single-digit millisecond performance, and provide high availability around the world. Which solution will meet these requirements with the LEAST operational overhead?

   Choose one answer.

   • Amazon Keyspaces (for Apache Cassandra)
   • Amazon DocumentDB (with MongoDB compatibility)
   • Amazon DynamoDB
   • Amazon Timestream

8. Question 8 · 1

   A data engineer creates an AWS Lambda function that an Amazon EventBridge event will invoke. When the data engineer tries to invoke the Lambda function by using an EventBridge event, an AccessDeniedException message appears. How should the data engineer resolve the exception?

   Choose one answer.

   • Ensure that the trust policy of the Lambda function execution role allows EventBridge to assume the execution role.
   • Ensure that both the IAM role that EventBridge uses and the Lambda function's resource-based policy have the necessary permissions.
   • Ensure that the subnet where the Lambda function is deployed is configured to be a private subnet.
   • Ensure that EventBridge schemas are valid and that the event mapping configuration is correct.

9. Question 9 · 1

   A company uses a data lake that is based on an Amazon S3 bucket. To comply with regulations, the company must apply two layers of server-side encryption to files that are uploaded to the S3 bucket. The company wants to use an AWS Lambda function to apply the necessary encryption. Which solution will meet these requirements?

   Choose one answer.

   • Use both server-side encryption with AWS KMS keys (SSE-KMS) and the Amazon S3 Encryption Client.
   • Use dual-layer server-side encryption with AWS KMS keys (DSSE-KMS).
   • Use server-side encryption with customer-provided keys (SSE-C) before files are uploaded.
   • Use server-side encryption with AWS KMS keys (SSE-KMS).

10. Question 10 · 1

    A data engineer notices that Amazon Athena queries are held in a queue before the queries run. How can the data engineer prevent the queries from queueing?

    Choose one answer.

    • Increase the query result limit.
    • Configure provisioned capacity for an existing workgroup.
    • Use federated queries.
    • Allow users who run the Athena queries to an existing workgroup.

11. Question 11 · 1

    A data engineer needs to debug an AWS Glue job that reads from Amazon S3 and writes to Amazon Redshift. The data engineer enabled the bookmark feature for the AWS Glue job. The data engineer has set the maximum concurrency for the AWS Glue job to 1. The AWS Glue job is successfully writing the output to Amazon Redshift. However, the Amazon S3 files that were loaded during previous runs of the AWS Glue job are being reprocessed by subsequent runs. What is the likely reason the AWS Glue job is reprocessing the files?

    Choose one answer.

    • The AWS Glue job does not have the s3:GetObjectAcl permission that is required for bookmarks to work correctly.
    • The maximum concurrency for the AWS Glue job is set to 1.
    • The data engineer incorrectly specified an older version of AWS Glue for the Glue job.
    • The AWS Glue job does not have a required commit statement.

12. Question 12 · 1

    An ecommerce company wants to use AWS to migrate data pipelines from an on-premises environment into the AWS Cloud. The company currently uses a third-party tool in the on-premises environment to orchestrate data ingestion processes. The company wants a migration solution that does not require the company to manage servers. The solution must be able to orchestrate Python and Bash scripts. The solution must not require the company to refactor any code. Which solution will meet these requirements with the LEAST operational overhead?

    Choose one answer.

    • AWS Lambda
    • Amazon Managed Workflows for Apache Airflow (Amazon MVVAA)
    • AWS Step Functions
    • AWS Glue

13. Question 13 · 1

    A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column. Which solution will MOST speed up the Athena query performance?

    Choose one answer.

    • Change the data format from .csv to JSON format. Apply Snappy compression.
    • Compress the .csv files by using Snappy compression.
    • Change the data format from .csv to Apache Parquet. Apply Snappy compression.
    • Compress the .csv files by using gzip compression.

14. Question 14 · 1

    A retail company stores data from a product lifecycle management (PLM) application in an on-premises MySQL database. The PLM application frequently updates the database when transactions occur. The company wants to gather insights from the PLM application in near real time. The company wants to integrate the insights with other business datasets and to analyze the combined dataset by using an Amazon Redshift data warehouse. The company has already established an AWS Direct Connect connection between the on-premises infrastructure and AWS. Which solution will meet these requirements with the LEAST development effort?

    Choose one answer.

    • Run a scheduled AWS Glue extract, transform, and load (ETL) job to get the MySQL database updates by using a Java Database Connectivity (JDBC) connection. Set Amazon Redshift as the destination for the ETL job.
    • Run a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously replicate the MySQL database changes. Set Amazon Redshift as the destination for the task.
    • Use the Amazon AppFlow SDK to build a custom connector for the MySQL database to continuously replicate the database changes. Set Amazon Redshift as the destination for the connector.
    • Run scheduled AWS DataSync tasks to synchronize data from the MySQL database. Set Amazon Redshift as the destination for the tasks.

15. Question 15 · 1

    A marketing company uses Amazon S3 to store clickstream data. The company queries the data at the end of each day by using a SQL JOIN clause on S3 objects that are stored in separate buckets. The company creates key performance indicators (KPIs) based on the objects. The company needs a serverless solution that will give users the ability to query data by partitioning the data. The solution must maintain the atomicity, consistency, isolation, and durability (ACID) properties of the data. Which solution will meet these requirements MOST cost-effectively?

    Choose one answer.

    • Amazon S3 Select
    • Amazon Redshift Spectrum
    • Amazon Athena
    • Amazon EMR

Paid access to all 226 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.