Databricks Certified Data Engineer Associate — Question 71

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 command can be used to grant full permissions on the database to the new data engineering team?

Answer options

• A. GRANT ALL PRIVILEGES ON TABLE sales TO team;
• B. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• C. GRANT SELECT ON TABLE sales TO team;
• D. GRANT ALL PRIVILEGES ON TABLE team TO sales;

Correct answer: A

Explanation

The correct answer is A, as it grants all permissions on the sales table to the team, allowing them to manage it fully. Option B is incorrect because it does not include all necessary privileges, and options C and D only provide limited access or target the wrong table.