DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #55: Real Exam Question with Answer & Explanation

Question

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project. Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

Options

• AGRANT ALL PRIVILEGES ON TABLE sales TO team;
• BGRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• CGRANT SELECT ON TABLE sales TO team;
• DGRANT USAGE ON TABLE sales TO team;
• EGRANT ALL PRIVILEGES ON TABLE team TO sales;