Answer-first summary for fast verification
Answer: GRANT SELECT, MODIFY ON TABLE sales TO new.engineer@company.com;
The correct command to grant the necessary permissions is `GRANT SELECT, MODIFY ON TABLE sales TO new.engineer@company.com;`. This command grants the ability to both query (`SELECT`) and update (`MODIFY`) the `sales` table to the specified user. The `GRANT` command syntax requires specifying the privilege types (`SELECT, MODIFY`), the securable object (`ON TABLE sales`), and the principal (`TO new.engineer@company.com`). This ensures the data engineer has the appropriate access rights to perform their tasks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A new data engineer has joined a company and has been added to the Databricks workspace as new.engineer@company.com. They need to query and update the sales table in the retail database, having already been granted USAGE on the retail database. Which command grants the necessary permissions?
A
GRANT USAGE ON TABLE sales TO new.engineer@company.com;
B
GRANT SELECT, UPDATE TO new.engineer@company.com ON TABLE sales;
C
GRANT SELECT, MODIFY ON TABLE sales TO new.engineer@company.com;
D
GRANT SELECT, UPDATE ON TABLE sales TO new.engineer@company.com;
E
GRANT SELECT, MODIFY TO new.engineer@company.com ON TABLE sales;