CompTIA DA0-001 Exam - Topic 4 Question 54 Discussion

Actual exam question for CompTIA's DA0-001 exam

Question #: 54
Topic #: 4

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?

ARole-based

BRule-based

CDiscretionary

DGroup-based

Show Suggested Answer

Suggested Answer: A

Comprehensive and Detailed In-Depth

Access control is a critical aspect of database security. The best method for controllingwho can access financial databased onjob rolesisRole-Based Access Control (RBAC).

Option A (Role-based):Correct.RBAC assigns permissions based on a user's role within the organization (e.g., accountants can access financial data, but sales representatives cannot).

Option B (Rule-based):Incorrect. Rule-Based Access Control (RuBAC) enforces policies based on rules, such as time restrictions, rather than user roles.

Option C (Discretionary):Incorrect. Discretionary Access Control (DAC) allows individual users to grant permissions, which can lead to security risks in financial systems.

Option D (Group-based):Incorrect. Group-Based Access Control (GBAC) assigns permissions based on user groups, but RBAC provides finer control for financial functions.

by Laine at Mar 08, 2025, 02:33 AM

Limited Time Offer

25%

Off

Get Premium DA0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Milly

4 months ago

Wait, group-based? Isn't that too broad for financial functions?

upvoted 0 times

...

Delmy

4 months ago

I’m surprised people are even considering discretionary access here!

upvoted 0 times

...

Solange

4 months ago

Discretionary access? That's risky for sensitive info!

upvoted 0 times

...

Bulah

5 months ago

I think rule-based could work too, but not as well as role-based.

upvoted 0 times

...

Janey

5 months ago

Role-based is definitely the way to go for financial data.

upvoted 0 times

...

Sherill

5 months ago

Group-based access sounds familiar, but I feel like it might not be as precise as role-based for controlling financial access.

upvoted 0 times

...

Golda

5 months ago

I practiced a similar question, and I think discretionary access control was mentioned as less secure for sensitive data. Not sure if that's relevant here.

upvoted 0 times

...

Kimberlie

6 months ago

I'm not entirely sure, but I remember something about rule-based access being more flexible. Could that be a good choice too?

upvoted 0 times

...

Janae

6 months ago

I think role-based access control might be the best option here since it allows permissions based on user roles, which seems fitting for financial functions.

upvoted 0 times

...

Rosendo

6 months ago

Role-based access control is definitely the most appropriate choice here. It provides a clear and structured way to manage user permissions for the financial tables, ensuring only authorized personnel can access the data.

upvoted 0 times

...

Stanton

6 months ago

I'm a bit confused on the differences between rule-based and role-based access control. Can someone help me understand which one would be better for this scenario?

upvoted 0 times

...

Tora

6 months ago

Okay, I've got this. Role-based access control is the way to go. It allows the admin to assign specific roles and permissions to users, which is perfect for controlling access to sensitive financial data.

upvoted 0 times

...

Theodora

6 months ago

Hmm, I'm not entirely sure about this one. I'll need to think it through a bit more. Maybe I should review the differences between the access control methods before deciding.

upvoted 0 times

...

Cory

6 months ago

This seems like a straightforward access control question. I think role-based access control is the best option here to ensure only approved users can access the financial tables.

upvoted 0 times

...

Howard

6 months ago

Based on the details provided, I believe role-based access control is the way to go. It provides a more structured and manageable approach to controlling access to the sensitive financial tables.

upvoted 0 times

...

Luke

6 months ago

I'm a bit confused on the differences between rule-based and role-based access control. Can someone help me understand which one would be better for this scenario?

upvoted 0 times

...

Diane

6 months ago

Role-based access control sounds like the most appropriate solution here. It allows the administrator to grant access based on the user's role or job function, which aligns with the requirement of only allowing approved users to access the financial tables.

upvoted 0 times

...

Gary

6 months ago

Hmm, I'm not entirely sure about this one. I'll need to think through the different access control methods and their pros and cons to determine the best fit.

upvoted 0 times

...

Georgeanna

6 months ago

This seems like a straightforward access control question. I think role-based access control would be the best approach to ensure only approved users can access the financial tables.

upvoted 0 times

...