Exam SnowPro Advanced Architect topic 1 question 63 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 63
Topic #: 1

[All SnowPro Advanced Architect Questions]

A group of Data Analysts have been granted the role ANALYST_ROLE. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data.

How should these requirements be met?

A. Grant ANALYST_ROLE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.
B. Grant SYSADMIN OWNERSHIP of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.
C. Make every schema in the database a MANAGED ACCESS schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.
D. Grant ANALYST_ROLE OWNERSHIP on the database, but grant the OWNERSHIP ON FUTURE [object type]s in database privilege to SYSADMIN.

Show Suggested Answer

Suggested Answer: C 🗳️

by Atomic_Gecko at March 3, 2024, 12:37 a.m.

Comments

Submit Cancel

ywan1600

1 month ago

Selected Answer: C

C is correct

upvoted 1 times

...

Atomic_Gecko

7 months, 1 week ago

C is correct

upvoted 1 times

...

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 63 discussion

Comments

ywan1600

Atomic_Gecko

SY0-701