DEA-C01 · Question #238
DEA-C01 Question #238: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #238. The question stem and answer options stay visible for context.
Question
A company uses an Amazon Redshift cluster as a data warehouse that is shared across two departments. To comply with a security policy, each department must have unique access permissions. Department A must have access to tables and views for Department A. Department B must have access to tables and views for Department B. The company often runs SQL queries that use objects from both departments in one query. Which solution will meet these requirements with the LEAST operational overhead?
Options
- AGroup tables and views for each department into dedicated schemas. Manage permissions at the
- BGroup tables and views for each department into dedicated databases. Manage permissions at
- CUpdate the names of the tables and views to follow a naming convention that contains the
- DCreate an IAM user group for each department. Use identity-based IAM policies to grant table
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-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.