Câu 15: SnowPro Advanced Administrator ADA-C01

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.)

1. A. USER1 and ROLE_ALPHA
2. B. USER2 and ROLE_BETA — đáp án hiện tại
3. C. USER3 and ROLE_XYZ — đáp án hiện tại
4. D. USER1 and ROLE_XYZ
5. E. USER3 and ROLE_ALPHA