Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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?
Explanation:
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.