John Smith, a new member of the Marketing team, currently has read access to sales tables but lacks the permission to delete rows. Which command would grant him the necessary delete access?

Real Exam

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

9.7%

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

33.2%

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

46.5%

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

6.6%

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

3.9%

Databricks Certified Data Engineer - Associate