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

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 145
Topic #: 4
A data engineer needs to provide access to a group named manufacturing-team. The team needs privileges to create tables in the quality schema. Which set of SQL commands will grant a group named manufacturing-team to create tables in a schema named production with the parent catalog named manufacturing with the least privileges?

Suggested Answer: A Vote an answer

To allow a group to create tables in a schema with least privileges, they need:
- GRANT CREATE TABLE on the schema
- GRANT USE SCHEMA on the schema
- GRANT USE CATALOG on the parent catalog
This ensures proper access without granting unnecessary privileges like creating schemas or catalogs.

by Elva at Apr 04, 2026, 10:49 PM

Limited Time Offer

15%

Off

Get Premium Databricks-Certified-Data-Engineer-Associate Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10