John Smith, a new member of the Marketing team, currently has read access to sales tables but lacks the permission to update them. Which command would you use to grant him update access?

Real Exam

GRANT USAGE ON TABLE table_name TO john.smith@marketing.com_

8.7%

GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com_

60.4%

GRANT UPDATE TO TABLE table_name ON john.smith@marketing.com_

3.5%

GRANT UPDATE ON TABLE table_name TO john.smith@marketing.com_

22.9%

GRANT MODIFY TO TABLE table_name ON john.smith@marketing.com_

4.5%

Databricks Certified Data Engineer - Associate