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

Question

A data engineer, Bob, created a table 'CUSTOMER DATA' in schema 'SALES SCHEMA' within the database 'ENTERPRISE_DB' Bob is leaving the company, and ownership of the table needs to be transferred to Alice. Which of the following SQL commands will correctly transfer ownership of the 'CUSTOMER DATA' table to the 'ALICE role, ensuring Alice can grant further privileges on the table to other roles? A. B. C. D. E.

Options

• AGRANT OWNERSHIP ON TABLE SALES_SCHEMA."CUSTOMER DATA" TO ROLE ALICE;
• BALTER TABLE ENTERPRISE_DB.SALES_SCHEMA."CUSTOMER DATA" OWNER TO ALICE;
• CGRANT OWNERSHIP ON TABLE ENTERPRISE_DB.SALES_SCHEMA."CUSTOMER DATA" TO ROLE ALICE COPY CURRENT GRANTS;
• DTRANSFER OWNERSHIP OF TABLE SALES_SCHEMA."CUSTOMER DATA" TO ALICE;
• EGRANT ALL PRIVILEGES ON TABLE ENTERPRISE_DB.SALES_SCHEMA."CUSTOMER DATA" TO ROLE ALICE WITH GRANT OPTION;

Explanation

The correct command to transfer ownership in Snowflake is 'ALTER TABLE ... TRANSFER OWNERSHIP TO ROLE ..:. option A is a GRANT statement, not an ownership transfer. Option B is incorrect SQL syntax in Snowflake. Option C attempts to grant ownership to a user instead of a role, which isn't the requirement. Option D uses incorrect syntax, there is no SET OWNER property. Option E is the only command that correctly transfers ownership to a role.

No community discussion yet for this question.