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 sh

Question

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

• A
  4% (1)
• B
  78% (21)
• C
  11% (3)
• E
  7% (2)

Explanation

Option B is correct because in Snowflake, transferring database ownership requires the GRANT OWNERSHIP ON DATABASE "FINANCIAL DATA" TO ROLE DATA_GOVERNANCE COPY CURRENT GRANTS command, where the database name with a space must be enclosed in double quotes, and the COPY CURRENT GRANTS option preserves existing privileges during the transfer - ensuring the DATA_GOVERNANCE role gains full control without disrupting downstream access.

Why the distractors fail:

• Option A is wrong because it omits the required double quotes around FINANCIAL DATA - any identifier containing a space in Snowflake must be quoted, or the parser will throw a syntax error.
• Options C, D, and E likely differ from B in the COPY CURRENT GRANTS vs. REVOKE CURRENT GRANTS clause or contain other syntax errors. Using REVOKE CURRENT GRANTS strips all existing grants upon transfer, which would break downstream access and violates the requirement that DATA_GOVERNANCE have full control in a stable state.

Memory tip: Think of Snowflake ownership transfer as handing over a house deed - you must quote spaces (like writing the full legal property name) and copy the grants (like transferring existing utility agreements). The mnemonic "Quote Spaces, Copy Grants" captures both critical requirements.

No community discussion yet for this question.