← Back to exam page

Free AWS-CERTIFIED-DATA-ENGINEER-ASSOCIATE-DEA-C01 – Amazon AWS-CERTIFIED-DATA-ENGINEER-ASSOCIATE-DEA-C01 Practice Test Question

Loading demo links...

Showing 7–9 of 32 questions

Question 7 (Topic 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?

Select an option, then click Submit 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.
Question 8 (Topic 1)

A data engineer uses Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to run data pipelines in an AWS account. A workflow recently failed to run. The data engineer needs to use Apache Airflow logs to diagnose the failure of the workflow. Which log type should the data engineer use to diagnose the cause of the failure?

Select an option, then click Submit answer.

  • ○ YourEnvironmentName-WebServer
  • ○ YourEnvironmentName-Scheduler
  • ○ YourEnvironmentName-DAGProcessing
  • ○ YourEnvironmentName-Task
Question 9 (Topic 1)

A retail company uses an Amazon Redshift data warehouse and an Amazon S3 bucket. The company ingests retail order data into the S3 bucket every day. The company stores all order data at a single path within the S3 bucket. The data has more than 100 columns. The company ingests the order data from a third-party application that generates more than 30 files in CSV format every day. Each CSV file is between 50 and 70 MB in size. The company uses Amazon Redshift Spectrum to run queries that select sets of columns. Users aggregate metrics based on daily orders. Recently, users have reported that the performance of the queries has degraded. A data engineer must resolve the performance issues for the queries. Which combination of steps will meet this requirement with LEAST developmental effort? (Choose two.)

Select an option, then click Submit answer.

  • ○ Configure the third-party application to create the files in a columnar format.
  • ○ Develop an AWS Glue ETL job to convert the multiple daily CSV files to one file for each day.
  • ○ Partition the order data in the S3 bucket based on order date.
  • ○ Configure the third-party application to create the files in JSON format.
  • ○ Load the JSON data into the Amazon Redshift table in a SUPER type column.