SnowPro Core Certification — Question 423

What does Snowflake recommend regarding database object ownership? (Choose two.)

Answer options

• 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.

Correct answer: B, D

Explanation

The correct answers, B and D, highlight the best practices for object creation and ownership management in Snowflake. Creating objects with SYSADMIN (B) allows for proper management of permissions, while using a custom role and granting it to SYSADMIN (D) facilitates more flexible access control. The other options either suggest practices that may lead to complications in ownership management or do not align with Snowflake's recommended practices.