Valid ADA-C01 Dumps shared by ExamDiscuss.com for Helping Passing ADA-C01 Exam! ExamDiscuss.com now offer the newest ADA-C01 exam dumps, the ExamDiscuss.com ADA-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com ADA-C01 dumps with Test Engine here:
A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region. When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?
Correct Answer: C
This code snippet will create a row access policy that returns true if the current role is ALL_ACCESS_ROLE or if the current role matches the region value in the entitlement_table. This means that the ALL_ACCESS_ROLE can see all rows regardless of region, while the other roles can only see rows for their own regions. According to the Snowflake documentation, the CURRENT_ROLE context function returns the name of the current role for the session. The EXISTS function returns true if the subquery returns any rows. The OR operator returns true if either operand is true. Therefore, this code snippet satisfies the requirements of the question.