SnowPro Advanced: Architect — Question 173

An Architect is creating a new database role for a team of Data Analysts. The Architect is considering using the OR REPLACE keywords in the CREATE DATABASE ROLE command to ensure the role is created even if it already exists.

What should the Architect consider before using the OR REPLACE keywords?

Answer options

• A. The dropped database role cannot be recreated.
• B. The OR REPLACE keywords are unsupported when creating a database role.
• C. Recreating a database role drops it from any shares that it is granted to.
• D. The database role can only be dropped by a user with a role that has the MANAGE GRANTS privilege.

Correct answer: C

Explanation

The correct answer is C because when a database role is recreated, it loses its existing permissions on shares. Option A is incorrect as a dropped role can be recreated, option B is false since the OR REPLACE keywords are supported, and option D is irrelevant to the context of using OR REPLACE.