A company is using Amazon Redshift. A database specialist needs to allow an existing Redshift cluster to access data from other Redshift clusters. Amazon RDS for PostgreSQL databases, and AWS Glue Data Catalog tables. Which combination of steps will meet these requirements with the MOST operational efficiency? (Choose three.)

Topic #: - All AWS Certified Database - Specialty Questions

A. Take a snapshot of the required tables from the other Redshift clusters. Restore the snapshot into the existing Redshift cluster.
B. Create external tables in the existing Redshift database to connect to the AWS Glue Data Catalog tables.
C. Unload the RDS tables and the tables from the other Redshift clusters into Amazon S3. Run COPY commands to load the tables into the existing Redshift cluster.
D. Use federated queries to access data in Amazon RDS.
E. Use data sharing to access data from the other Redshift clusters.
F. Use AWS Glue jobs to transfer the AWS Glue Data Catalog tables into Amazon S3. Create external tables in the existing Redshift database to access this data.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Share this post

Join the Discussion