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

Question

A data engineer needs to transfer ownership of a database named 'SALES DATA' to a role named 'DATA GOVERNANCE The engineer attempts to use the following command: 'GRANT OWNERSHIP ON DATABASE SALES DATA TO ROLE DATA GOVERNANCE. However, this command fails. What is the MOST likely reason for the failure?

Options

• AThe `DATA GOVERNANCE role does not have the 'OWNERSHIP' privilege on the 'SALES DATA'
• BThe correct syntax is 'ALTER DATABASE SALES_DATA OWNER TO ROLE
• CThe role executing the command does not have the 'OWNERSHIP' privilege on the `SALES DATA
• DOwnership can only be transferred to users, not roles.
• EThe `SALES DATA database contains shared data; ownership cannot be transferred in such

Explanation

The GRANT OWNERSHIP command requires that the role executing the command currently owns the object (database in this case). If the role executing the command doesn't have the OWNERSHIP privilege, it cannot transfer ownership to another role. Options A, B, D and E are incorrect because the problem is about the role which is executing the command.

No community discussion yet for this question.