Answer-first summary for fast verification
Answer: Create an Amazon Redshift data share that includes the tables that need to be shared., Share the Amazon Redshift data share to the Lake Formation catalog in the governance account.
Option B is CORRECT because creating an Amazon Redshift data share allows the data engineer to share datasets across accounts without copying or moving the data. Redshift data sharing is natively integrated with Redshift Serverless and supports sharing tables, schemas, and views while maintaining fine-grained access controls. Option D is also correct as Lake Formation provides the required column-level filtering for different teams sharing the same cataloged data.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 52/60
A company implements a data mesh that has a central governance account. The company needs to catalog all data in the governance account. The governance account uses AWS Lake Formation to centrally share data and grant access permissions.
The company has created a new data product that includes a group of Amazon Redshift Serverless tables. A data engineer needs to share the data product with a marketing team. The marketing team must have access to only a subset of columns. The data engineer needs to share the same data product with a compliance team. The compliance team must have access to a different subset of columns than the marketing team needs access to.
Which combination of steps should the data engineer take to meet these requirements? (Choose two.)
A
Create views of the tables that need to be shared. Include only the required columns.
B
Create an Amazon Redshift data share that includes the tables that need to be shared.
C
Create an Amazon Redshift managed VPC endpoint in the marketing team's account. Grant the marketing team access to the views.
D
Share the Amazon Redshift data share to the Lake Formation catalog in the governance account.
E
Share the Amazon Redshift data share to the Amazon Redshift Serverless workgroup in the marketing team's account.
No comments yet.