ADA-C02 Question 10

SnowPro Advanced: Administrator · Snowflake

A user has built a view named DB.VWS.TEST_VIEW in Snowflake which only allows users having ROLE_XYZ to retrieve data from the view. Roles Setup: GRANT USAGE ON DATABASE DB TO ROLE ROLE_ALPHA; GRANT USAGE ON SCHEMA DB.VWS TO ROLE ROLE_ALPHA; GRANT SELECT ON VIEW TEST_VIEW IN SCHEMA DB.VWS TO ROLE ROLE_ALPHA; GRANT ROLE ROLE_ALPHA TO ROLE ROLE_XYZ; GRANT ROLE ROLE_XYZ TO ROLE ROLE_BETA; GRANT ROLE ROLE_ALPHA TO USER USER1; GRANT ROLE ROLE_BETA TO USER USER2; GRANT ROLE ROLE_XYZ TO USER USER3; View definition: CREATE VIEW DB.VWS.TEST_VIEW AS ( SELECT * FROM TEST TABLE WHERE IS_ROLE_IN_SESSION('ROLE_XYZ')=TRUE ) ; Which user and current role combination can retrieve data from the view? (Choose two.)

Select 2 answers.

Purchase Full Access to view answer options & explanation

The first 7 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 22 questions.

Unlock Full Access Try Free Preview (Q1–Q7)

Continue in Practice Mode for ADA-C02

Preparing Practice Exam…

Please wait a moment while the system generates the exam questions, answers, and study session.