Answer-first summary for fast verification
Answer: Michael, as the creator, is the owner of the `digital_marketing` table.
In Unity Catalog, each securable object has an owner, which can be any account-level user or group (principal). The principal that creates an object becomes its initial owner. This owner has all privileges on the object, including the ability to grant privileges to others. Ownership can be transferred by the current owner, a metastore admin, or the owner of the containing catalog or schema. Therefore, Michael, having created the `digital_marketing` table, is its owner.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
James, a senior data analyst, owns the marketing schema. For an upcoming social media marketing campaign, Michael needs to create a new table named digital_marketing within this schema. James grants Michael the CREATE TABLE privilege, and Michael proceeds to create the table. Who is the owner of the newly created digital_marketing table?
A
Both James and Michael share ownership of the new digital_marketing table.
B
Since James owns the marketing schema, he automatically owns all tables within it, including digital_marketing.
C
Michael, as the creator, is the owner of the digital_marketing table.
D
By default, the workspace admin becomes the owner of the new digital_marketing table.
E
The account admin is, by default, the owner of the new digital_marketing table.
No comments yet.