ADA-C01 Real Exam Questions

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?

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views. How can this be accomplished?

Two different roles are running queries on a production database. The queries are similar in complexity and duration, and there is generally about 3 minutes of idle time between queries. Typically, there are 2 or 3 queries running at a time for each role. Users in the Finance role are querying one set of tables, and users in the Engineering role are querying a different set of tables. What is the optimal approach to set up the virtual warehouse(s) based on this scenario?