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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ARA-C01 Exam - Topic 1 Question 4 Discussion

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?
A) USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db
B) USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
C) MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
D) USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db

Snowflake ARA-C01 Exam - Topic 1 Question 4 Discussion

Actual exam question for Snowflake's ARA-C01 exam
Question #: 4
Topic #: 1
[All ARA-C01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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

Limited Time Offer

25%

Off

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Erasmo
7 months ago
Surprised there's no MODIFY needed for hr_db!
upvoted 0 times
...
Elly
7 months ago
I think option D could work too, but not sure.
upvoted 0 times
...
Verda
8 months ago
Wait, why would you need SELECT on schemas? Seems off.
upvoted 0 times
...
Sylvie
8 months ago
Totally agree, option A is the way to go!
upvoted 0 times
...
Gertude
8 months ago
A needs USAGE and SELECT permissions for hr_db.
upvoted 0 times
...
Salome
8 months 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.
upvoted 0 times
...
Nu
8 months 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.
upvoted 0 times
...
Chana
8 months 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.
upvoted 0 times
...
Zachary
8 months 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.
upvoted 0 times
...
Bernadine
8 months 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.
upvoted 0 times
...
Carissa
8 months 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.
upvoted 0 times
...
Jules
8 months ago
I think it's option A because it mentions USAGE and SELECT, which sounds right for a read-only role.
upvoted 0 times
...
Rene
8 months ago
I remember that read-only roles typically need USAGE and SELECT permissions, but I'm not sure about the schemas part.
upvoted 0 times
...
Starr
8 months 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.
upvoted 0 times
...
Esteban
8 months 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.
upvoted 0 times
...
Jolanda
8 months 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.
upvoted 0 times
...
Thaddeus
8 months 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.
upvoted 0 times
...
Joni
8 months 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.
upvoted 0 times
...
Garry
9 months 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.
upvoted 0 times
...
Bettye
9 months 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.
upvoted 0 times
...

Save Cancel