Question 1 · choose 1
A producer Amazon Redshift cluster in account A holds a sales schema. An analytics team in account B uses Redshift Serverless and needs read access to the live sales data without copying it or building a pipeline. What should a data engineer set up?
- AA datashare in account A that is authorized for account B
- BAn UNLOAD of the schema to S3 followed by a COPY in account B
- CA manual snapshot shared with account B and restored there
- DA federated query from account B that points to the producer cluster
Show the answer and why
AA datashare in account A that is authorized for account B
Correct
Data sharing gives live access to data across clusters, workgroups and accounts without copying or moving it; the consumer account associates the datashare.
BAn UNLOAD of the schema to S3 followed by a COPY in account B
Incorrect
This copies the data, and the copy is only as fresh as the last run.
CA manual snapshot shared with account B and restored there
Incorrect
A restored snapshot is a separate copy of the data as of the snapshot time, not live data.
DA federated query from account B that points to the producer cluster
Incorrect
Federated queries reach PostgreSQL and MySQL databases on RDS and Aurora, not another Redshift cluster.
Redshift data sharing separates storage from consumers: the producer shares objects, and consumers in other accounts query them live.
AWS documentation