Exam Databricks-Certified-Data-Engineer-Professional Topic 1 Question 107 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Professional exam
Question #: 107
Topic #: 1
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: C Vote an answer

To create a table within a schema, a principal must have CREATE TABLE on the schema, USE SCHEMA on that schema, and USE CATALOG on the parent catalog. This combination ensures the group has just enough privileges to create objects in that schema without excessive permissions like CREATE SCHEMA or CREATE CATALOG.

by Carol at Jul 29, 2026, 10:00 AM

Limited Time Offer

15%

Off

Get Premium Databricks-Certified-Data-Engineer-Professional 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