Snowflake Exam ADA-C01 Topic 2 Question 13 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 13
Topic #: 2

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

AMIMIC_CONSUMER_ACCOUNT

BTEST_ACCOUNT_ID

CPRODUCER_TEST_ACCT

DSIMULATED_DATA_SHARING_CONSUMER

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 Dacia at May 09, 2024, 05:47 AM

Limited Time Offer

25%

7 months ago

Hey, did you see that question about testing the integrity of secure views?

upvoted 0 times

...