Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam
Go to Exam

Exam Certified Data Engineer Professional topic 1 question 84 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 84
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 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by sturcu at Oct. 25, 2023, 8:03 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
sturcu
Highly Voted 1 year, 1 month ago
Selected Answer: D
Usage and Select ....sa abasically they can only select
upvoted 6 times
...
benni_ale
Most Recent 2 weeks, 6 days ago
Selected Answer: D
D is ok
upvoted 1 times
...
Curious76
9 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
vctrhugo
9 months, 3 weeks ago
Selected Answer: D
The GRANT statements provided in the logic grant the USAGE privilege, allowing the group members to see the existence of the database, and the SELECT privilege, allowing them to query tables and views. However, they do not have permissions to create or edit anything in the database. Therefore, the correct description is that group members can query all tables and views in the prod database but cannot create or edit any objects in the database.
upvoted 1 times
...
divingbell17
10 months, 3 weeks ago
Selected Answer: D
D is correct assuming unity catalog is not enabled
upvoted 1 times
...
aragorn_brego
1 year ago
Selected Answer: D
The GRANT USAGE ON DATABASE statement gives the eng group the ability to access the prod database. This means they can enter the database context and list the tables. The GRANT SELECT ON DATABASE statement additionally grants them permission to perform SELECT queries on all existing tables and views within the prod database. However, these privileges do not include creating new tables or views, modifying existing tables, or assigning permissions to other users or groups.
upvoted 3 times
...
Dileepvikram
1 year ago
D is answer
upvoted 4 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel