Free Preparation Discussions
MENU
Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 5 Question 34 Discussion
Topic #: 5
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?
To grant full privileges on a table such as 'sales' to a group like 'team', the correct SQL command in Databricks is:
GRANT ALL PRIVILEGES ON TABLE sales TO team;
This command assigns all available privileges, including SELECT, INSERT, UPDATE, DELETE, and any other data manipulation or definition actions, to the specified team. This is typically necessary when a team needs full control over a table to manage and manipulate it as part of a project or ongoing maintenance.
Reference: Databricks documentation on SQL permissions: SQL Permissions in Databricks
Clorinda
1 months agoSamira
1 months agoJennifer
4 days agoMariko
21 days agoLatosha
1 months agoRessie
4 days agoGlenna
10 days agoPearlene
14 days agoKarina
24 days agoVicki
2 months agoIvette
2 months agoJoaquin
2 months agoCherry
16 days agoErinn
21 days agoHoward
1 months agoKrystal
1 months agoChauncey
1 months agoTruman
2 months agoReed
2 months agoParis
2 months agoAlaine
2 months ago