Câu 5: SnowPro Advanced Administrator ADA-C01

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows: The Administrator now wants to disable the managed access on the schema. How can this be accomplished?

1. A. ALTER SCHEMA SCHEMA_MANAGED_ACCESS DISABLE MANAGED ACCESS;
2. B. USE ROLE ROLE_MANAGED_ACCESS;DROP SCHEMA WORK.SCHEMA_MANAGED_ACCESS;CREATE SCHEMA SCHEMA_MANAGED_ACCESS;Then recreate all needed objects.
3. C. REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROMROLE MANAGED ACCESS;ALTER SCHEMA SCHEMA_MANAGED_ACCESS DISABLE MANAGED ACCESS;
4. D. USE ROLE ROLE_MANAGED_ACCESS;DROP SCHEMA WORK.SCHEMA_MANAGED_ACCESS;CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;Then recreate all needed objects. — đáp án hiện tại