A database specialist wants to copy an Amazon Redshift cluster from a production AWS account to a non-production AWS account. What is the optimal solution to meet this requirement?

Answer options:

A.Create a target Amazon Redshift cluster. Enable VPC peering between the two VPCs in the two AWS accounts. Use AWS Glue to perform data copy from the source Amazon Redshift cluster to the target Amazon Redshift cluster.
B.Export a CloudFormation template of the source Amazon Redshift cluster. Use the CloudFormation template to stand up a new Amazon Redshift cluster in the target AWS account.
C.Create a manual snapshot of the source Amazon Redshift cluster. Share the snapshot with the target AWS account. In the target AWS account, create a new Amazon Redshift cluster by restoring from the shared snapshot.
D.Use Amazon Redshift Spectrum to copy data from the source Amazon Redshift cluster to the target Amazon Redshift cluster.

Answer: C
Option A is incorrect because this solution requires significant implementation effort. AWS Glue is a cloud-based service. So access to Redshift via VPC would require provisioning of VPC endpoints. Therefore, enabling Glue integration to two different VPC endpoints in inter-region VPC peering requires non-trivial networking configurations. Further, this solution requires the development of an AWS Glue job. Hence, this is not the optimal solution.
Option B is incorrect because there is no simple way to “export” a CloudFormation template. Further, the use of CloudFormation would not perform any data migration.
Option C is CORRECT because sharing a manually created snapshot between AWS accounts and using that snapshot to restore an Amazon Redshift cluster is the simplest solution for copying a cluster between two AWS accounts.
Option D is incorrect because Amazon Redshift Spectrum can be used to query data from files in Amazon S3 without having to load the data into Amazon Redshift tables. It cannot be used for data migration. It is not applicable to the problem in this scenario.
Reference:
https://aws.amazon.com/premiumsupport/knowledge-center/account-transfer-redshift/