SOL-C01 Question #75: Real Exam Question with Answer & Explanation

Question

A data engineer wants to transfer ownership of a database named 'SALES DATA' to a role named 'DATA ADMIN'. The data engineer executes the following command: '"sql GRANT OWNERSHIP ON DATABASE SALES DATA TO ROLE DATA ADMIN; However, the command fails. Which of the following is the MOST likely reason for the failure?

Options

• AThe data engineer does not have the 'OWNERSHIP' privilege on the 'SALES_DATA database.
• BThe 'DATA ADMIN' role does not exist.
• CThe 'SALES DATA' database does not exist.
• DThe command is syntactically incorrect. GRANT OWNERSHIP requires a 'REVOKE CURRENT
• EThe data engineer must first relinquish ownership before granting ownership to another role.

Explanation

To transfer ownership of an object in Snowflake, the user executing the command must have the 'OWNERSHIP' privilege on the object. Without the `OWNERSHIP privilege, the user cannot grant ownership to another role, regardless of whether the role exists or the database exists. Options B and C are invalid reasons because Snowflake would throw specific error messages indicating that the database/role does not exist. Option D is incorrect because the 'REVOKE CURRENT GRANTS clause is not always required. Option E is incorrect because the user with ownership can directly transfer it without first relinquishing it.

No community discussion yet for this question.