Free Databricks Certified Data Engineer Associate Actual Exam Questions - Question 11 Discussion
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?
D imo, the syntax is off there—it’s granting privileges on “team” to “sales,” which doesn’t make sense. A is more straightforward and fits standard SQL for giving full control on a table. B is clearly not enough since just SELECT won’t let them manage or modify anything. C tries to list specific permissions but isn’t valid syntax in most SQL dialects. So, A seems like the best fit assuming “team” is the user or role name here.
It’s A for me too. B is way too limited since just SELECT won’t let the team manage the table. C isn’t even valid syntax as far as I know, and D mixes up the objects—it grants privileges on the team to sales, which makes no sense. So A is the only option that properly gives full permissions on the sales table to the team.
It’s A. The question asks for full privileges on the table sales, so GRANT ALL PRIVILEGES makes sense here. B is definitely too limited since SELECT alone won’t allow managing the table fully. C looks weird because “CREATE” and “MODIFY” aren’t standard privilege keywords in most SQL dialects for tables. D is just backwards, as others pointed out, swapping table and user names. So A is the only option that fits the requirement of full access for the team on the sales table.
Maybe D is off because it swaps the table and user names, which doesn’t make sense. C looks too specific—"SELECT CREATE MODIFY" isn’t a standard combo in most SQL dialects for full access. B only grants SELECT, which is definitely not full privileges. A seems straightforward for giving all rights on the sales table to the team, so I’d go with that one as well.
A/D? D definitely mixes up the table and user, so no. A is straightforward and covers everything on sales, unlike B and C which miss modify rights. Seems like the only solid pick here.
I'm leaning towards A. It says "grant all privileges on table sales TO team," which sounds like giving full access to the team on the sales table. B and C seem limited, and D looks mixed up with team and sales swapped. Anyone else agree?