Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
The data architect has implemented table access controls to manage permissions for production tables and views in the Databricks Lakehouse after data ingestion from external sources.
The following commands were 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;
GRANT USAGE ON DATABASE prod TO eng;
GRANT SELECT ON DATABASE prod TO eng;
Assuming these are the only privileges granted to the eng group and that its members are not workspace administrators, which statement accurately describes their permissions?
A
Group members have full permissions on the prod database and can also assign permissions to other users or groups.
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.
E
Group members are able to create, query, and modify all tables and views in the prod database, but cannot define custom functions.