AWS Certified Data Engineer – Associate (DEA-C01) — Question 247

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?

Answer options

• A. GRANT USAGE ON DATASHARE salesshare TO ACCOUNTS ‘’ AND ‘’;
• B. GRANT USAGE ON DATASHARE salesshare TO NAMESPACES ‘’ AND ‘’;
• C. GRANT USAGE ON DATASHARE salesshare TO ACCOUNT ‘’; GRANT USAGE ON DATASHARE salesshare TO ACCOUNT ‘’;
• D. GRANT USAGE ON DATASHARE salesshare TO NAMESPACE ‘’; GRANT USAGE ON DATASHARE salesshare TO NAMESPACE ‘’;

Correct answer: D

Explanation

The correct answer is D because granting usage on the datashare to namespaces allows access for both teams in their respective AWS accounts. Options A and B incorrectly use 'ACCOUNTS' and 'NAMESPACES' in a way that does not allow for multiple teams' access. Option C also fails as it grants access only to individual accounts rather than using the more appropriate namespace approach.