Free COMPTIA Datasys+ DS0-001 Actual Exam Questions - Question 15 Discussion
users in order to facilitate ongoing reporting. However, some columns in each table are restricted,
and users should not be able to see the values in these columns.
Which of the following is the best action for the administrator to take?
A, since stored procedures can control exactly what data users access.
It’s B since views can restrict columns without changing table permissions.
B, plus views are easier to manage and update than stored procedures here.
Totally agree that views are useful here, but I’d say option B is best since it lets you filter columns easily while keeping the structure simple. Stored procedures or triggers feel like overkill for this case.
Option B is the way to go because views let you control exactly which columns are visible. Creating a stored procedure or trigger won’t give that straightforward column-level access control.
I think B is the best choice here. Creating a view lets you combine data from both tables but exclude restricted columns, so users get only what they’re allowed to see without exposing sensitive info. Stored procedures or triggers don’t really control column-level access like views do.