Discuss Databricks Databricks Certified Data Engineer Associate Exam Topic 4 Question 43

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;

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

Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

29 comments · newest first

Mollie 11 months ago

Wait, can you really grant all privileges like that?

Ruthann 11 months ago

D is definitely incorrect, it mixes up the table and team.

Shonda 11 months ago

C sounds weird, not sure about that one.

Linwood 12 months ago

I think B is too limited for full management.

Dwight 12 months ago

Option A is the right command!

Becky 12 months ago

I’m a bit confused about the syntax in option D; it seems mixed up. I don’t think that one is correct.

Eden 1 year ago

I feel like "GRANT SELECT" is too limited for what they need. They need full permissions, right?

Coral 1 year ago

I remember practicing a similar question where we had to grant permissions, and I think "grant all privileges on table sales" was the correct format.

Devorah 1 year ago

I think the command should be something like "GRANT ALL PRIVILEGES," but I'm not sure if it's on the right table.

Annalee 1 year ago

I think the answer is A. The question states we need to grant "full privileges" to the data engineering team, so granting ALL PRIVILEGES on the sales table is the way to go.

Aide 1 year ago

I'm a bit confused by the wording of the question. Does "full privileges" mean we need to grant SELECT, CREATE, and MODIFY permissions? Or is it just granting ALL PRIVILEGES? I'll have to double-check the SQL syntax to be sure.

Julio 1 year ago

Okay, I've got this. The key is that we need to grant ALL PRIVILEGES on the sales table to the data engineering team. So the correct answer is A.

Felton 1 year ago

Hmm, I'm not totally sure about this one. I know we need to grant full permissions to the new data engineering team, but I'm not 100% on the exact syntax. I'll have to think this through carefully.

Tyisha 1 year ago

This looks like a straightforward SQL permissions question. I think the answer is A, "grant all privileges on table sales TO team;".

Mertie 2 years 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.

Yuette 2 years ago

Hmm, I'm going with B. SELECT should be enough for the team to do their job, no need for overkill permissions.

Lamonica 2 years ago

D? Really? Granting all privileges on the table to the team? That's just nonsensical. A is the correct answer here.

Benedict 2 years ago

I think option C is the way to go. Why give them all privileges when they only need SELECT, CREATE, and MODIFY permissions?

Mitsue 2 years ago

↳ replying to Benedict

That makes sense, I'll go with option C as well. Thanks for the input!

Enola 2 years ago

↳ replying to Benedict

I see your point, but it's always best practice to only grant the necessary permissions to limit any potential risks.

Louvenia 2 years ago

↳ replying to Benedict

But wouldn't it be easier to just grant all privileges to avoid any potential issues?

Alana 2 years ago

↳ replying to Benedict

I agree with you, option C seems to be the most appropriate choice.

Kristel 2 years ago

I'm not sure, but I think B) GRANT SELECT ON TABLE sales TO team could also be a valid option.

Alysa 2 years ago

I disagree, I believe the correct answer is C) GRANT SELECT CREATE MODIFY ON TABLE sales TO team.

Helga 2 years 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.

Lisha 2 years ago

↳ replying to Helga

B) GRANT SELECT ON TABLE sales TO team;

Lovetta 2 years ago

↳ replying to Helga

That makes sense, the new team will definitely need full privileges on the table.

Rosendo 2 years ago

↳ replying to Helga

A) grant all privileges on table sales TO team;

Kris 2 years ago

I think the answer is A) grant all privileges on table sales TO team.

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