Explanation:
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.
Ultimate access to all questions.
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;
No comments yet.