DAS-C01 · Question #170
DAS-C01 Question #170: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #170. The question stem and answer options stay visible for context.
Question
A company is providing analytics services to its sales and marketing departments. The departments can access the data only through their business intelligence (BI) tools, which run queries on Amazon Redshift using an Amazon Redshift internal user to connect. Each department is assigned a user in the Amazon Redshift database with the permissions needed for that department. The marketing data analysts must be granted direct access to the advertising table, which is stored in Apache Parquet format in the marketing S3 bucket of the company data lake. The company data lake is managed by AWS Lake Formation. Finally, access must be limited to the three promotion columns in the table. Which combination of steps will meet these requirements? (Choose three.)
Options
- AGrant permissions in Amazon Redshift to allow the marketing Amazon Redshift user to access the three
- BCreate an Amazon Redshift Spectrum IAM role with permissions for Lake Formation. Attach it to the
- CCreate an Amazon Redshift Spectrum IAM role with permissions for the marketing S3 bucket. Attach it
- DCreate an external schema in Amazon Redshift by using the Amazon Redshift Spectrum IAM role.
- EGrant permissions in Lake Formation to allow the Amazon Redshift Spectrum role to access the three
- FGrant permissions in Lake Formation to allow the marketing IAM group to access the three promotion
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.