DEA-C01 free exam questions

The complete PDF includes every answer and concise explanation.

Question 1

A company uses an Amazon S3 bucket to integrate multiple data sources into a centralized data lake. The company must perform multiple transformations and data-cleaning processes on the data so that the data is accessible to business partners. The company requires a solution that enables multiple business partners to run SQL queries on the centralized data lake during normal business hours. Which solution meets these requirements MOST cost-effectively?

Use a provisioned Amazon EMR cluster after normal business hours to process the previous day's data, apply all necessary transformations, and load the prepared data into Amazon Redshift Serverless.

Use an AWS Glue Flex Job after normal business hours to process the previous day's data, apply all necessary transformations. and load the prepared data into Amazon Redshift Serverless.

Use an AWS Lambda function after normal business hours to process the previous day's data, apply all necessary transformations, and load the prepared data into an Amazon Redshift provisioned cluster.

Use an AWS Glue Flex job after normal business hours to process the previous day's data, apply all necessary transformations, and load the prepared data into an Amazon Redshift provisioned cluster.

Question 2

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?

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.

0 / 6 ANSWERED

PREVIEW POLICY6 questions are shown without answers. The current PDF contains 366 questions with answer notes.