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

Question

You are tasked with transferring ownership of a database named 'FINANCIAL DATA' from the 'ACCOUNTADMIN' role to a custom role named 'DATA GOVERNANCE'. After the transfer, the 'DATA GOVERNANCE' role should have full control over the database. Which of the following steps must be performed to ensure a successful ownership transfer?

Options

• AExecute the command: 'GRANT OWNERSHIP ON DATABASE FINANCIAL DATA TO ROLE
• BGrant the 'OWNERSHIP' privilege on the database to the 'DATA_GOVERNANCE role using
• CGrant the 'OWNERSHIP privilege on the database to the 'DATA_GOVERNANCE role using
• DGrant the OWNERSHIP' privilege on the database to the 'DATA_GOVERNANCE role using
• EGrant the 'OWNERSHIP' privilege on the database to the 'DATA_GOVERNANCE role using

Explanation

The `GRANT OWNERSHIP command automatically revokes the OWNERSHIP privilege from the previous owner and grants it to the new owner. The user executing must have the necessary privileges to grant OWNERSHIP. The role receiving ownership needs no special privileges beforehand, as it is gaining complete control. Option C suggests 'USAGE privilege must be granted beforehand, which is not necessarily needed to transfer Ownership. Option D implies other privileges must be explictly granted but 'OWNERSHIP' already grants all permissions. Option E requires that the DATA_GOVERNANCE role must be current role for user which is

No community discussion yet for this question.