AWS Certified Data Engineer Associate · Free Practice Question Medium
Question 56
A Redshift cluster administrator is tasked with sharing live data from a production Redshift cluster to another Redshift cluster in a different AWS account. The data should remain in the original cluster and the consuming account should bear the compute cost of querying the data. Which Redshift feature would best meet these requirements?
-
A
Redshift Data Sharing
-
B
Redshift Data API
-
C
Redshift Replication
-
D
Redshift Spectrum
Reveal correct answer
Correct answer: A
A.
Redshift Data Sharing allows sharing live data from one Redshift cluster to another across AWS accounts without copying the data. The consumer cluster uses its own compute resources to query the shared data.
B.
The Redshift Data API is for executing queries on Redshift but does not facilitate cross-cluster data sharing.
C.
Redshift Replication involves copying data, which contradicts the requirement to share live data without duplication.
D.
Redshift Spectrum is used to query data stored in S3, not for sharing data between Redshift clusters.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
