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).

AUsers with the SYSADMIN role can grant object privileges in a managed access schema.

BUsers with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.

CUsers who are database owners can grant object privileges in a managed access schema.

DUsers who are schema owners can grant object privileges in a managed access schema.

EUsers who are object owners can grant object privileges in a managed access schema.

Show Suggested 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.

by Rodolfo at Sep 15, 2024, 06:13 PM

Limited Time Offer

25%

1 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

3 days ago

Users who are object owners can grant object privileges in a managed access schema.

upvoted 0 times

...

Leonida

4 days ago

Users who are schema owners can grant object privileges in a managed access schema.

upvoted 0 times

...

Barbra

10 days ago

D and E are the correct answers here.

upvoted 0 times

...

Francesco

1 months ago

I think A) Users with the SYSADMIN role can grant object privileges in a managed access schema.

upvoted 0 times

...

Lorrie

1 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

13 days ago

Yes, and users who are object owners can also grant object privileges in a managed access schema.

upvoted 0 times

...

Paulene

20 days ago

I agree, users with the SECURITYADMIN role or higher can grant object privileges in a managed access schema.

upvoted 0 times

...