There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?
Suggested Answer: A
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
20 comments · newest first
ER
Erasmo
11 months ago
Surprised there's no MODIFY needed for hr_db!
EL
Elly
11 months ago
I think option D could work too, but not sure.
VE
Verda
12 months ago
Wait, why would you need SELECT on schemas? Seems off.
SY
Sylvie
12 months ago
Totally agree, option A is the way to go!
GE
Gertude
12 months ago
A needs USAGE and SELECT permissions for hr_db.
SA
Salome
1 year ago
I believe USAGE is definitely needed for the database and schemas, but I’m not sure if we need SELECT on all tables or just some.
NU
Nu
1 year ago
I’m a bit confused about the difference between USAGE and SELECT. I thought both were necessary for read-only access, but I can't recall clearly.
CH
Chana
1 year ago
I remember a similar question where we had to grant permissions for read-only access. I feel like option A might be the right choice here.
ZA
Zachary
1 year ago
I think the role needs USAGE on the database and schemas, but I'm not sure if SELECT is the right permission for the tables.
BE
Bernadine
1 year ago
I thought MODIFY was for write access, so I don't think option C is correct. It has to be something that allows viewing only.
CA
Carissa
1 year ago
I practiced a similar question, and I feel like USAGE is definitely needed, but I can't recall if SELECT is required on schemas too.
JU
Jules
1 year ago
I think it's option A because it mentions USAGE and SELECT, which sounds right for a read-only role.
RE
Rene
1 year ago
I remember that read-only roles typically need USAGE and SELECT permissions, but I'm not sure about the schemas part.
ST
Starr
1 year ago
I'm pretty confident about this one. The question is asking about topology management in Cloud Pak for Watson AlOps, and based on my understanding, option B seems to be the correct answer.
ES
Esteban
1 year ago
I have a vague memory of vulnerabilities being discussed, maybe option B fits, but I feel like I need to review that part again.
JO
Jolanda
1 year ago
I'm a bit confused on the best approach here. Should I create a header, footer, or template? I'll need to think this through carefully.
TH
Thaddeus
1 year ago
This is a tricky one. I'm torn between B and C, but I think C is the better long-term solution. Reinforcing the value of the product is important here.
JO
Joni
1 year ago
This seems like a straightforward question. I'd recommend option B - starting with technology the teachers are most familiar with. That way they can focus on the lesson content rather than struggling with the tech.
GA
Garry
1 year ago
I'm a bit confused by this question. The blockchain and IoT seem like two separate technologies. I'm not sure how they would "dramatically" impact anything together. I'll have to review my notes on this.
BE
Bettye
1 year ago
I remember studying that wills can be used to distribute property to specific individuals or charities, so I think both I and II are correct.