AWS Certified Big Data - Specialty (#79)

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?

Restore 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.
Use 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.
Restore 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.
Use 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.