Exam Data-Engineer-Associate Topic 1 Question 75 Discussion

Actual exam question for Amazon's Data-Engineer-Associate exam
Question #: 75
Topic #: 1
A company has an Amazon Redshift data warehouse that users access by using a variety of IAM roles. More than 100 users access the data warehouse every day.
The company wants to control user access to the objects based on each user's job role, permissions, and how sensitive the data is.
Which solution will meet these requirements?

Suggested Answer: A Vote an answer

Amazon Redshift supports Role-Based Access Control (RBAC) to manage access to database objects.
RBAC allows administrators to create roles for job functions and assign privileges at the schema, table, or column level based on data sensitivity and user roles.
"RBAC in Amazon Redshift helps manage permissions more efficiently at scale by assigning users to roles that reflect their job function. It simplifies user management and secures access based on job role and data sensitivity."
- Ace the AWS Certified Data Engineer - Associate Certification - version 2 - apple.pdf RBAC is preferred over RLS or CLS alone because it offers a more comprehensive and scalable solution across multiple users and permissions.

by Helen at Dec 22, 2025, 05:45 AM

Limited Time Offer

15%

Off

Get Premium Data-Engineer-Associate Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10