Exam Certified Data Engineer Professional topic 1 question 217 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 217
Topic #: 1

[All Certified Data Engineer Professional Questions]

The data architect has decided that once data has been ingested from external sources into the
Databricks Lakehouse, table access controls will be leveraged to manage permissions for all production tables and views.

The following logic was executed to grant privileges for interactive queries on a production database to the core engineering group.

GRANT USAGE ON DATABASE prod TO eng;
GRANT SELECT ON DATABASE prod TO eng;

Assuming these are the only privileges that have been granted to the eng group and that these users are not workspace administrators, which statement describes their privileges?

A. Group members are able to create, query, and modify all tables and views in the prod database, but cannot define custom functions.
B. Group members are able to list all tables in the prod database but are not able to see the results of any queries on those tables.
C. Group members are able to query and modify all tables and views in the prod database, but cannot create new tables or views.
D. Group members are able to query all tables and views in the prod database, but cannot create or edit anything in the database.

Show Suggested Answer

Suggested Answer: D 🗳️

by KadELbied at May 5, 2025, 3:52 p.m.

Comments

Submit Cancel

KadELbied

1 month, 2 weeks ago

Selected Answer: D

suretly D

upvoted 1 times

...