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 Exam ARA-C01 Topic 5 Question 38 Discussion

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

In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

Show Suggested Answer Hide Answer
Suggested Answer: B, D

In a managed access schema, the privilege management is centralized with the schema owner, who has the authority to grant object privileges within the schema. Additionally, the SECURITYADMIN role has the capability to manage object grants globally, which includes within managed access schemas. Other roles, such as SYSADMIN or database owners, do not inherently have this privilege unless explicitly granted.


Contribute your Thoughts:

Annelle
10 months ago
I know the answer to this one! It's B and E, for sure. Gotta keep those SECURITYADMIN folks and object owners in check, am I right? *winks*
upvoted 0 times
...
Sharika
10 months ago
Wait, are we supposed to select two answers? I was just going to say E, but I guess I need to pick another. Hmm, maybe C and E? Database owners and object owners, that sounds about right.
upvoted 0 times
...
Arthur
10 months ago
This is an interesting question! I'm going to go with B and D. The SECURITYADMIN role and schema owners should have the ability to manage object privileges.
upvoted 0 times
Lashandra
9 months ago
It's important to have the right roles assigned for managing object privileges in a managed access schema.
upvoted 0 times
...
Muriel
9 months ago
Yes, that's correct. Schema owners also have the ability to grant object privileges in a managed access schema.
upvoted 0 times
...
Willodean
10 months ago
I agree with you, users with the SECURITYADMIN role or higher can definitely manage object privileges.
upvoted 0 times
...
...
Kayleigh
11 months ago
I'm not sure about C) Users who are database owners can grant object privileges in a managed access schema. Can someone explain why that might be true?
upvoted 0 times
...
Anisha
11 months ago
I agree with that, but I also believe B) Users with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.
upvoted 0 times
...
Lavonna
11 months ago
D and E are the correct answers here. Schema owners and object owners can grant object privileges in a managed access schema.
upvoted 0 times
Lavonda
10 months ago
Users who are object owners can grant object privileges in a managed access schema.
upvoted 0 times
...
Leonida
10 months ago
Users who are schema owners can grant object privileges in a managed access schema.
upvoted 0 times
...
Barbra
10 months ago
D and E are the correct answers here.
upvoted 0 times
...
...
Francesco
11 months ago
I think A) Users with the SYSADMIN role can grant object privileges in a managed access schema.
upvoted 0 times
...
Lorrie
11 months ago
I think the answer is B and E. Users with the SECURITYADMIN role or higher, and users who are object owners, can grant object privileges in a managed access schema.
upvoted 0 times
Helga
10 months ago
Yes, and users who are object owners can also grant object privileges in a managed access schema.
upvoted 0 times
...
Paulene
11 months ago
I agree, users with the SECURITYADMIN role or higher can grant object privileges in a managed access schema.
upvoted 0 times
...
...

Save Cancel