nerdexam
Snowflake

ADA-C01 · Question #21

ADA-C01 Question #21: Real Exam Question with Answer & Explanation

Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.

Question

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows: USE ROLE SECURITYADMIN; CREATE ROLE ROLE_MANAGED_ACCESS; GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN; GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS; GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS; USE ROLE ROLE_MANAGED_ACCESS; CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS; USE ROLE SECURITYADMIN; GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema. How can this be accomplished?

Options

  • AALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;
  • BUSE ROLE ROLE MANAGED_ACCESS;
  • CREVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA
  • DUSE ROLE ROLE_MANAGED_ACCESS;

Unlock ADA-C01 to see the answer

You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full ADA-C01 Practice