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
10 months ago
Surprised there's no MODIFY needed for hr_db!
upvoted 0 times
...
Elly
10 months ago
I think option D could work too, but not sure.
upvoted 0 times
...
Verda
10 months ago
Wait, why would you need SELECT on schemas? Seems off.
upvoted 0 times
...
Sylvie
10 months ago
Totally agree, option A is the way to go!
upvoted 0 times
...
Gertude
10 months ago
A needs USAGE and SELECT permissions for hr_db.
upvoted 0 times
...
Salome
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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