QUESTION: 29

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.
Which Step Functions state should the data engineer use to meet these requirements?

Parallel state
Choice state
Map state
Wait state

Answer(s): C

Reveal Solution Next Question

QUESTION: 30

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.
The data engineer must identify and remove duplicate information from the legacy application data.
Which solution will meet these requirements with the LEAST operational overhead?

Write a custom extract, transform, and load (ETL) job in Python. Use the DataFrame.drop_duplicates() function by importing the Pandas library to perform data deduplication.
Write an AWS Glue extract, transform, and load (ETL) job. Use the FindMatches machine learning (ML) transform to transform the data to perform data deduplication.
Write a custom extract, transform, and load (ETL) job in Python. Import the Python dedupe library. Use the dedupe library to perform data deduplication.
Write an AWS Glue extract, transform, and load (ETL) job. Import the Python dedupe library. Use the dedupe library to perform data deduplication.

Answer(s): B

Reveal Solution Next Question

QUESTION: 31

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.
Which actions will provide the FASTEST queries? (Choose two.)

Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB.
Use a columnar storage file format.
Partition the data based on the most common query predicates.
Split the data into files that are less than 10 KB.
Use file formats that are not splittable.

Answer(s): B,C

Reveal Solution Next Question

QUESTION: 32

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.
The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.
Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

Turn on the public access setting for the DB instance.
Update the security group of the DB instance to allow only Lambda function invocations on the database port.
Configure the Lambda function to run in the same subnet that the DB instance uses.
Attach the same security group to the Lambda function and the DB instance. Include a self-referencing rule that allows access through the database port.
Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port.

Answer(s): C,D

Reveal Solution Next Question

Free SnowPro Advanced Data Engineer Exam Braindumps (page: 8)

QUESTION: 29

QUESTION: 30

QUESTION: 31

QUESTION: 32