Exam SnowPro Advanced Data Engineer topic 1 question 70 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 70
Topic #: 1

[All SnowPro Advanced Data Engineer Questions]

A Data Engineer runs the following sequence:

use role ACCOUNTADMIN;
create role ROLE1;
grant role ROLE1 to role ACCOUNTADMIN;
grant create database on account to role ROLE1;

use role ROLE1;
create database DB1;

use role ACCOUNTADMIN;
drop role ROLE1;

Who is the owner of database DB1?

A. The deleted ROLE1 remains the owner of the DB1 database.
B. The ACCOUNTADMIN becomes the owner of the DB1 database.
C. ROLE1, because the role cannot be dropped as long as it owns the DB1 database.
D. Database DB1 has no owner.

Show Suggested Answer

Suggested Answer: C 🗳️

by 67bdb19 at Aug. 19, 2025, 6:01 a.m.

Comments

Submit Cancel

Fabiana89

1 month, 1 week ago

Selected Answer: B

If the role owns any objects, the DROP ROLE command automatically transfers ownership of those objects to the role that executed the DROP ROLE command

upvoted 2 times

e970753

1 day, 16 hours ago

I agree, https://docs.snowflake.com/en/sql-reference/sql/drop-role

upvoted 1 times

...