SOL-C01 · Question #68
SOL-C01 Question #68: Real Exam Question with Answer & Explanation
The correct answer is A: Immediately execute 'ALTER TABLE SALES.ORDERS TRANSFER OWNERSHIP TO ROLE. Transferring ownership using 'ALTER TABLE ... TRANSFER OWNERSHIP' is a metadata operation and does not lock or significantly impact existing queries on the table. It's the most straightforward and least disruptive approach. Cloning, creating views, or recreating tables involve si
Question
A data warehouse contains a table named 'ORDERS in schema `SALES'. The current owner of the `ORDERS' table is the `ANALYST role. The compliance team requires that the ownership be transferred to the 'SECURITY ADMIN' role, but without interrupting any existing queries or processes that use the table. What is the recommended approach to transfer ownership with minimal disruption?
Options
- AImmediately execute 'ALTER TABLE SALES.ORDERS TRANSFER OWNERSHIP TO ROLE
- BCreate a clone of the 'ORDERS table, transfer ownership of the clone, then drop the original
- CCreate a view on top of the 'ORDERS' table, transfer ownership of the view to 'SECURITY
- DExecute 'ALTER TABLE SALES.ORDERS TRANSFER OWNERSHIP TO ROLE
- ECreate a new table with the same structure as 'ORDERS' , load data into it, grant all privileges to
Explanation
Transferring ownership using 'ALTER TABLE ... TRANSFER OWNERSHIP' is a metadata operation and does not lock or significantly impact existing queries on the table. It's the most straightforward and least disruptive approach. Cloning, creating views, or recreating tables involve significant data operations and downtime, which are undesirable.
Topics
Community Discussion
No community discussion yet for this question.