Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
Tom Hanks, a new member of the data analysis team, has read access to the inventory table but lacks permissions to insert or delete rows. Which command grants him these additional permissions?
Explanation:
The GRANT command is used to assign specific privileges on a securable object to a principal. The correct syntax for granting permissions is GRANT privilege_types ON securable_object TO principal. In this scenario, MODIFY is the privilege type that encompasses both insert and delete operations on the inventory table for the principal tom.hanks@organization.com. Therefore, the correct command is GRANT MODIFY ON TABLE inventory TO tom.hanks@organization.com.