Snowflake Exam ADA-C01 Topic 5 Question 22 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 22
Topic #: 5

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

ACURRENT_ROLE

BCURRENT ACCOUNT

CCURRENT_USER

DCURRENT_CLIENT

Show Suggested Answer

Suggested Answer: D

The SIMULATED_DATA_SHARING_CONSUMER session parameter allows a data provider to test the integrity of secure views based on the account that is accessing that view2. By setting this parameter to the name of the consumer account, the data provider can query the secure view and see the results that a user in the consumer account will see2. This helps to ensure that sensitive data in a shared database is not exposed to unauthorized users1. The other options are not valid session parameters in Snowflake3

by Latanya at Sep 07, 2024, 08:19 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Catherin

1 months ago

C) CURRENT_USER all the way! I mean, who else would we use to authorize users, right? Unless they're trying to trick us with a red herring. *chuckles*

upvoted 0 times

Blondell

5 days ago

B) CURRENT_ACCOUNT is not the function needed for authorizing users from another account, it is CURRENT_ROLE.

upvoted 0 times

...

Telma

13 days ago

C) CURRENT_USER is not the correct function in this case, it is CURRENT_ROLE that is needed for authorization.

upvoted 0 times

...

Alishia

17 days ago

A) CURRENT_ROLE is actually the correct function to authorize users from another account to access rows in a base table.

upvoted 0 times

...

Karma

2 months ago

D) CURRENT_CLIENT? Really? That doesn't seem quite right for this scenario. I'm pretty confident the answer is either A or C.

upvoted 0 times

Kelvin

2 days ago

Let's go with A) CURRENT_ROLE then.

upvoted 0 times

...

Kristine

22 days ago

Yeah, CURRENT_USER is also a possibility.

upvoted 0 times

...

Oneida

1 months ago

I agree, CURRENT_ROLE makes more sense in this context.

upvoted 0 times

...

Harley

2 months ago

I think the answer is A) CURRENT_ROLE.

upvoted 0 times

...

Elden

2 months ago

Hmm, I'm not sure about that. I was thinking maybe B) CURRENT_ACCOUNT would be the right function to use. But I'll have to double-check the documentation.

upvoted 0 times