ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 301 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 301
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: BDE 🗳️
by rdiaz at March 29, 2023, 6:50 p.m.
Disclaimers:
  • - ExamTopics 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.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sathish_dbs
1 year, 7 months ago
Selected Answer: BDE
BDE are minimal efforts while the rest are copying the data and how about the future data? you can't be copying them all the time
upvoted 4 times
...
chen0305_099
1 year, 8 months ago
Selected Answer: BDE
MAYBE BDE
upvoted 1 times
...
Windy
1 year, 10 months ago
It's BDE
upvoted 1 times
...
backbencher2022
2 years, 2 months ago
Selected Answer: BDE
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
upvoted 4 times
...
rdiaz
2 years, 2 months ago
Maybe BDE
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel