DEA-C01 · Question #304
Two data engineering teams use separate AWS accounts. Both teams request access to the same datashare in an Amazon Redshift cluster that is in a third AWS account. The datashare is named salesshare…
The correct answer is D. GRANT USAGE ON DATASHARE salesshare TO NAMESPACE '<account ID 1>'. In Amazon Redshift data sharing, cross-account permissions for a datashare are granted to consumer cluster/serverless namespaces. Granting USAGE on the datashare to each consumer namespace enables both teams’ Redshift environments in their respective accounts to create and…
Question
Two data engineering teams use separate AWS accounts. Both teams request access to the same datashare in an Amazon Redshift cluster that is in a third AWS account. The datashare is named salesshare. A data engineer must use the Amazon Redshift SQL interface to grant both data engineering teams' access to the datashare. Which command or commands will meet this requirement?
Options
- AGRANT USAGE ON DATASHARE salesshare TO ACCOUNTS '<account ID 1>' AND '<account
- BGRANT USAGE ON DATASHARE salesshare TO NAMESPACES '<account ID 1>' AND
- CGRANT USAGE ON DATASHARE salesshare TO ACCOUNT '<account ID 1>';
- DGRANT USAGE ON DATASHARE salesshare TO NAMESPACE '<account ID 1>';
How the community answered
(34 responses)- A3% (1)
- C3% (1)
- D94% (32)
Explanation
In Amazon Redshift data sharing, cross-account permissions for a datashare are granted to consumer cluster/serverless namespaces. Granting USAGE on the datashare to each consumer namespace enables both teams’ Redshift environments in their respective accounts to create and query databases from the shared data.
Topics
Community Discussion
No community discussion yet for this question.