AWS Certified Database – Specialty — Question 227

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.)

Answer options

• 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.

Correct answer: B, D, E

Explanation

The correct steps are B, D, and E because they utilize Redshift's capabilities for external tables, federated queries, and data sharing, which are designed for efficient data access across services. Options A and C involve more manual steps and data duplication, while F introduces unnecessary complexity with AWS Glue jobs when direct access methods are available.