Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 4 Question 43 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 43
Topic #: 4
[All Databricks-Certified-Data-Engineer-Associate 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?

Show Suggested Answer Hide 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 Melina at Jan 14, 2025, 02: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
Mertie
2 months ago
This question is a piece of cake! A is the obvious choice. Although, I do wonder if the team members have super powers that allow them to manipulate the table through sheer force of will.
upvoted 0 times
...
Yuette
2 months ago
Hmm, I'm going with B. SELECT should be enough for the team to do their job, no need for overkill permissions.
upvoted 0 times
...
Lamonica
2 months ago
D? Really? Granting all privileges on the table to the team? That's just nonsensical. A is the correct answer here.
upvoted 0 times
...
Benedict
2 months ago
I think option C is the way to go. Why give them all privileges when they only need SELECT, CREATE, and MODIFY permissions?
upvoted 0 times
Mitsue
15 days ago
That makes sense, I'll go with option C as well. Thanks for the input!
upvoted 0 times
...
Enola
20 days ago
I see your point, but it's always best practice to only grant the necessary permissions to limit any potential risks.
upvoted 0 times
...
Louvenia
1 months ago
But wouldn't it be easier to just grant all privileges to avoid any potential issues?
upvoted 0 times
...
Alana
1 months ago
I agree with you, option C seems to be the most appropriate choice.
upvoted 0 times
...
...
Kristel
3 months ago
I'm not sure, but I think B) GRANT SELECT ON TABLE sales TO team could also be a valid option.
upvoted 0 times
...
Alysa
3 months ago
I disagree, I believe the correct answer is C) GRANT SELECT CREATE MODIFY ON TABLE sales TO team.
upvoted 0 times
...
Helga
3 months ago
The answer is clearly A. Granting full permissions on the table is exactly what the new data engineering team needs to manage the ELT project.
upvoted 0 times
Lisha
2 months ago
B) GRANT SELECT ON TABLE sales TO team;
upvoted 0 times
...
Lovetta
2 months ago
That makes sense, the new team will definitely need full privileges on the table.
upvoted 0 times
...
Rosendo
2 months ago
A) grant all privileges on table sales TO team;
upvoted 0 times
...
...
Kris
3 months ago
I think the answer is A) grant all privileges on table sales TO team.
upvoted 0 times
...

Save Cancel