Amazon Exam DAS-C01 Topic 3 Question 96 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 96
Topic #: 3

A company uses an Amazon Redshift provisioned cluster for data analysis. The data is not encrypted at rest. A data analytics specialist must implement a solution to encrypt the data at rest.

Which solution will meet this requirement with the LEAST operational overhead?

AUse the ALTER TABLE command with the ENCODE option to update existing columns of the Redshift tables to use LZO encoding.

BExport data from the existing Redshift cluster to Amazon S3 by using the UNLOAD command with the ENCRYPTED option. Create a new Redshift cluster with encryption configured. Load data into the new cluster by using the COPY command.

CCreate a manual snapshot of the existing Redshift cluster. Restore the snapshot into a new Redshift cluster with encryption configured.

DModify the existing Redshift cluster to use AWS Key Management Service (AWS KMS) encryption. Wait for the cluster to finish resizing.

Show Suggested Answer

Suggested Answer: D

by Ngoc at Jun 30, 2024, 11:41 PM

Limited Time Offer

25%

Off

Get Premium DAS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Diane

7 months ago

Hmm, I wonder if the company has any spare hamsters to power the new encrypted cluster. That's the only way option B is going to be 'the least operational overhead'.

upvoted 0 times

...

Adelle

7 months ago

Option A? Seriously? Who uses LZO encoding these days? That's like using a rotary phone to make a call.

upvoted 0 times

Josefa

6 months ago

D) Modify the existing Redshift cluster to use AWS Key Management Service (AWS KMS) encryption. Wait for the cluster to finish resizing.

upvoted 0 times

...

Ezekiel

6 months ago

C) Create a manual snapshot of the existing Redshift cluster. Restore the snapshot into a new Redshift cluster with encryption configured.

upvoted 0 times

...

Sophia

6 months ago

B) Export data from the existing Redshift cluster to Amazon S3 by using the UNLOAD command with the ENCRYPTED option. Create a new Redshift cluster with encryption configured. Load data into the new cluster by using the COPY command.

upvoted 0 times

...

Lizette

6 months ago

D) Modify the existing Redshift cluster to use AWS Key Management Service (AWS KMS) encryption. Wait for the cluster to finish resizing.

upvoted 0 times

...

Leandro

6 months ago

C) Create a manual snapshot of the existing Redshift cluster. Restore the snapshot into a new Redshift cluster with encryption configured.

upvoted 0 times

...

Nelida

6 months ago

upvoted 0 times

...

Tawanna

7 months ago

Option C is my pick. Creating a snapshot and restoring it to a new encrypted cluster is a good way to transition without losing any data.

upvoted 0 times

...

Glendora

8 months ago

I'd go with option D. Modifying the existing cluster to use KMS encryption is probably the easiest way to implement encryption without too much hassle.

upvoted 0 times

Lorean

7 months ago

I agree, option D seems like the most efficient way to encrypt the data at rest.

upvoted 0 times

...

Wei

7 months ago

Option D sounds like the best choice. It's a straightforward solution.

upvoted 0 times

...

Alverta

8 months ago

Option B seems like the most straightforward solution. Exporting the data to S3 and then loading it into a new encrypted cluster is a pretty clean approach.

upvoted 0 times

Lillian

7 months ago

Yeah, modifying the existing cluster might be more complex compared to just exporting and importing the data into a new encrypted cluster.

upvoted 0 times

...

Michael

7 months ago

Using AWS KMS encryption on the existing cluster seems like it would involve more steps and potential downtime.

upvoted 0 times

...

Rolande

7 months ago

I agree, it's a simple process and ensures the data is encrypted at rest without too much operational overhead.

upvoted 0 times

...

Nguyet

7 months ago

Option B seems like the most straightforward solution. Exporting the data to S3 and then loading it into a new encrypted cluster is a pretty clean approach.

upvoted 0 times

...