Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 109

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

    Correct Answer: B

    When a new Snowflake object is created, it is not automatically owned by the user who created it. Instead, it is owned by the role that was active when the object was created. In Snowflake, objects are owned by roles, not by individual users. Ownership implies that the role has the OWNERSHIP privilege on the object and can control access to it.

Discussion
SurbinOption: B

Owner is always the role, not the user.

c0d3gOption: B

Each object has an owner, who can in turn grant access to that object. To own an object means that a role has the OWNERSHIP privilege on the object. Each securable object is owned by a single role, which by default is the role used to create the object. When this role is assigned to users, they effectively have shared control over the object. In a regular schema, the owner role has all privileges on the object by default, including the ability to grant or revoke privileges on the object to other roles. https://docs.snowflake.com/en/user-guide/security-access-control-overview

KnightVictorOption: B

owned by role, and not by user

BagviOption: B

Not own by the users

Mayuri917233Option: A

A is correct

isolated_sniperOption: B

Any objects created after the command is issued are owned by the role in use when the object is created. https://docs.snowflake.com/en/sql-reference/sql/grant-ownership#

alloshz11Option: B

To own an object means that a role has the OWNERSHIP privilege on the object. Each securable object is owned by a single role, which by default is the role used to create the object. When this role is assigned to users, they effectively have shared control over the object. In a regular schema, the owner role has all privileges on the object by default, including the ability to grant or revoke privileges on the object to other roles. In addition, ownership can be transferred from one role to another https://docs.snowflake.com/en/user-guide/security-access-control-overview#securable-objects

BigDataBBOption: B

It's an ambiguous question, if was ... automatically and "exclusively" owned by the user who created it. Then is sure B but in this way, as long as that user has that role, he has the ownersiph of the objet can alter it and even drop it.

SV1122Option: A

Discretionary Access Control (DAC): Each object has an owner, who can in turn grant access to that object. Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn assigned to users. https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

c0d3g

Each object has an owner, who can in turn grant access to that object. To own an object means that a role has the OWNERSHIP privilege on the object. Each securable object is owned by a single role, which by default is the role used to create the object. When this role is assigned to users, they effectively have shared control over the object. In a regular schema, the owner role has all privileges on the object by default, including the ability to grant or revoke privileges on the object to other roles. https://docs.snowflake.com/en/user-guide/security-access-control-overview

addixionOption: A

If you create a table as ACCOUNTADMIN then the owner will be ACCOUNTADMIN. Then you can grant it to role but the owner won't change. You can check is on the IU > Data > Databases > Then click on a table for example and the metadata show the user as owner.

Mallikharjuna452Option: A

Yes it is True

Raju039Option: B

owned by the role of user who created it

MultiCloudIronManOption: A

This is true its called DAC - Discretional Access Control.

KarBiswaOption: B

When an object is created, its ownership is set to the currently active primary role.

Bala1802

Can we assume a user as a credential you log in with & role is what you privilege to do Also can we assume an object created by a role can be accessible to all users under the same role?

baig123Option: A

Answer is A, it is DAC ownership assigned to role under which object is created.

allthingsdataOption: B

answer is b