Answer-first summary for fast verification
Answer: Create objects with SYSADMIN., Create objects with a custom role and grant this role to SYSADMIN.
Snowflake recommends creating database objects with SYSADMIN (B) or with a custom role that is then granted to SYSADMIN (D). This approach centralizes object management under the SYSADMIN role, which is designed for system administration tasks including creating and managing databases, warehouses, and other objects. Creating objects directly with ACCOUNTADMIN (A) is not recommended as it's a powerful role meant for account-level administration, not routine object creation. Using SECURITYADMIN (C) is also not optimal as its primary purpose is security management, not object creation. Managed access schemas (E) are unrelated to object ownership recommendations and address different security concerns.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What does Snowflake recommend for database object ownership? (Choose two.)
A
Create objects with ACCOUNTADMIN and do not reassign ownership.
B
Create objects with SYSADMIN.
C
Create objects with SECURITYADMIN to ease granting of privileges later.
D
Create objects with a custom role and grant this role to SYSADMIN.
E
Use only managed access schemas for objects owned by ACCOUNTADMIN.