
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;