Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 5 Question 34 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate Exam exam

Question #: 34
Topic #: 5

[All Databricks Certified Data Engineer Associate Exam Questions]

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?

Agrant all privileges on table sales TO team;

BGRANT SELECT ON TABLE sales TO team;

CGRANT SELECT CREATE MODIFY ON TABLE sales TO team;

DGRANT ALL PRIVILEGES ON TABLE team TO sales;

Show Suggested Answer

Suggested Answer: A

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

by Beatriz at Sep 12, 2024, 08:30 AM

Limited Time Offer

25%

Off

Get Premium Databricks-Certified-Data-Engineer-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Samira

2 days ago

Haha, D is just a total curveball. Trying to distract us, are they? A is the way to go, no doubt about it.

upvoted 0 times

...

Latosha

6 days ago

Ah, classic SQL permissions question. I'm going with A - grants all the necessary privileges to the team, simple and straightforward.

upvoted 0 times

...

Vicki

20 days ago

I think D) GRANT ALL PRIVILEGES ON TABLE team TO sales is definitely not the correct command for this scenario.

upvoted 0 times

...

Ivette

22 days ago

Come on, how could it be D? Granting all privileges on the 'team' table to 'sales' doesn't make any sense. Obviously, A is the right choice here.

upvoted 0 times

...

Joaquin

26 days ago

The correct answer is A. Granting all privileges on the table 'sales' to the new data engineering team is the appropriate command to fully manage the ELT project.

upvoted 0 times