Which action should be taken prior to performing this upgrade task?

A data engineer is about to perform a major upgrade to the DDL contained within an Amazon Redshift cluster to support a new data warehouse application. The upgrade scripts will include user permission updates, view and table structure changes as well as additional loading and data manipulation tasks.

The data engineer must be able to restore the database to its existing state in the event of issues.

Which action should be taken prior to performing this upgrade task?
A . Run an UNLOAD command for all data in the warehouse and save it to S3.
B . Create a manual snapshot of the Amazon Redshift cluster.
C . Make a copy of the automated snapshot on the Amazon Redshift cluster.
D . Call the waitForSnapshotAvailable command from either the AWS CLI or an AWS SD

Answer: B

Explanation:

Reference: https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-snapshots.html#working-with­snapshot-restore-table-from-snapshot

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments