Snowflake
ADA-C01 · Question #26
ADA-C01 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Question
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?
Options
- AAssign ownership privilege to DEV_TEAM on the newly-created schema.
- BAssign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
- CSet up future grants on the newly-created schemas.
- DSet up the new schema as a managed-access schema.
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.