Amazon Exam AWS-Certified-Big-Data-Specialty Topic 4 Question 3 Discussion

Actual exam question for Amazon's AWS-Certified-Big-Data-Specialty exam

Question #: 3
Topic #: 4

[All AWS-Certified-Big-Data-Specialty Questions]

Multiple rows in an Amazon Redshift table were accidentally deleted. A System Administrator is restoring the table from the most recent snapshot. The snapshot contains all rows that were in the table before the deletion.

What is the SIMPLEST solution to restore the table without impacting users?

ARestore the snapshot to a new Amazon Redshift cluster, then UNLOAD the table to Amazon S3. In the original cluster, TRUNCATE the table, then load the data from Amazon S3 by using a COPY command.

BUse the Restore Table from a Snapshot command and specify a new table name DROP the original table, then RENAME the new table to the original table name.

CRestore the snapshot to a new Amazon Redshift cluster. Create a DBLINK between the two clusters in the original cluster, TRUNCATE the destination table, then use an INSERT command to copy the data from the new cluster.

DUse the ALTER TABLE REVERT command and specify a time stamp of immediately before the data deletion. Specify the Amazon Resource Name of the snapshot as the SOURCE and use the OVERWRITE REPLACE option.

Show Suggested Answer

Suggested Answer: B

by Devora at Dec 25, 2022, 12:30 PM

Limited Time Offer

25%

Off

Get Premium AWS-Certified-Big-Data-Specialty Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!