Q: 9
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
Discussion
Maybe A. Saw a similar question in a mock and it matched option A for full access.
A. but only because "sales" is a table here. If the team needed database-level rights, GRANT ALL PRIVILEGES ON DATABASE would be needed instead. Kinda nitpicky but that switch flips the answer. Anyone disagree?
A . GRANT ALL PRIVILEGES ON TABLE sales TO team; gives full access, which covers SELECT, INSERT, UPDATE, DELETE, ALTER, etc. Pretty sure the others miss out on some rights needed for full management.
Maybe B. It lists SELECT CREATE MODIFY, which should give enough access? A feels like a trap for full rights.
Classic Databricks SQL wording, just A tbh. Their docs always use GRANT ALL PRIVILEGES for this kind of full control.
B or A, but I think B could work since it gives SELECT, CREATE, and MODIFY. Feels like those are core for managing, unless they need DROP and ALTER too. Not 100 percent on this since "ALL PRIVILEGES" covers more. Someone else see a catch with B?
Saw similar on a practice test, it's A.
A is right. You need
GRANT ALL PRIVILEGES ON TABLE sales TO team; to give them exactly what the question describes, full rights on the table. B only gives partial access and USAGE isn't for tables. Pretty sure about this but let me know if I'm missing something.A tbh
A , official docs and practice tests say GRANT ALL PRIVILEGES is what gives the team full control.
Be respectful. No spam.
