Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake ARA-C01 Exam - Topic 1 Question 4 Discussion

Posted by Gwenn on Mar 25, 2023 at 04:00 PM

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.
0/2000 characters

Save Cancel