CompTIA Data+ (DA0-001) — Question 286

A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control method for the administrator to use?

Answer options

Correct answer: A

Explanation

The Role-based access control method is ideal for managing permissions based on user roles, allowing only authorized users to access specific financial functions and database tables. Rule-based access control is more about applying rules rather than user roles, while Discretionary access control allows users to make their own decisions about permissions, which could lead to unauthorized access. Group-based access control is less specific and may not effectively restrict access to only approved users for particular functions.