Free Preparation Discussions
MENU
Snowflake ADA-C01 Exam - Topic 3 Question 23 Discussion
Topic #: 3
A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN NAME = 'JDOE' DEFAULT_ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?
According to the Snowflake documentation1, future grants are a way to automatically grant privileges on future objects of a specific type that are created in a database or schema. By setting up future grants on the newly-created schemas, the administrator can ensure that any tables created by the developers in those schemas will be accessible by the DEV_TEAM role, without having to grant privileges on each table individually. Option A is incorrect because assigning ownership privilege to DEV_TEAM on the newly-created schema does not grant privileges on the tables in the schema, only on the schema itself. Option B is incorrect because assigning usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE does not affect the access to the tables in the schemas, only the ability to use the warehouse. Option D is incorrect because setting up the new schema as a managed-access schema does not grant privileges on the tables in the schema, but rather requires explicit grants for each table.
Kimbery
6 months agoIsaiah
6 months agoYuki
6 months agoAntonio
7 months agoNickole
7 months agoDemetra
7 months agoCaprice
7 months agoMilly
7 months agoNakisha
8 months agoLaticia
8 months agoLanie
8 months agoAlmeta
8 months agoJustine
8 months agoGlenn
2 years agoJanet
2 years agoPhyliss
2 years agoKrystina
2 years agoCory
2 years agoArthur
2 years agoKeva
2 years agoDana
2 years agoShonda
2 years agoCheryll
2 years agoTheresia
2 years agoRyan
2 years agoXochitl
2 years agoPeter
2 years agoFletcher
2 years agoElfriede
2 years agoMarya
2 years agoVivan
2 years agoNoemi
2 years agoHaydee
2 years agoSarina
2 years ago