Data Governance (Test Qs)

Question 1

Unity catalog simplifies managing multiple workspaces, by storing and managing permissions and ACL at _______ level

Workspace

Account

Storage

Data pane

Control pane

Answer 1

The answer is, Account Level

The classic access control list (tables, workspace, cluster) is at the workspace level, Unity catalog is at the account level and can manage all the workspaces in an Account.

Question 2

Which of the following section in the UI can be used to manage permissions and grants to tables?

User Settings

Admin UI

Workspace admin settings

User access control lists

Data Explorer

Answer 2

The answer is Data Explorer

Question 3

Which of the following is not a privilege in the Unity catalog?

SELECT

MODIFY

DELETE

CREATE TABLE

EXECUTE

Answer 3

The Answer is DELETE and UPDATE permissions do not exit, you have to use MODIFY which provides both Update and Delete permissions.

Please note: TABLE ACL privilege types are different from Unity Catalog privilege types, please read the question carefully.

Question 4

A team member is leaving the team and he/she is currently the owner of the few tables, instead of transfering the ownership to a user you have decided to transfer the ownership to a group so in the future anyone in the group can manage the permissions rather than a single individual, which of the following commands help you accomplish this?

ALTER_TABLE table_name OWNER to ‘group’

TRANSFER OWNER table_name to ‘group’

GRANT OWNER table_name to ‘group’

ALTER OWNER ON table_name to ‘group’

GRANT OWNER On table_name to ‘group’

Answer 4

The answer is ALTER TABLE table_name OWNER to ‘group’