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…

Question

Options

• ATake a snapshot of the required tables from the other Redshift clusters. Restore the snapshot into
• BCreate external tables in the existing Redshift database to connect to the AWS Glue Data Catalog
• CUnload the RDS tables and the tables from the other Redshift clusters into Amazon S3. Run
• DUse federated queries to access data in Amazon RDS.
• EUse data sharing to access data from the other Redshift clusters.
• FUse AWS Glue jobs to transfer the AWS Glue Data Catalog tables into Amazon S3. Create

• A
  10% (4)
• B
  67% (28)
• C
  19% (8)
• F
  5% (2)

Explanation

Option B (external tables) to connect Glue Data catalog tables from Redshift https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html Option D (federated queries) to query Amazon RDS for PostgreSQL databases from Redshift https://docs.aws.amazon.com/redshift/latest/dg/federated-overview.html Option E (data sharing) to access data in other redshift clusters https://docs.aws.amazon.com/redshift/latest/dg/datashare-overview.html

No community discussion yet for this question.