What does Snowflake recommend regarding database object ownership? (Select 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 for66 objects owned by ACCOUNTADMIN.
The Answer Is:
B, D
This question includes an explanation.
Explanation:
Snowflake recommends creating objects with a role that has the necessary privileges and is not overly permissive. SYSADMIN is typically used for managing system-level objects and operations. Creating objects with a custom role and granting this role to SYSADMIN allows for more granular control and adherence to the principle of least privilege. References: Based on best practices for database object ownership and role management.
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"