BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ADA-C01 Topic 2 Question 13 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 13
Topic #: 2
[All ADA-C01 Questions]

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

Show Suggested Answer Hide 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


Contribute your Thoughts:

Bette
5 months ago
It's hard. The options are all so close! I chose A because it explicitly mimics an account.
upvoted 0 times
...
Shayne
5 months ago
I also considered D) SIMULATED_DATA_SHARING_CONSUMER since it mentions 'consumer'.
upvoted 0 times
...
Hailey
6 months ago
Not sure, I was leaning towards B) TEST_ACCOUNT_ID. Seems straightforward.
upvoted 0 times
...
Colene
6 months ago
Yeah, tricky one. Which session parameter is it?
upvoted 0 times
...
Theodora
6 months ago
I think it's A) MIMIC_CONSUMER_ACCOUNT. It fits the context best.
upvoted 0 times
...
Bette
7 months ago
Hey, did you see that question about testing the integrity of secure views?
upvoted 0 times
...

Save Cancel